hive里lateral view经典案例

需求：用一个hql语句实现
第一步：准备数据

张三|math:60,english:90
李四|math:65,english:80
王五|math:90,english:90

第二步：建表

create table tab2(
name string,
params map<string,int>)
row format delimited fields terminated by '|' 
collection items terminated by ',' map keys terminated by ':' 
lines terminated by '\n';

第三步；导入数据

load data local inpath '/root/tab1' overwrite into table tab2;

最后一步：查看数据是否无误

select * from tab2;

需求：

语句：

select name,key,value from tab2 lateral view explode(params) scntable as key,value;
--或者
select name,key,value from tab2 lateral view outer explode(params) scntable as key,value;