MySQL :: HeatWave User Guide :: 11.2.2.4 Lakehouse Limitations for the JSON File Format

HeatWave User Guide / ... / Lakehouse Limitations for the JSON File Format

MySQL HeatWave Lakehouse has the following limitations for JSON files.

As of MySQL 9.3.1, Lakehouse can load up to 4192192 bytes (~4MB) of data per line, and ignores any lines with more than this limit. Before MySQL 9.3.1, this limit is 65532 bytes.

Note

The JSON size is measured after Lakehouse extracts and converts JSON data to JSON DOM representation internally.
As of MySQL 8.4.0, Lakehouse only supports Newline Delimited JSON.
Tables created with json format must only have a single column that conforms to the JSON data type. In addition, stored generated columns or the _metadatq_filename column can be part of the table schema. See The JSON Data Type.
As of MySQL 9.6.1, the JSON format is supported with stored generated columns. In earlier versions, it is not supported.

PREV HOME UP NEXT