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-
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
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:
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