Changes in HeatWave 8.0.26-u1 (2021-08-10, General Availability)

• HeatWave Network Layer

• HeatWave Data Management Layer

• Functionality Added or Changed

HeatWave Network Layer

• HeatWave network layer optimizations have improved scalability and network performance. (WL #14513)

HeatWave Data Management Layer

• Data loaded into HeatWave, including propagated changes, are now persisted to OCI Object Storage for recovery in case of a HeatWave node or cluster failure. Previously, data was recovered from the MySQL DB System. Loading data from OCI Object Storage is faster because data does not need to be converted to the HeatWave storage format, as is required when loading data from the MySQL DB System. If data recovery from OCI Object Storage fails, HeatWave falls back to recovering data from the MySQL DB System. Data removed from HeatWave when a table is unloaded is removed from OCI Object Storage in a background operation. For related information, see HeatWave Cluster Failure and Recovery. (WL #14478, WL #14046, WL #14541)

Functionality Added or Changed

• HeatWave now supports COUNT(NULL), except in cases where it is used as an input argument for non-aggregate operators. (Bug #33005146)

• Full support was added for the DISTINCT modifier. Previously, multiple instances of (DISTINCT value) expressions in a query were only permitted if the same value was specified. (Bug #32865043, Bug #33007714, WL #14574)

• HeatWave now supports the WITH ROLLUP modifier in GROUP BY clauses. (WL #14533)

• HeatWave now supports window functions. For optimal performance, window functions in HeatWave utilize a massively parallel, partitioning-based algorithm. For more information, see Window Functions. (WL #14674)