Documentation Home
HeatWave Release Notes
Related Documentation Download these Release Notes
PDF (US Ltr) - 315.0Kb
PDF (A4) - 315.2Kb


HeatWave Release Notes  /  Changes in HeatWave  /  Changes in HeatWave 9.2.0 (2025-01-24, General Availability)

Changes in HeatWave 9.2.0 (2025-01-24, General Availability)

Note

These release notes were created with the assistance of HeatWave GenAI.

HeatWave GenAI

  • The HeatWave GenAI Javascript API now supports batch processing, making it possible to perform multiple operations in a single call. This update introduces new batch processing functions to the LLM class and ml convenience methods, allowing for more efficient embedding, text-based content generation, and Retrieval Augmented Generation (RAG).

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

HeatWave Lakehouse

  • Lakehouse Autopilot can now automatically detect the dialect for CSV files, which lets you load the CSV files without knowing the exact values of the dialect delimiter parameters in advance. This feature automates the detection of record delimiters, field delimiters, and composite record delimiters with field delimiters as prefixes.

    For more information, see Lakehouse External Table Syntax. (WL #16546)

HeatWave MySQL

  • Bulk load, which is used for ingesting data into MySQL Server, now supports the following:

    • Secondary indexes, which enable faster data loading and improved performance. This feature allows for the creation of secondary indexes during the bulk load process, reducing the need for additional ALTER TABLE statements.

    • Faster and more efficient bulk loading of CSV files. This enhancement allows for parallelized CSV parsing, reducing the need for redundant reads and improving overall performance.

    For more information, see Bulk Ingest Data to MySQL Server. (WL #16266, WL #15986)

  • HeatWave now supports JSON tables, enabling you to extract data from JSON documents and return it as relational tables.

    For more information, see JSON Functions. (WL #16450)

  • HeatWave now supports offloading the INSERT INTO SELECT queries to the secondary engine, even when the table being inserted into has triggers defined on it. This enables faster query execution and improved performance for workloads that involve inserting data into tables with triggers.

    For more information, see INSERT ... SELECT Statements. (WL #16235)

  • HeatWave now reloads data from Storage Layer after a planned or unplanned restart of Standalone DB system, thus reducing the recovery time and improving overall system reliability.

    For more information, see Scale-Out Data Management. (WL #14953)