This topic describes how to use the string function STR_TO_MAP in Realtime Compute.
Syntax
MAP STR_TO_MAP(VARCHAR text)
MAP STR_TO_MAP(VARCHAR text, VARCHAR listDelimiter, VARCHAR keyValueDelimiter)
Description
This function first uses the separator specified by listDelimiter to split the given text into key-value pairs. Then, this function uses the separator specified by keyValueDelimiter to separate the key and value in each key-value pair. Finally, this function assembles and returns a MAP. The default value of listDelimiter is a comma (,). The default value of keyValueDelimiter is an equal sign (=).
Input parameters
Parameter | Data type | Description |
---|---|---|
text | VARCHAR | The input text. |
listDelimiter | VARCHAR | The separator used between key-value pairs in the input text. The default value is a comma (,). |
keyValueDelimiter | VARCHAR | The separator between the key and value in each key-value pair. The default value is an equal sign (=). |
Notice The listDelimiter and keyValueDelimiter parameters are defined by Java regular expressions.
If a special character is used, it must be escaped.
Test statements
SELECT
STR_TO_MAP('k1=v1,k2=v2')['k1'] as a
FROM T1;
Test results
a (VARCHAR) |
---|
v1 |