v.1.1.54388New Feature

Support for Custom CSV Delimiters

Support for custom CSV delimiters (Ivan Zhukov)
Added support for custom CSV delimiters in ClickHouse's CSV format handling.

Why it matters

This feature allows users to specify custom delimiters when importing or exporting CSV data, providing flexibility for handling CSV files that use delimiters other than the default comma. It resolves compatibility issues with CSV files that use different field separators, enhancing data import/export capabilities.

How to use it

Users can enable custom CSV delimiters by specifying the format_csv_delimiter setting with the desired delimiter character when using CSV format in queries. For example, add FORMAT CSV SETTINGS format_csv_delimiter=';' to use semicolon as delimiter.