Treat Empty Cells in CSV as Default Values When the Setting Input_format_defaults_for_omitted_fields Is Enabled

Why it matters

This feature addresses the issue where empty fields in CSV inputs are not interpreted as default values. By enabling this setting, users ensure that empty cells are correctly replaced with the column's default values during data import, improving data consistency and simplifying data handling.

How to use it

Enable the setting input_format_defaults_for_omitted_fields in your client or server configuration before importing CSV data. When this setting is active, empty cells in the CSV input will be treated as default values for their respective columns.