Deletion of Partitions

Question

I am not able to drop partition in hive table.

ALTER TABLE db.table drop if exists partition(dt="****-**-**/id=**********");
OK
Time taken: 0.564 seconds

But partitions are not getting deleted

Below is the what I get when I check partitions of my table:

hive> show partitions db.table;
OK
dt=****-**-**/id=**********
dt=****-**-**/id=**********
dt=****-**-**/id=**********
dt=****-**-**/id=**********

After running Alter table db.table drop if exists command it should actually delete the partition . But it is not happening so .

Can you please suggest me on this. Thanks in advance.

Answer 1

Try this:

ALTER TABLE db.table drop if exists partition(dt='****-**-**', id='**********');