[1020]hive中分区表的创建

set hive.exec.dynamic.partition=true; 
 
set hive.exec.dynamic.partition.mode=nonstrict;

create table test_part_table(
word string,
num bigint 
)partitioned by(dt string)
row format delimited fields terminated by '\t';
 
--添加分区
alter table test_part_table add if not exists partition(dt='20190808') location '20190808';
 
--插入数据
load data local INPATH '/home/dongwentao15/dataTest/test1' overwrite into table test_part_table PARTITION (dt='20190811');
 
 
hive (dongwentao15)> select * from test_part_table;
OK
dwt     22      20190811
cn      3       20190811
un      1       20190811
fk      5       20190811
pl      19      20190811
6       NULL    20190811

第二步骤的添加分区可以省略，可以直接load数据到分区表中，在load数据的过程中，hive会自动创建分区目录。

create table orders_part(
order_id string,
user_id string,
eval_set string,
order_number string,
order_hour_of_day string,
days_since_prior_order string
)partitioned by(order_dow string)
row format delimited fields terminated by ',';
 
--添加数据
insert into table orders_part partition (order_dow) select order_id,user_id,eval_set,order_number,order_hour_of_day,days_since_prior_order,order_dow from orders;
 
其中orders表中的字段是：
order_id,user_id,eval_set,order_number,order_dow,order_hour_of_day,days_since_prior_order