MySQL HeatWave User Guide
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.
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.