hive-lspe-in-edit

hive-lspe-in-edit

create table test1.employees (
name string,
age int,
address struct<street:string, state:string, country:string, zip:int>)
PARTITIONED BY (country string,state string)
ROW FORMAT DELIMITED
FIELDS TERMINATED BY ','
COLLECTION ITEMS TERMINATED BY '\;'
STORED AS TEXTFILE;
 
 
load data local inpath '/root/e1_data' into table test1.employees partition(country='IN', state='KA');
 
load data local inpath '/root/e2_data' into table test1.employees partition (country='US', state='AK');
 
dfs -ls /user/root/test1/employees/