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)