Changes in HeatWave 9.1.0 (2024-10-15, General Availability)

• HeatWave GenAI

• HeatWave Lakehouse

• HeatWave MySQL

HeatWave GenAI

• HeatWave GenAI now lets you extract and encode text from images stored in unstructured documents using Optical Character Recognition (OCR). The extracted text is converted into vector embeddings and stored in a vector store the same way regular text in unstructured documents is encoded and stored in a vector store.

  For more information, see About Optical Character Recognition. (WL #16474)

• MySQL JavaScript Stored Programs now include a new GenAI API that you can use to call different HeatWave GenAI routines using JavaScript functions.

  For more information, see JavaScript GenAI API. (WL #16487)

HeatWave Lakehouse

• HeatWave Lakehouse now supports Zone Maps, which helps you improve range queries in OLAP and mixed workloads.

  MySQL HeatWave uses statistics based on minimum and maximum values to create zone maps for every primary key column. It then uses the zone maps for range and point queries to only scan data chunks that are relevant for the query, and accelerates these queries by an order of magnitude. (WL #16414)

HeatWave MySQL

• Auto Parallel Load now uses Autopilot to collect statistics about frequently used InnoDB and HeatWave tables. Auto Parallel Load then automatically loads these tables to HeatWave. If a manually loaded table might cause a memory conflict, Auto Unload unloads automatically loaded tables to free up memory. (WL #15491)

• HeatWave now supports InnoDB partitions, and INFORMATION_SCHEMA.PARTITIONS includes a SECONDARY_LOAD column that indicates whether a partition has been loaded.

  When an unload operation successfully unloads the last partition, it unloads the whole table.

  HeatWave MySQL now persists partition information, and during a restart, only the previously loaded partitions are loaded.

  For more information, see Loading Partitions (WL #15517, WL #16268)