v.23.1Improvement
Enable JSON Input Format for Reading Nested Objects by Default
Enable input_format_json_read_objects_as_strings by default to be able to read nested JSON objects while JSON Object type is experimental. #44657 (Kruglov Pavel).Why it matters
This feature addresses the challenge of parsing nested JSON data by treating nested objects as strings, providing a stable method to ingest complex JSON structures without relying on the experimental JSON Object type. It improves robustness and usability when working with nested JSON inputs.How to use it
The settinginput_format_json_read_objects_as_strings is now enabled by default. Users can simply import nested JSON data without additional configuration. To override this behavior, set input_format_json_read_objects_as_strings to 0 explicitly in the session or server configuration.