v.20.10New Feature

Add JSONStrings format for string array output

Official CH changelog text
Add JSONStrings format which output data in arrays of strings. #14333 (hcz).
Introduces the JSONStrings output format in ClickHouse, which presents query results as arrays of strings.

Why it matters

The JSONStrings format solves the problem of uniformly representing all data as strings in JSON arrays, which can be useful for front-end applications or systems that expect JSON arrays of strings regardless of the original data types.

How to use it

Use the JSONStrings format by specifying it in your query's output format clause, for example:

sql<br>SELECT * FROM table FORMAT JSONStrings<br>

Related resources

PreviousNext