045.hive-hive解析json-json_tuple

get_json_object(string json_string, string path) 无法解析汉字

get_json_object('{"movie":"594","rate":"4","timeStamp":"978302268","uid":"1"}','$.movie');

 

json_tuple 可以解析汉字

 

-- 解析{"冷热度":"正常冰","甜度":"标准风味"}
 select 
 a.attribute
 ,a.order_code 
 ,b.lengre
 ,b.tiandu
 from 
( select * from  dwd_biz_item_di 
     where     
      dt >=20221001 
     and 
     dt <=20221031  
    
)  a lateral view 
json_tuple(a.attribute,'冷热度','甜度' ) b 
as 
lengre
,tiandu
 ;