Hi, Please go through once below example. Hope it will be useful. cat >mapfile 1,abc,40000,a$b$c,pf#500$epf#200,hyd$ap$500001 2,def,3000,d$f,pf#500,bang$kar$600038 hive> create table tab11(id int,name string,sal bigint,sub array<string>,dud map<string,int>,addr struct<city:string,state:string,pin:bigint>) > row format delimited
> fields terminated by ',' > collection items terminated by '$' > map keys terminated by '#'; hive> load data local inpath '/home/training/structfile' into table tab11;
... View more
