Get the App
SLTechnology News&Howtos  ›  Servers  › 

How to use str_to_map in hive

Shulou Source: shulou.com Published: 2022-05-31 20:25:33 11月16日 Update

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!

Tags: Content cases articles Chinese website value instructions interests guys partners more knowledge industry information information channels channels Chinese reference help Apple Docker Huawei Linux macOS MariaDB Microsoft MySQL NVidia OPPO Reno Shulou Tech Info Huawei Shulou Information OPPO Reno Redmi