v.22.2Improvement

Enhance schema inference in clickhouse-local for simplified data querying

Improve schema inference in clickhouse-local. Allow to write just clickhouse-local -q "select * from table" < data.format. #34495 (Kruglov Pavel).
Improved schema inference in clickhouse-local allowing users to run queries directly on raw data files without explicitly specifying the input format schema.

Why it matters

This feature simplifies the usage of clickhouse-local by enabling automatic schema detection from data files. Users no longer need to manually define the schema or specify detailed input format parameters, making it easier and faster to query local data.

How to use it

Run queries on local data files by using the command:

clickhouse-local -q "select * from table" < data.format


This will automatically infer the schema from the input data, eliminating the need for additional schema definitions.