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');
What is the hive version? Can you try the below and revert
Set the below two properties before executing the rename partition
Then run the rename partition command
Share the output for further analysis