5.10.5 Lakehouse Limitations for the Parquet File Format

• NaN values in Parquet files are loaded as NULL.

• You can use Lakehouse large shapes to load parquet files with row groups larger than 500MB and upto 10GB and Lakehouse small shapes to load parquet files with row groups lesser than 500MB.

• Lakehouse does not support the following data types in Parquet files. Lakehouse marks columns with these data types as NOT SECONDARY, and does not load them.

  • BSON.

  • ENUM.

  • Interval.

  • List.

  • Map.

  • Unknown.

  • UUID.

• Do not use strict SQL mode if the inferred schema differs from the table schema.