hive中操作表语句

添加分区并指定数据所在的位置

alter table bdm.itcast_bdm_order add partition (dt='2017-01-01') location '/business/itcast_bdm_order/2017-01-01';

删除分区

alter table itcast_bdm_order drop partition(dt='2017-01-01');