Member since
03-19-2023
5
Posts
0
Kudos Received
1
Solution
My Accepted Solutions
Title | Views | Posted |
---|---|---|
2421 | 03-23-2023 03:55 PM |
03-23-2023
03:55 PM
Found the solution - replace %01 --> \001 and it did the trick to delete the partition.
... View more
03-20-2023
10:31 PM
Hello Asish, This also didn't work.
... View more
03-20-2023
01:53 AM
There is no error, i think the partition is not getting recognized because of -> %01
... View more
03-20-2023
01:40 AM
Hello Asish, Thanks for response. I tried as per your comments still the result is same. Partition is not getting dropped.
... View more
03-19-2023
05:49 PM
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');
... View more
Labels:
- Labels:
-
Apache Hive