v.23.5Improvement
Add aliases str_to_map and mapFromString to extractKeyValuePairs
Add aliasstr_to_mapandmapFromStringforextractKeyValuePairs. closes https://github.com/clickhouse/clickhouse/issues/47185. #49466 (flynn).
Why it matters
To improve usability and discoverability by providing more intuitive and descriptive function names for extracting key-value pairs from strings, making it easier for users to parse map-like string data.How to use it
Users can now use eitherstr_to_map or mapFromString in place of extractKeyValuePairs in their SQL queries to extract key-value pairs from strings. For example:SELECT str_to_map('key1=value1,key2=value2')or
SELECT mapFromString('key1=value1,key2=value2')