...
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>] SELECT * FROM <source> [SIZE <size> <unit> ADVANCE <advance size> <unit> TIME PARTITION BY <partition attribute>] |
...