v.22.2New Feature
Add Schema Inference for Values Table Function
Add schema inference for values table function. Closes #33811. #34017 (Kruglov Pavel).Why it matters
This feature enables ClickHouse to automatically determine the column types and structure when using thevalues table function, simplifying query writing and improving usability by removing the need for manual column definitions.How to use it
Users can simply use thevalues table function without explicitly specifying the schema. For example:SELECT * FROM values
('1', 2), ('3', 4)ClickHouse will infer the data types for each column automatically.