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 <darkwoll...@gmail.com> 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: > log_date=2014-07-15-23%3A45%3A38 (copied from show partitions stmt). This > partitions most likeley got created to a wrong script 8which is fixed). > > Now i want to delete this partition, but it doesn't work: > > - alter table ... drop partitition > (log_date='2014-07-15-23%3A45%3A38') gives no error, but the partition is > still existing afterwards > - I tried escaping the %-signs with backslashes but no luck with that > - I delete the directory in the HDFS and run msck repair table > afterwards. It recognizes that the folder is missing but is not deleting > the metadata > > So what can I do to get rid of the metadata? My next guess would be to go > directly to the metastore DB and delete the metadata there. But what > exactly has to be deleted? I guess there are several dependencies. > > Other idea: is there a possibility in Hive to delete a partition by a > unique ID or something like that? > > Or what is needed to delete the table with the normal "alter table drop > partition" command? > > Cheers > Wolli > -- Devopam Mittra Life and Relations are not binary
