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

• HeatWave Lakehouse

• Functionality Added or Changed

HeatWave Lakehouse

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

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

Functionality Added or Changed

• 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: Data Load. (WL #15248)

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

  • STD()

  • STDDEV()

  • STDDEV_POP()

  • STDDEV_SAMP()

  • VAR_POP()

  • VAR_SAMP()

  • VARIANCE()

  (WL #15367)

• 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 HeatWave, see: Aggregate Functions. (WL #15914)

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

• HeatWave now supports the following JSON functions:

  • ->

  • ->>

  • JSON_ARRAY()

  • JSON_DEPTH()

  • JSON_EXTRACT()

  • JSON_LENGTH()

  • JSON_OBJECT()

  • JSON_UNQUOTE()

  See: JSON Functions. (WL #15355)