v.21.11New Features
Added JSONExtractKeys Function
Why it matters
This function allows users to extract the keys from a JSON object, enabling easier inspection and manipulation of JSON data stored in ClickHouse tables.How to use it
Invoke theJSONExtractKeys function by passing a JSON string or column containing JSON data, for example:SELECT JSONExtractKeys(json_column) FROM table_name;This will return an array of keys present in the JSON object.