hive分区操作

-------创建分区表，指定分区的字段为country

create table t_sz_part(id int,name string)

partitioned by(country string)

row format delimited

fileds terminated by ',';

--------导入数据，指定导入到哪个分区，用country标识

load data local inpath '/home/hadoop/sz.data' into table t_sz_part partition(country='China');

load data local inpath '/home/hadoop/sz2.data' into table t_sz_part partition(country='Japan')