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
