11.2.2.6 Limitations for Delta Lake Tables

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