Versions Compared

Old Version 7

changes.mady.by.user user-de39f

Saved on

compared with

New Version Current

changes.mady.by.user user-de39f

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: <unit> values

...

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>]

Possible For valid values for <unit> are:

...

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:

...