Changes in MySQL HeatWave 8.4.0 (2024-04-30, General Availability)

• MySQL HeatWave Lakehouse

• Functionality Added or Changed

MySQL HeatWave Lakehouse

• MySQL HeatWave Lakehouse now supports primary key and unique key constraint validation with the check_constraints parameter. When you set this parameter to true, a validation for primary key and unique key constraints occurs only during the initial load of a table. (WL #16094)

• MySQL HeatWave Lakehouse now supports the Newline Delimited JSON file format, see Supported File Formats and Data Types. (WL #16079)

• MySQL HeatWave Lakehouse now has improved support for missing files. Auto Parallel Load now has a validation mode to validate files before loading them. (WL #16078)

Functionality Added or Changed

• MySQL HeatWave now supports named time zones such as MET or Europe/Amsterdam. (WL #16098)

• MySQL HeatWave Auto Parallel Load and Auto Unload now support a table inclusion list, as well as a table exclusion list. (WL #16070)

• MySQL InnoDB on MySQL HeatWave includes a bulk load extension to the LOAD DATA statement. This can now load MySQL Shell dump files and compressed files. There is also a progress monitor. See: Bulk Ingest Data. (WL #15814, WL #15607, WL #15608, WL #15609)