---创建表
CREATE EXTERNAL TABLE secsight_opt_high_acc (sourceIp STRING, account STRING, count int)
PARTITIONED BY(pt STRING)
ROW FORMAT DELIMITED
FIELDS TERMINATED BY '\t'
STORED AS TEXTFILE;
修改分区
ALTER TABLE secsight_opt_high_acc ADD PARTITION (pt='2013-03-21') LOCATION '/output/out_opt_high_acc';
查询表
select * from secsight_opt_high_acc where pt='2013-03-21';
修改分区时间
ALTER TABLE secsight_opt_high_acc PARTITION (pt='2013-03-21') RENAME TO PARTITION (pt='20160321');
查询分区
select * from secsight_opt_high_acc where pt='20160321';
删除分区
alter table secsight_opt_high_acc drop if exists partition (pt='20160301')