Nested Data Structures Supported in JSONEachRow Format with New Setting

Why it matters

This feature solves the problem of importing nested JSON data more naturally and accurately into ClickHouse. It enables users to preserve nested object structures when ingesting JSON, improving data fidelity and simplifying the import process for complex JSON formats.

How to use it

To enable this feature, set the input_format_import_nested_json setting to true when reading JSON data using the JSONEachRow input format. For example:

SET input_format_import_nested_json = 1;
<code>SELECT</code> * <code>FROM</code> table <code>FORMAT</code> JSONEachRow;