Details
-
Sub-task
-
Status: Closed
-
Major
-
Resolution: Fixed
-
None
-
None
Description
TUMBLE/HOP have an optional "OFFSET" parameter to indicate how many time off from 0 for windowing. The OFFSET parameter is of interval type.
TUMBLE(table, size [, offset]) HOP(table, size, shift, [, offset])
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 |
| 2020-06-20 12:21: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 |
| 2020-06-20 12:21:40 | 2020-06-20 12:17:00 | 2020-06-20 12:22:00 |
OFFSET is applied per window basis, so the example above will also apply for HOP.
