HeatWave network layer optimizations have improved scalability and network performance.
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.
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
DISTINCTmodifier. Previously, multiple instances of (
DISTINCT) expressions in a query were only permitted if the same
valuewas specified. (Bug #32865043, Bug #33007714)
HeatWave now supports the
WITH ROLLUPmodifier in
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.