Skip to content

window-functions.adoc

Latest commit

 

History

History
27 lines (23 loc) · 1.15 KB

window-functions.adoc

File metadata and controls

27 lines (23 loc) · 1.15 KB

Window Functions

Ignite supports aggregate functions in the window form only for the following syntax:

fun() OVER ([PARTITION BY <field> | <exp>])

The following constructs are not supported for window aggregates and will throw an exception:

  • ORDER BY inside the OVER(…​) clause;

  • explicit window frame bounds (ROWS, RANGE, BETWEEN …​ AND …​).