v.20.1New Feature
Added JSONCompactEachRow Formats for Input and Output
AddedJSONCompactEachRowandJSONCompactEachRowWithNamesAndTypesformats for input and output. #7841 (Mikhail Korotov)
Why it matters
These new JSON formats provide more compact representations of data rows, optimizing storage and transmission efficiency while preserving schema information in the case ofJSONCompactEachRowWithNamesAndTypes. This benefits users who want efficient JSON interaction with ClickHouse, especially for data interchange and integration scenarios.How to use it
To use these formats, specifyJSONCompactEachRow or JSONCompactEachRowWithNamesAndTypes as the input or output format in your queries or client commands, for example:SELECT * FROM table FORMAT JSONCompactEachRowor for input:
INSERT INTO table FORMAT JSONCompactEachRowWithNamesAndTypes