v.20.1New Feature

Added JSONCompactEachRow Formats for Input and Output

Added JSONCompactEachRow and JSONCompactEachRowWithNamesAndTypes formats for input and output. #7841 (Mikhail Korotov)
Added JSONCompactEachRow and JSONCompactEachRowWithNamesAndTypes formats for input and output in ClickHouse.

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 of JSONCompactEachRowWithNamesAndTypes. 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, specify JSONCompactEachRow or JSONCompactEachRowWithNamesAndTypes as the input or output format in your queries or client commands, for example:

SELECT * FROM table FORMAT JSONCompactEachRow

or for input:

INSERT INTO table FORMAT JSONCompactEachRowWithNamesAndTypes