Re: Drop Partition by ID

2014-07-22 Thread Devopam Mittra
Please try using escape character around the '%' if not already done so. regards Dev On Mon, Jul 21, 2014 at 7:32 PM, fab wol wrote: > Hi everyone, > > I have the following problem: I have a partitoned managed table (Partition > table is a string which represents a date, eg. log-date="2014-07-

Re: Drop Partition by ID

2014-07-21 Thread Prem Yadav
Only today I had the exact same issue. I used a script to load partitions but due to a mistake there were a lot of unwanted partitions with special characters. "Alter table drop partitions" showed successful but partitions where never removed. Finally, this is what I did 1) hive> show create ; cop

Re: Drop Partition by ID

2014-07-21 Thread Nitin Pawar
you can try with like statement On 21 Jul 2014 19:32, "fab wol" wrote: > Hi everyone, > > I have the following problem: I have a partitoned managed table (Partition > table is a string which represents a date, eg. log-date="2014-07-15"). > Unfortunately there is one partition in there like this:

Drop Partition by ID

2014-07-21 Thread fab wol
Hi everyone, I have the following problem: I have a partitoned managed table (Partition table is a string which represents a date, eg. log-date="2014-07-15"). Unfortunately there is one partition in there like this: log_date=2014-07-15-23%3A45%3A38 (copied from show partitions stmt). This partitio