网站首页编程语言正文

HIVE str_to_map将字符串转为map格式

作者：NoOne-csdn 更新时间： 2022-04-01 编程语言

将字符串转为map格式


map<string,string>	str_to_map(text[, delimiter1, delimiter2])	Splits text into key-value pairs using two delimiters. Delimiter1 separates text into K-V pairs, and Delimiter2 splits each K-V pair. Default delimiters are ‘,’ for delimiter1 and ‘:’ for delimiter2.

delimiter1 将文本分为K-V 键值对， delimiter2 分割K-V。

delimiter1 默认分隔符为","
delimiter2 默认分隔符为":"

SELECT
  str_to_map('a=1,b=2',',','=') as m1,
  str_to_map('a:1,b:2,c:3',',',':') as m2,
  str_to_map('a:1,b:2,c:3') as m3

输出

{"a":"1","b":"2"}
{"a":"1","b":"2","c":"3"}
{"a":"1","b":"2","c":"3"}

原文链接：https://blog.csdn.net/weixin_40161254/article/details/120830574