question Unable to delete partition having %01 in the name in Support Questions

Unable to delete partition having %01 in the name

hive1 — Mon, 20 Mar 2023 00:49:56 GMT

Dear Members,

I have accidently created a partition having characters %01 in the name. %01 is start of header `as per the notepad++`.

When i am trying to delete the partition using ALTER statement, there is no error but partition also not getting deleted.

can anyone suggest how to delete such partitions with special characters.

ALTER TABLE <table_name> DROP IF EXISTS PARTITION (code='YATHAH%0188QW');

asish — Mon, 20 Mar 2023 08:11:19 GMT

Can you set below param:

set hive.msck.path.validation=skip;

Then use

MSCK REPAIR TABLE tablename DROP PARTITIONS;

hive1 — Mon, 20 Mar 2023 08:40:34 GMT

Hello Asish,

Thanks for response. I tried as per your comments still the result is same.

Partition is not getting dropped.

asish — Mon, 20 Mar 2023 08:42:21 GMT

hi @hive1 WHat is the error you recieved?

Can you also try with set hive.msck.path.validation=ignore

hive1 — Mon, 20 Mar 2023 08:53:49 GMT

There is no error, i think the partition is not getting recognized because of -> %01

asish — Mon, 20 Mar 2023 09:15:26 GMT

hive1 — Tue, 21 Mar 2023 05:31:13 GMT

Hello Asish, This also didn't work.

Shelton — Thu, 23 Mar 2023 12:39:28 GMT

@hive1
What is the hive version? Can you try the below and revert
Set the below two properties before executing the rename partition

hive> set fs.hdfs.impl.disable.cache=false;
hive> set fs.file.impl.disable.cache=false;

Then run the rename partition command

hive> ALTER TABLE <table_name> (code='YATHAH%0188QW') RENAME TO PARTITION (code='new_name');

Share the output for further analysis

hive1 — Thu, 23 Mar 2023 22:55:37 GMT

Found the solution - replace %01 --> \001 and it did the trick to delete the partition.