Hive视图--规范处理行或解析JSON数据

    select name,work_place,loc from employee lateral view outer explode(split(null,',')) a as loc;
    
    
      
    

    select name,wps,skill,score from employee 
    lateral view explode(work_place) work_place_single as wps
    lateral view explode(skills_score) sks as skill,score;