MySQL does not recognise NaN values in CSV files. Replace all NaN values with NULL.
Lakehouse does not support CSV files with more than 4MB per line.