hive: str_to_map()

hive-str_to_map.sql

-- STR_TO_MAP 사용법 
SELECT STR_TO_MAP("key1: value1, key2: value2, key3: value3", list_delimiter, key_value_delimiter);

-- example #1
hive> SELECT STR_TO_MAP("key1: value1, key2: value2, key3: value3", ",", ":");
OK
{"key1":" value1"," key3":" value3"," key2":" value2"}
Time taken: 0.049 seconds, Fetched: 1 row(s)

-- json string to map
hive> SELECT STR_TO_MAP(REPLACE(
    >         REPLACE(
    >             REPLACE(
    >                 REPLACE('{ "name": "json", "class": "math", "age": 15 }', '{', '')
    >                     , '}', '')
    >                         , '"', ''), ' ', '')
    >                             , ",", ":")
    > ;
OK
{"name":"json","class":"math","age":"15"}