Shulou(Shulou.com)05/31 Report--

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!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.