[
https://issues.apache.org/jira/browse/HIVE-3993?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14546579#comment-14546579
]
Hive QA commented on HIVE-3993:
-------------------------------
{color:green}Overall{color}: +1 all checks pass
Here are the results of testing the latest attachment:
https://issues.apache.org/jira/secure/attachment/12733304/HIVE-3993.patch
{color:green}SUCCESS:{color} +1 24 tests passed
Test results:
http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job/PreCommit-HIVE-METASTORE-Test/49/testReport
Console output:
http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job/PreCommit-HIVE-METASTORE-Test/49/console
Test logs:
http://ec2-174-129-184-35.compute-1.amazonaws.com/logs/PreCommit-HIVE-METASTORE-Test-49/
Messages:
{noformat}
LXC derby found.
LXC derby is not started. Starting container...
Container started.
Preparing derby container...
Container prepared.
Calling /hive/testutils/metastore/dbs/derby/prepare.sh ...
Server prepared.
Calling /hive/testutils/metastore/dbs/derby/execute.sh ...
Tests executed.
LXC mysql found.
LXC mysql is not started. Starting container...
Container started.
Preparing mysql container...
Container prepared.
Calling /hive/testutils/metastore/dbs/mysql/prepare.sh ...
Server prepared.
Calling /hive/testutils/metastore/dbs/mysql/execute.sh ...
Tests executed.
LXC postgres found.
LXC postgres is not started. Starting container...
Container started.
Preparing postgres container...
Container prepared.
Calling /hive/testutils/metastore/dbs/postgres/prepare.sh ...
Server prepared.
Calling /hive/testutils/metastore/dbs/postgres/execute.sh ...
Tests executed.
{noformat}
This message is automatically generated.
ATTACHMENT ID: 12733304 - PreCommit-HIVE-METASTORE-Test
> 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.8.0, 0.9.0, 1.2.0
> Environment: Using Postgres as backend
> Reporter: Rick Weber
> Assignee: Shinichi Yamashita
> Priority: Critical
> Attachments: HIVE-3993.patch
>
> Original Estimate: 24h
> Remaining Estimate: 24h
>
> 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 was sent by Atlassian JIRA
(v6.3.4#6332)
