hive 解析直接json数组

select get_json_object(col, '$.bssid')
from (
  select '[{"bssid":"6C:59:40:21:05:C4","ssid":"MERCURY_05C4"},{"bssid":"AC:9C:E4:04:EE:52","appid":"10003","ssid":"and-Business"}]' as str
  from dual
) pp
lateral view explode(split(regexp_replace(regexp_extract(pp.str, '^\\[(.+)\\]$', 1),'\\}\\,\\{', '\\}\\|\\|\\{'),'\\|\\|')) ss as col;