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

4.6.4 Lakehouse Limitations for the JSON File Format

  • 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.

  • Lakehouse can only load 64KB of data for each line, and ignores any line with more than 64KB of data.