复杂的数据类型

create table teen(id int,name string,gf Array<string>)
row format delimited fields terminated by " "
collection items terminated by ",";

 

 

 

 create table t_map(id int,name string,info Map<string,string>)
 row format delimited fields terminated by " "
 collection items terminated by ","
 map keys terminated by ":";

 

 

create table t_struct(id int,name string,address struct<province:string,city:string,contry:string>) 
row format delimited fields terminated by " "
collection items terminated by ",";

 

 //多种数据类型

 create table complex(id int,name string,movies Array<string>,info Map<string,string>,address struct<province:string,city:string>)
 row format delimited fields terminated by " "
 collection items terminated by ","
 map keys terminated by ":";