分区表:
- 创建分区表
create table t_user_partition(id int, name string) partitioned by (country string) row format delimited fields terminated by ",";
-
分区表数据导入
hadoop fs -put 不能导入分区表的数据
load data local inpath '/root/hivedata/china.txt' into table t_user_partition partition(country ='china');
load data local inpath ‘/root/hivedata/ch