v.22.3New Feature

Support Schema Inference for Table Functions with File, HDFS, S3, and URL Input

Support schema inference for inserting into table functions file/hdfs/s3/url. #34732 (Kruglov Pavel).
Added support for schema inference when inserting data into table functions file, hdfs, s3, and url.

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 functions file, 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.