[ https://issues.apache.org/jira/browse/CALCITE-4000?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Rui Wang updated CALCITE-4000: ------------------------------ Description: TUMBLE/HOP have an optional "OFFSET" parameter to indicate how many time off from 0 for windowing. The OFFSET parameter is interval type. {code:java} TUMBLE(table, size [, offset]) HOP(table, shift, size, [, offset]) {code} One example: Say here is a TUMBLE call with the following output TUMBLE(table, INTERNVAL '5' MINUTE) ||rowtime||window_start||window_end|| |2020-06-20 12:23:40|2020-06-20 12:20:00|2020-06-20 12:25:00| if using the optional offset parameter TUMBLE(table, INTERNVAL '5' MINUTE, INTERNVAL '2' MINUTE) ||rowtime||window_start||window_end|| |2020-06-20 12:23:40|2020-06-20 12:22:00|2020-06-20 12:27:00| was: TUMBLE/HOP have an optional "OFFSET" parameter to indicate how many time off from 0 for windowing. The OFFSET parameter is interval type. {code:java} TUMBLE(table, size [, offset]) HOP(table, shift, size, [, offset]) {code} One example: Say here is a TUMBLE call with the following output TUMBLE(table, INTERNVAL "5" MINUTE) ||rowtime||window_start||window_end|| |2020-06-20 12:23:40|2020-06-20 12:20:00|2020-06-20 12:25:00| if using the optional offset parameter TUMBLE(table, INTERNVAL '5' MINUTE, INTERNVAL '2' MINUTE) ||rowtime||window_start||window_end|| |2020-06-20 12:23:40|2020-06-20 12:22:00|2020-06-20 12:27:00| > Support OFFSET parameter in TUMBLE/HOP table functions > ------------------------------------------------------- > > Key: CALCITE-4000 > URL: https://issues.apache.org/jira/browse/CALCITE-4000 > Project: Calcite > Issue Type: Sub-task > Reporter: Rui Wang > Assignee: Rui Wang > Priority: Major > > TUMBLE/HOP have an optional "OFFSET" parameter to indicate how many time off > from 0 for windowing. The OFFSET parameter is interval type. > {code:java} > TUMBLE(table, size [, offset]) > HOP(table, shift, size, [, offset]) > {code} > One example: > Say here is a TUMBLE call with the following output > TUMBLE(table, INTERNVAL '5' MINUTE) > ||rowtime||window_start||window_end|| > |2020-06-20 12:23:40|2020-06-20 12:20:00|2020-06-20 12:25:00| > if using the optional offset parameter > TUMBLE(table, INTERNVAL '5' MINUTE, INTERNVAL '2' MINUTE) > ||rowtime||window_start||window_end|| > |2020-06-20 12:23:40|2020-06-20 12:22:00|2020-06-20 12:27:00| -- This message was sent by Atlassian Jira (v8.3.4#803005)