2.12.13 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(). Supported as of MySQL 8.3.0.

  • STDDEV(). Supported as of MySQL 8.3.0.

  • STDDEV_POP(). Supported as of MySQL 8.3.0.

  • STDDEV_SAMP(). Supported as of MySQL 8.3.0.

  • SUM()

  • VAR_POP(). Supported as of MySQL 8.3.0.

  • VAR_SAMP(). Supported as of MySQL 8.3.0.

  • VARIANCE(). Supported as of MySQL 8.3.0.