Changes in HeatWave 8.2.0 (2023-10-25, General Availability)

Functionality Added or Changed

• HeatWave Guided Load reduces the number of steps to manually load data, see Loading Data Manually. (WL #15811)

• HeatWave now supports the following string functions:

  • BIN()

  • BIT_LENGTH()

  • ELT()

  • EXPORT_SET()

  • FIELD()

  • MAKE_SET()

  These functions do not support ENUM type columns, see Data Type Limitations. (WL #15628)

• HeatWave now supports full-table aggregation and group-by support for the following temporal data types:

  • DATE

  • TIME

  • DATETIME

  • TIMESTAMP

  • YEAR

  HeatWave now accelerates queries that contain the following functions with temporal data types:

  • SUM()

  • AVG()

  • STD()

  • STDDEV()

  • STDDEV_POP()

  • STDDEV_SAMP()

  • VAR_POP()

  • VAR_SAMP()

  • VARIANCE()

  See: Aggregate Functions. (WL #15637)

• HeatWave now enables the internal conversion of values from one data type to another, including all combinations of these different encodings:

  • Numeric values INTEGER, FLOAT, and DECIMAL.

  • String values, excluding dictionary-encoded strings.

  • Temporal values DATE, TIME, DATETIME, and YEAR data types.

  This now permits HeatWave to offload queries that contain functions with unexpected data types by adding an internal cast from the unexpected data type to an expected data type. (WL #15465)