How to use str_to_map in hive
This article mainly introduces how to use str_to_map in hive. It is very detailed and has a certain reference value. Friends who are interested must finish it!
ApacheCN | apache Chinese website
Instructions for use:
Https://cwiki.apache.org/confluence/display/Hive/LanguageManual+UDF
Map
Str_to_map (text [, delimiter1, delimiter2])
Splits text into key-value pairs using two delimiters. Delimiter1 separates text into Kmuri V pairs, and Delimiter2 splits each Kmuri V pair. Default delimiters are', 'for delimiter1 and' = 'for delimiter2.
Case 1:
Hive >
> select str_to_map ('aaa:11&bbb:22',' &',':')
> from tmp.tmp_jzl_20140725_test11
OK
{"bbb": "22", "aaa": "11"}
Case 2:
Hive > select str_to_map ('aaa:11&bbb:22',' &',':') ['aaa']
> from tmp.tmp_jzl_20140725_test11
OK
eleven
The above is all the contents of the article "how to use str_to_map in hive". Thank you for reading! Hope to share the content to help you, more related knowledge, welcome to follow the industry information channel!