MySQL HeatWave User Guide
MySQL HeatWave Lakehouse has the following limitations for delta lake tables.
Support for delta lake tables is restricted to delta tables with features enabled by default by a Spark client.
Writing, updating, and creating of delta lake tables in MySQL HeatWave Lakehouse is not supported. Only reading of delta lake tables is supported.
For partitioned tables, loading columns that are part of
the partitioning key is not supported. These columns must
be tagged as NOT SECONDARY. When
loading tables with Auto Parallel Load, these columns are inferred as
NOT SECONDARY.
Loading of empty tables is not supported.
Loading of tables located at the root of an Object Store bucket is not supported.
Loading tables with deletion vectors or column-mapping properties enabled is not supported.
The following delta lake data types are not supported:
BINARY
GEOGRAPHY
GEOMETRY
ARRAY (with the exception of arrays of simple types, which are inferred as JSON)
MAP
MAP
STRUCT
VARIANT
OBJECT