v.20.4New Feature
Add JSONExtractKeysAndValuesRaw function for extracting raw data from JSON objects
Add function JSONExtractKeysAndValuesRaw which extracts raw data from JSON objects #10378 (hcz)Why it matters
This feature allows users to efficiently extract raw key-value pairs from JSON objects without parsing or type conversion, providing more control and flexibility when working with JSON data in ClickHouse.How to use it
Use the functionJSONExtractKeysAndValuesRaw in your queries to extract keys and their corresponding raw JSON values from JSON objects. For example:SELECT JSONExtractKeysAndValuesRaw(json_column) FROM table_name;