11.2.2.4 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, see: The JSON Data Type.