格式如下:
[{"website":"baidu.com","name":"百度"},{"website":"google.com","name":"谷歌"}]
用以下脚本可以将这列数据解析成两行
SELECT explode(split(regexp_replace(regexp_replace('[{"website":"baidu.com","name":"百度"},{"website":"google.com","name":"谷歌"}]', '\\[|\\]',''),'\\}\\,\\{','\\}\\;\\{'),'\\;'));