查看分区
describe formatted tableName partition(date_id="2019-01-07");
查看table在hdfs上的存储路径及建表语句
show create table tableName ;
操作分区和表语句
alter table tableName add IF NOT EXISTS partition(date_id="$year-$mon-$day") location "${dest}";
删除分区
ALTER TABLEtableName DROP IF EXISTS PARTITION (date_id='2019-01-07');
新增分区
ALTER TABLE tableName ADD PARTITION (date_id = '2019-01-07') location 'hdfs://wecloud-cluster/project/logcenter/dw_logs/2019-01-07';
添加分区
ALTER TABLE table_name ADD PARTITION (partCol = 'value1') location 'loc1'; //示例
ALTER TABLE table_name ADD IF NOT EXISTS PARTITION (date_id='2019-01-07') LOCATION '/user/hadoop/warehouse/table_name/date_id=20190107'; //一次添加一个分区
ALTER TABLE page_view ADD PARTITION (date_id='2019-01-07