hive 创建表 和分区的一些操作



---创建表
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')