本文共 1194 字，大约阅读时间需要 3 分钟。

分区常用操作

1.查看分区表中有哪些分区

show partitions table_name;

SHOW PARTITIONS tomcat_log PARTITION(year='2019');

2.查询某个分区下的数据

根据分区查询数据

select table_coulm from table_name where partition_name = '2014-02-25’;

select * from dynamic_human2 where year=2018;

3.添加分区

ALTER TABLE table_name ADD PARTITION (partCol = 'value1') location 'loc1'; //示例

ALTER TABLE table_name ADD IF NOT EXISTS PARTITION (dt='20130101') LOCATION '/user/hadoop/warehouse/table_name/dt=20130101'; //一次添加一个分区

 ALTER TABLE alter_partition ADD

    PARTITION (year='2018',month='11', day='29') LOCATION '/user/candle/hive_data/logs/2018/11/27' ;

    PARTITION (year='2018',month='11', day='28') LOCATION '/user/candle/hive_data/logs/2018/11/28' ;

    PARTITION (year='2018',month='12', day='27') LOCATION '/user/candle/hive_data/logs/2018/12/27' ;

4.删除分区

ALTER TABLE login DROP IF EXISTS PARTITION (dt='2008-08-08');

ALTER TABLE page_view DROP IF EXISTS PARTITION (dt='2008-08-08', country='us’);

5.修改分区

ALTER TABLE table_name PARTITION (dt='2008-08-08') SET LOCATION "new location";

ALTER TABLE table_name PARTITION (dt='2008-08-08') RENAME TO PARTITION (dt='20080808’);

6.添加列

ALTER TABLE table_name ADD COLUMNS (col_name STRING);  //在所有存在的列后面，但是在分区列之前添加一列

转载地址：http://xrjxi.baihongyu.com/