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).
Improved schema inference when input_format_json_read_object_as_string is enabled in JSON input format.

Why it matters

This feature enhances the automatic detection of schema types when the input_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 parameter input_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.