hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Rick Weber (JIRA)" <j...@apache.org>
Subject [jira] [Created] (HIVE-3993) After upgrading postgres metastore from 0.7.0 to 0.8.0, unable to drop legacy tables or partitions created prior to v0.8.0 upgrade
Date Wed, 06 Feb 2013 21:41:21 GMT
Rick Weber created HIVE-3993:
--------------------------------

             Summary: After upgrading postgres metastore from 0.7.0 to 0.8.0, unable to drop
legacy tables or partitions created prior to v0.8.0 upgrade
                 Key: HIVE-3993
                 URL: https://issues.apache.org/jira/browse/HIVE-3993
             Project: Hive
          Issue Type: Bug
          Components: Metastore
    Affects Versions: 0.9.0, 0.8.0
         Environment: Using Postgres as backend 
            Reporter: Rick Weber


When using Postgres as a backend DB I upgraded my metastore from the 0.7.0 schema to 0.8.0.
 Afterwhich, I attempted to drop partitions in pre-existing tables and received a very generic
error indicating there was an issue with the metastore.

After starting the CLI with 

hive -hiveconf hive.root.logger=DEBUG,console

And issuing the same drop partition command, I found that the command was failing due to a
constraint violation by COLUMNS_OLD.

I found an existing Jira that seems to address a similar issue for MySQL

HIVE-2568

Opening this Jira so that a similar fix can be applied for the Postgres backend.

Manually running 

alter table "COLUMNS_OLD" drop constraint "COLUMNS_SD_ID_fkey";

on my metastore backend fixed the issue.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira

Mime
View raw message