Deleting the Table Partition – Hive

In earlier articles, we covered how to create, rename, and add Hive table partitions. This post will go through how to remove a table partition.

Syntax:
ALTER TABLE table_name
DROP PARTITION partition_specifaction;

Example:
ALTER TABLE CitiesList
DROP PARTITION(Country=’UAE’);

For detailed information about partitions, please click here.
Examples for Static Partitions, click here.
Examples for Dynamic Partitions, click here.
To know how to add a partition, please click here.
To know how to rename a partition, please click here.

Hope you find this article helpful.

Please subscribe for more interesting updates.