These release notes were created with the assistance of MySQL HeatWave GenAI.
-
MySQL HeatWave Lakehouse now supports a new
datetime_formatparameter in JSON Engine Attribute parameters that lets you specify formats for bothTIMESTAMPandDATETIMEtypes. This update aligns the configuration experience with SQL Syntax and enhances overall usability.For more information, see Dialect Parameters for CSV Files. (WL #17170)
-
MySQL HeatWave Lakehouse now supports specifying stored generated columns when using the
CREATE TABLEstatement for Lakehouse tables. This feature was introduced in 9.5.0 for DB System tables, and this release extends the ability to specify stored generated columns for Lakehouse tables as well. Using stored generated columns lets you create tables with computed values based on existing columns or constants. This enhancement enables you to perform complex data transformations on data at the time of loading or refreshing data from Object Storage and storing it as part of the table.For more information, see Create Tables with Stored Generated Columns. (WL #16995)