v.1.1.54390New Feature

Added Configuration for Handling Quotes in CSV Data Processing

Official CH changelog text
Added the ability to enable or disable processing single or double quotes when reading data in CSV format. You can configure this in the format_csv_allow_single_quotes and format_csv_allow_double_quotes settings (Amos Bird).
Added settings to enable or disable the processing of single and double quotes when reading CSV data in ClickHouse.

Why it matters

This feature allows users to control whether single quotes or double quotes are recognized and processed as quote characters in CSV input. It addresses cases where CSV data may use non-standard quoting conventions or when quotes should be treated as regular characters, improving flexibility and compatibility with diverse CSV formats.

How to use it

Users can configure the behavior by setting the format_csv_allow_single_quotes and format_csv_allow_double_quotes parameters. Setting these to true or false enables or disables processing of single or double quotes respectively when parsing CSV data.

Related resources

PreviousNext