v.23.10New Feature

Added jsonMergePatch Function for Merging JSON Strings

Official CH changelog text
Added function jsonMergePatch. When working with JSON data as strings, it provides a way to merge these strings (of JSON objects) together to form a single string containing a single JSON object. #54364 (Memo).
Added the jsonMergePatch function to ClickHouse, enabling the merging of JSON objects represented as strings into a single JSON object string.

Why it matters

This feature addresses the need to combine multiple JSON strings into one consolidated JSON object, simplifying JSON data manipulation and aggregation workflows within ClickHouse.

How to use it

Use the jsonMergePatch function in queries by passing JSON-formatted strings as arguments. It will return a single JSON string resulting from merging these JSON objects according to JSON Merge Patch semantics.

Related resources

PreviousNext