Related Documentation Download this Manual
PDF (US Ltr) - 0.6Mb
PDF (A4) - 0.6Mb


HeatWave User Guide  /  ...  /  Window Functions

11.2.10 Window Functions

This section describes HeatWave window function support. For optimal performance, window functions in HeatWave utilize a massively parallel, partitioning-based algorithm. For general information about window functions, see Window Functions, in the MySQL Reference Manual.

HeatWave window function support includes support for:

  • WINDOW and OVER clauses in conjunction with PARTITION BY, ORDER BY, and WINDOW frame specifications.

  • Nonaggregate window functions supported by MySQL Server, as described in Window Function Descriptions.

  • The following aggregate functions used as window functions: