v.22.5Improvement
Add JSONLines and NDJSON aliases for JSONEachRow
Add aliasesJSONLinesandNDJSONforJSONEachRow. Closes #36303. #36327 (flynn).
Why it matters
This feature addresses the common usage of different names for the same JSON format. By adding aliases, it improves usability and user experience by allowing users to specify the input or output format using more familiar or standard names for newline-delimited JSON data.How to use it
Users can simply useJSONLines or NDJSON wherever they would use JSONEachRow as a format specifier in ClickHouse commands, for example:SELECT * FROM table FORMAT JSONLines;or
INSERT INTO table FORMAT NDJSONThese aliases work interchangeably with
JSONEachRow.