v.23.7New Feature
Add input_format_csv_allow_variable_number_of_columns option
Add input_format_csv_allow_variable_number_of_columns options. #51273 (Dmitry Kardymon).Why it matters
This feature addresses the problem of importing CSV data where rows may have different numbers of columns. It provides flexibility during data ingestion by allowing ClickHouse to handle CSV files with varying column counts without errors.How to use it
To enable this feature, set theinput_format_csv_allow_variable_number_of_columns option to true when importing CSV data. This can be done by specifying it in the client settings or query settings before reading the CSV input.