Hive分区表

1.增加分区：

   alter table  item add partition (par_dt='2016-12-01') location '/user/test/item/2016-12-01'

2.删除分区：

 alter  table item drop partition (par_dt='2016-12-01')

3.查看分区：

show partition item;

4.从源表到目标表的自动分区

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

set hive.exec.max.dynamic.partitions=100000;

set hive.exec.max.dynamic.partitions.pernode=100000;

insert overwrite table sku_dly_ship partition(par_dt) select * ,se.wm_yr_wk from src_sku_dly_ship se;