2.14.14 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:

  • AVG()

  • COUNT()

  • MIN()

  • MAX()

  • STD().

  • STDDEV().

  • STDDEV_POP().

  • STDDEV_SAMP().

  • SUM()

  • VAR_POP().

  • VAR_SAMP().

  • VARIANCE().