Changes in MySQL HeatWave 8.2.0-u1 (2023-12-05, General Availability)

• MySQL HeatWave Lakehouse

• Functionality Added or Changed

MySQL HeatWave Lakehouse

• MySQL HeatWave Lakehouse now uses Auto Parallel Load to load Avro files. (WL #15778)

• MySQL HeatWave Lakehouse schema inference now includes support for unicode column headers. (WL #16011)

Functionality Added or Changed

• MySQL HeatWave secondary engine now supports the QUALIFY clause to use with SELECT statements. (WL #15864)

• Auto Data Compression dynamically determines which compression algorithm to use for each column based on its data characteristics. This provides the optimum balance between memory usage and query performance. See: About MySQL HeatWave. (WL #15248)

• MySQL HeatWave now supports the following aggregate functions used as window functions:

  • STD()

  • STDDEV()

  • STDDEV_POP()

  • STDDEV_SAMP()

  • VAR_POP()

  • VAR_SAMP()

  • VARIANCE()

  (WL #15367)

• MySQL HeatWave secondary engine now supports the HyperLogLog, HLL() aggregate function. This is similar to COUNT(DISTINCT), but faster and with user defined precision. This is only available in MySQL HeatWave, see: Aggregate Functions. (WL #15914)

• The GROUP BY clause permits a CUBE modifier. This is only available in MySQL HeatWave, see: GROUP BY Modifiers . (WL #15843)

• MySQL HeatWave now supports the following JSON functions:

  • ->

  • ->>

  • JSON_ARRAY()

  • JSON_DEPTH()

  • JSON_EXTRACT()

  • JSON_LENGTH()

  • JSON_OBJECT()

  • JSON_UNQUOTE()

  See: JSON Functions. (WL #15355)