Changes in HeatWave 8.1.0 (2023-07-18, General Availability)

• HeatWave AutoML

• Functionality Added or Changed

HeatWave AutoML

• HeatWave AutoML has enhanced recommendation systems that can now recommend new users who are similar to a specific user and new items that are similar to other items. See Recommendations. (WL #15674)

• Improvements to HeatWave AutoML models, the model catalog, and ML_MODEL_IMPORT now fully support ONNX and HeatWave AutoML model import. (WL #15383, WL #15559)

Functionality Added or Changed

• Memory-aware query optimization now automatically adjusts HeatWave to optimize query execution time or memory usage and reduce the likelihood of queries running out of memory without user intervention. (WL #15529)

• It is now possible to track the memory used by change propagation and the number of transactions committed to MySQL InnoDB that are waiting to be propagated to HeatWave. (WL #15326, WL #15688)

• HeatWave now accelerates queries with INTERSECT and EXCEPT clauses. With this support, HeatWave can now offload and accelerate all 97 TPC-DS queries. (WL #15362)

• HeatWave now supports the following temporal functions:

  • GET_FORMAT()

  • MAKETIME()

  • PERIOD_ADD()

  • PERIOD_DIFF()

  • SEC_TO_TIME()

  • SUBTIME()

  • SYSDATE()

  • TIMEDIFF()

  (WL #14958)