5.3.14 Window Functions

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

MySQL 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().

What's Next

• Learn how to perform the following tasks:

  • Run queries

  • Modify tables

  • Retrieve MySQL HeatWave Metadata

  • Optimize workloads for OLAP and OLTP

  • Monitor MySQL HeatWave processes