v.25.4Improvement

Implement comparison

Official CH changelog text
Implement comparison for values of JSON data type. Now JSON objects can be compared similarly to Maps. #77397 (Pavel Kruglov).
Implemented comparison operators for JSON data type values, enabling JSON objects to be compared similarly to Maps.

Why it matters

This feature allows users to directly compare JSON values in queries, solving the problem of lack of native comparison support for JSON data. It enhances querying capabilities and simplifies operations involving JSON data.

How to use it

Users can now use standard comparison operators (such as =, <, >) directly on JSON typed columns or values in SQL queries, as they do with Map types.

Related resources

PreviousNext