I want to load data into complex data type ARRAY<STRING> from another tables, Here my table schema is
in that table2 and table3 are separate tables and rest of the schema from table,
Please let me know how to populate this table from these 3 tables,
Thanks in advance
Please go through once below example. Hope it will be useful.
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;