v.21.7New Feature

Add toJSONString Function for JSON Serialization of Columns

Official CH changelog text
Add toJSONString function to serialize columns to their JSON representations. #25164 (Amos Bird).
Introduces the toJSONString function for serializing ClickHouse columns into their JSON string representations.

Why it matters

This feature allows users to easily convert column data into JSON format, simplifying data interchange and integration with JSON-based systems or applications.

How to use it

Use the toJSONString function in your queries to serialize one or multiple columns to JSON strings. For example:

SELECT toJSONString(column_name) FROM table_name;

Related resources

PreviousNext