Hive表分区的增删改查

1、查询分区

hive> show partitions stu;
OK
school=AA/classroom=001
school=AA/classroom=005
school=BB/classroom=001
Time taken: 0.047 seconds, Fetched: 3 row(s)

2、增加表分区

hive> alter table stu add partition(school='CC',classroom='008');
OK
Time taken: 0.133 seconds

hive> show partitions stu;
OK
school=AA/classroom=001
school=AA/classroom=005
school=BB/classroom=001
school=CC/classroom=008
Time taken: 0.051 seconds, Fetched: 4 row(s)

3、删除分区

hive> alter table stu drop partition(school='AA',classroom='001');
Dropped the partition school=AA/classroom=001
OK
Time taken: 0.31 seconds

hive> show partitions stu;
OK
school=AA/classroom=005
school=BB/classroom=001
school=CC/classroom=008
Time taken: 0.04 seconds, Fetched: 3 row(s)

删除分区，分区相应的数据也会消失；

4、修复分区

重新同步hdfs上的分区信息：

hive> msck repair table stu;
OK
Time taken: 0.081 seconds