4.6.5 Lakehouse Limitations for the Parquet File Format

• NaN values in Parquet files are loaded as NULL.

• Lakehouse does not support Parquet files with a row group size of more than 500MB.

• Lakehouse does not support these data types in Parquet files: ENUM, UUID, Interval, BSON, List, Map, Unknown. Lakehouse marks columns with these data types as NOT SECONDARY, and does not load them.

• Before MySQL 8.3.0-u2 Lakehouse does not support the JSON data type in Parquet files. MySQL 8.3.0-u2 removes this limitation.