v.24.3Improvement

Make Format Names Case Insensitive

Official CH changelog text
Make all format names case insensitive, like Tsv, or TSV, or tsv, or even rowbinary. #60420 (豪肥肥). I appreciate if you will continue to write it correctly, e.g., JSON 😇, not Json 🤮, but we don't mind if you spell it as you prefer.
Case Insensitive Format Names: ClickHouse now supports format names in a case-insensitive manner, allowing users to specify formats like Tsv, TSV, tsv, or even rowbinary interchangeably.

Why it matters

This feature removes the restriction of case sensitivity for format names, improving usability by allowing more flexible input and reducing errors caused by case mismatches. It makes working with data input and output formats more convenient and user-friendly.

How to use it

Users can specify any format name in any case (uppercase, lowercase, or mixed) when working with formats in ClickHouse queries. For example, the following are all valid:

SELECT  FROM table FORMAT TSV;
SELECT  FROM table FORMAT tsv;
SELECT * FROM table FORMAT TsV;

The feature works automatically without any configuration changes.

Related resources

PreviousNext