zachjsh commented on code in PR #15836: URL: https://github.com/apache/druid/pull/15836#discussion_r1481932260
########## docs/multi-stage-query/reference.md: ########## @@ -199,6 +199,33 @@ The following ISO 8601 periods are supported for `TIME_FLOOR` and the string con - P3M - P1Y +The string constant can also include any of the keywords mentioned above: + +- `HOUR` - Same as `'PT1H'` +- `DAY` - Same as `'P1D'` +- `MONTH` - Same as `'P1M'` +- `YEAR` - Same as `'P1Y'` +- `ALL TIME` +- `ALL` - Alias for `ALL TIME` + +The `WEEK` granularity is deprecated and not supported in MSQ. + +Examples: + +```SQL +-- Keyword +PARTITIONED BY HOUR + +-- String constant +PARTITIONED BY 'HOUR' + +-- Or Review Comment: fixed ########## docs/multi-stage-query/reference.md: ########## @@ -199,6 +199,33 @@ The following ISO 8601 periods are supported for `TIME_FLOOR` and the string con - P3M - P1Y +The string constant can also include any of the keywords mentioned above: + +- `HOUR` - Same as `'PT1H'` +- `DAY` - Same as `'P1D'` +- `MONTH` - Same as `'P1M'` +- `YEAR` - Same as `'P1Y'` +- `ALL TIME` +- `ALL` - Alias for `ALL TIME` + +The `WEEK` granularity is deprecated and not supported in MSQ. + +Examples: + +```SQL +-- Keyword +PARTITIONED BY HOUR + +-- String constant Review Comment: fixed -- 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]
