[
https://issues.apache.org/jira/browse/CALCITE-5450?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17651438#comment-17651438
]
Oliver Lee commented on CALCITE-5450:
-------------------------------------
hey [~julianhyde] ,
Could you explain the comment here regarding no TimeUnit.ISOWEEK?
[https://github.com/apache/calcite/blob/main/core/src/test/java/org/apache/calcite/test/TimeFrameTest.java#L107]
I also see some places that say ISODOW is used instead of ISOWEEK:
[https://github.com/apache/calcite/blob/main/core/src/test/java/org/apache/calcite/test/TimeFrameTest.java#L567]
I've been trying to get the parser to recognize WEEK(SUNDAY) but so far have
been unsuccessful
> Add to parser WEEK(WEEKDAY) for custom time frames
> --------------------------------------------------
>
> Key: CALCITE-5450
> URL: https://issues.apache.org/jira/browse/CALCITE-5450
> Project: Calcite
> Issue Type: Improvement
> Reporter: Oliver Lee
> Priority: Minor
>
> Some BIG_QUERY functions (i.e. {{{}EXTRACT(){}}}, {{DATE_TRUNC()}} ) can
> accept the operand
> {{WEEK(WEEKDAY)}} where {{WEEKDAY}} is one of {{SUNDAY, MONDAY, TUESDAY,
> WEDNESDAY, THURSDAY, FRIDAY, SATURDAY}}
>
> This is not currently supported.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
