...
A time-based window is defined by the size of the window as time span and an optional advance parameter. The latter defines after what time span the window should move (if no unit is declared, it has the same unit as size). Additional, a partition attribute can be defined. Syntax:
Code Block |
---|
SELECT * FROM <source> [SIZE <size> <unit> TIME] SELECT * FROM <source> [SIZE <size> <unit> ADVANCE <advance size> TIME] SELECT * FROM <source> [SIZE <size> <unit> ADVANCE <advance size> <unit> TIME] SELECT * FROM <source> [SIZE <size> <unit> TIME PARTITION BY bid.auction] SELECT * FROM <source> [SIZE <size> <unit> ADVANCE <advance size> TIME PARTITION BY <partition attribute>] |
Possible values for <unit> are:
...
SELECT * FROM <source> [SIZE <size> <unit> ADVANCE <advance size> <unit> TIME PARTITION BY <partition attribute>] |
For valid values for <unit> see TimeWindow
...
.
A tuple-based window is defined by the size of the window as number of tuples and an optional advance parameter. The latter defines after how many tuples the window should move. Additional, a partition attribute can be defined. Syntax:
...