collect_set函数
1)创建原数据表
hive (test)>
drop table if exists test_collect_set_stud;
create table test_collect_set_stud (name string, area string, course string, score int);
2)向原数据表中插入数据
hive (test)>
insert into table test_collect_set_stud values('zhang3','bj','math',88);
insert into table test_collect_set_stud values('li4','bj','math',99);
insert into table test_collect_set_stud values('wang5','sh','chinese',92