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