v.21.8Improvement

Allow JSONExtract to Return Non-String Elements as Strings

Official CH changelog text
Allow extracting of non-string element as string using JSONExtract. This is for #25414. #25452 (Amos Bird).
Allows extracting non-string JSON elements as strings using the JSONExtract function.

Why it matters

This feature addresses the limitation where JSONExtract could only extract string elements from JSON. It enables users to extract non-string elements (such as numbers, booleans, etc.) and receive them as strings, improving flexibility when working with JSON data in ClickHouse.

How to use it

Use the JSONExtract function as usual to extract elements from JSON data. With this enhancement, non-string elements will now be returned as their string representation without additional conversion steps.

Related resources

PreviousNext