v.24.11Experimental Feature

Implement JSON Serialization/Deserialization for Map/Tuple/Object Conversion

Official CH changelog text
Implement simple CAST from Map/Tuple/Object to new JSON through serialization/deserialization from JSON string. #71320 (Pavel Kruglov).
Implemented simple CAST operations from Map, Tuple, and Object data types to the new JSON data type using serialization and deserialization through JSON strings.

Why it matters

This feature addresses the need for easy and direct type conversion to the new JSON type in ClickHouse, enabling users to convert complex data structures such as Map, Tuple, and Object into JSON format effortlessly. It simplifies data processing and integration workflows where JSON output is required.

How to use it

Users can perform simple CAST operations in their SQL queries to convert Map, Tuple, or Object values into JSON by casting with syntax like:

sql<br>SELECT CAST(your_map_or_tuple_or_object_column AS JSON) FROM your_table<br>
This will serialize the source data type into a JSON string during the cast.

Related resources

PreviousNext