Disable dropping the table partition in Hive

The NO_DROP keyword can be used to safeguard table partitions in the same way as it can be used to prevent the table from being dropped.

There’s always the risk of accidentally dropping the table or table partition. In such circumstances, we lose all or part of the table data. We can recover a table and its data in most RDBMSs if we have a backup file, but we lose the table and its data if we don’t. We can use the NO DROP keyword in Apache Hive to prevent a table or table partition from being removed.

The sample data for this exercise can be obtained from here.


Hive> ALTER TABLE TownsList_Dynamic PARTITION (country=’England’) ENABLE NO_DROP;

Now, let’s issue the drop table statement.

Hive> DROP TABLE emp;
Now, this returns the error as we expected.
FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask.Table 
emp is protected from being dropped.

Disabling the NO_DROP.
Hive> ALTER TABLE TownsList_Dynamic PARTITION (country=’England’) DISABLE NO_DROP;

Please keep reading the subsequent posts.

Subscribe to our mailing list to be notified of new articles.

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