v.23.1Improvement
Improve Schema Inference with JSON Object Reading Enabled
Improve schema inference when input_format_json_read_object_as_string is enabled. #44546 (Kruglov Pavel).Why it matters
This feature enhances the automatic detection of schema types when theinput_format_json_read_object_as_string setting is enabled, allowing ClickHouse to better interpret JSON objects passed as strings. It solves the problem of inaccurate or suboptimal schema inference in this mode, providing users with more accurate data parsing and improved data ingestion reliability.How to use it
Enable the feature by setting the parameterinput_format_json_read_object_as_string to 1 before importing JSON data. This helps ClickHouse infer the schema correctly when reading JSON objects as strings during data input processes.