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')


hive分区操作