weixin_39926871的博客

假设文件中的一行数据为：反贪风暴4,刘青云:张家辉:张老哥,2019-04-03此时建表语句应该为：create table t_movie（movie_name string,actors array<string>,show date）row format delimited fields terminate by ','collection items ter...

假设有如下数据：1,zhang,father:zhanglaoge#monther:xiaolaomei#brother:superman,22则建表语句应该如下：create table t_person(id int,name string,family_members map<string,string>,age int)row format delimited f...

假设有如下数据：1,zhang,18:male:深圳则建表语句应该如下：create table t_user(id int,name string,info struct<age:int,sex:string:addr:string>)row format delimited fields terminated by ','collection items term...

有如下数据： A,2015-01,5 A,2015-01,15 B,2015-01,5 A,2015-01,8 B,2015-01,25 A,2015-01,5 C,2015-01,10 C,2015-01,20 A,2015-02,4 A,2015-02,6 C,2015-02,30 C,2015-...