日本免费高清视频-国产福利视频导航-黄色在线播放国产-天天操天天操天天操天天操|www.shdianci.com

學無先后，達者為師

網站首頁 編程語言 正文

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 默認分隔符為":"

demo

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

欄目分類
最近更新