v.21.8Improvement
Support LowCardinality, Decimal, and UUID for JSONExtract
SupportLowCardinality,Decimal, andUUIDforJSONExtract. Closes #24606. #25900 (Kseniia Sumarokova).
Why it matters
This feature enables users to directly extract and parse JSON fields asLowCardinality, Decimal, and UUID types, expanding the versatility of JSON data handling and improving query precision and performance when working with these data types.How to use it
Use theJSONExtract function with the desired data type specified, for example:SELECT JSONExtract(json_column, 'field_name', 'LowCardinality(String)') FROM table;This works similarly for
Decimal and UUID types by specifying the appropriate type name.