Tanner Clary created CALCITE-5600:
-------------------------------------
Summary: Allow EXTRACT() to accept custom time frames
Key: CALCITE-5600
URL: https://issues.apache.org/jira/browse/CALCITE-5600
Project: Calcite
Issue Type: Improvement
Reporter: Tanner Clary
Assignee: Tanner Clary
This is a sibling issue of [CALCITE-5449].
The {{EXTRACT}} function does not currently accept custom time frames such as
{{MINUTE15}}. There is some ambiguity regarding what behavior these time frames
would produce. For instance, would {{EXTRACT(DAY21 ...)}} return the same
answer as {{EXTRACT(WEEK3 ... )}}?
One possible solution is to treat {{EXTRACT(UNIT(X) ..)}} as {{EXTRACT(UNIT
...) / X}}.
An advantage would be that a lot of the existing {{EXTRACT}} logic could be
used, with an additional modulus operation performed to account for the X
multiplier afterwards.
Most likely this will not be implemented until after the resolution of
CALCITE-5449 which should hopefully provide additional clarity (which I will
update this case with) as to how best go about this. As always, comments and
suggestions appreciated.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
