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.

One comment

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s