v.20.5New Feature
Add JSONAsString Input Format for Multiple JSON Objects
Add new input format JSONAsString that accepts a sequence of JSON objects separated by newlines, spaces and/or commas. #10607 (Kruglov Pavel).Why it matters
This feature addresses the need to parse multiple JSON objects in a single input stream even if they are separated by spaces, newlines, or commas. It improves flexibility and robustness when ingesting JSON data that is formatted as a sequence of objects rather than a single JSON array. This helps users load JSON data more easily without strict formatting requirements.How to use it
To use this feature, specify the input format asJSONAsString when importing data, for example in the FORMAT clause of an INSERT statement or when defining the input format for file imports.