sql-整理

Hive解析Json数组
https://bigdata.51cto.com/art/202104/660074.htm

select 
get_json_object('{"name":"zhangsan","age":18}','$.name');



select  
b.name 
,b.age 
from tableName a lateral view 
json_tuple('{"name":"zhangsan","age":18}','name','age') b as name,age; 



SELECT explode(split( 
    regexp_replace( 
        regexp_replace( 
            '[ 
                {"website":"baidu.com","name":"百度"}, 
                {"website":"google.com","name":"谷歌"} 
            ]',  
            '\\[|\\]' , ''), 将json数组两边的中括号去掉 
             
              '\\}\\,\\{' , '\\}\\;\\{'