Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

The most different parts between usual SQL and CQL is the FROM part, because you have the possibility to definie windows. CQL defines them by squared brackets.

The following parameters are available for time based windows (TIME):

  • SIZE: Defines the size of the window, e.g. 60 MINUTES
  • ADVANCE: After what time will the window move

The following parameters are available for element based windows (TUPLE)

  • SIZE: Defines the size of the window in elements
  • ADVANCE: After how many elements is the window moved

Futher information about windows can be found here

Where

Code Block
languagejava
... WHERE auction > 10 ...

...