maxcompute正则匹配

SELECT
GET_JSON_OBJECT(name_tmp,’KaTeX parse error: Got function '\newline' with no arguments as superscript at position 1: \̲n̲e̲w̲l̲i̲n̲e̲’,’’),’},\{’,’}|{’) as json_str1
from (
select ‘[{“date”:“2016-09-24”,“period”:1,“custom_dimension”:"",“term_type_id”:14}]’ as json_str
) t1
) t2
lateral view explode(split(json_str1,’\|’)) b AS name_tmp