v.22.3New Feature
Support Schema Inference for Table Functions with File, HDFS, S3, and URL Input
Support schema inference for inserting into table functionsfile/hdfs/s3/url. #34732 (Kruglov Pavel).
Why it matters
This feature automates the process of inferring the schema of data being inserted into external storage via these table functions, eliminating the need for users to manually define the schema. It simplifies data ingestion workflows and reduces configuration errors.How to use it
When inserting data using the table functionsfile, hdfs, s3, or url, ClickHouse will automatically infer the schema from the data if the schema is not explicitly specified. Users can continue to use the INSERT INTO statement as usual without needing to provide the column structure for these functions.