mayankshriv opened a new pull request, #12790: URL: https://github.com/apache/pinot/pull/12790
Add support for the Postgres SQL date_bin function (ref https://www.postgresql.org/docs/current/functions-datetime.html#FUNCTIONS-DATETIME-BIN). - The 'stride' or 'binWidth' is specified in the `Period` format. For example: `1d` : for 1 day `24h` : for 24 hours `1h30m` : for 1 hours and 30 minutes - The granularities supported for `stride` are `seconds`, `minutes`, `hours` and `days`. - The `source` and `origin` times are in `Timestamp` format which is in local time zone in Pinot. Example Queries: `select date_bin(`3h`, '2024-03-10 23:29:55.0', '2024-01-01 00:00:00.0') from myTable` `select date_bin(`3h`, myTimeColumn, '2024-01-01 00:00:00.0') from myTable` Instructions: 1. The PR has to be tagged with at least one of the following labels (*): 1. `feature` 2. `bugfix` 3. `performance` 4. `ui` 5. `backward-incompat` 6. `release-notes` (**) 2. Remove these instructions before publishing the PR. (*) Other labels to consider: - `testing` - `dependencies` - `docker` - `kubernetes` - `observability` - `security` - `code-style` - `extension-point` - `refactor` - `cleanup` (**) Use `release-notes` label for scenarios like: - New configuration options - Deprecation of configurations - Signature changes to public methods/interfaces - New plugins added or old plugins removed -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
