hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ashutosh Chauhan (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-5265) Direct SQL fallback broken on Postgres
Date Wed, 11 Sep 2013 16:41:53 GMT

    [ https://issues.apache.org/jira/browse/HIVE-5265?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13764467#comment-13764467
] 

Ashutosh Chauhan commented on HIVE-5265:
----------------------------------------

We need bit more testing here. Will it be easy for you to setup postgres and run all the unit
tests with metastore pointing to postgres instead of derby. Just modifying data/conf/hive-site.xml
to point to postgres should do the trick.
                
> Direct SQL fallback broken on Postgres
> --------------------------------------
>
>                 Key: HIVE-5265
>                 URL: https://issues.apache.org/jira/browse/HIVE-5265
>             Project: Hive
>          Issue Type: Bug
>    Affects Versions: 0.12.0
>            Reporter: Sergey Shelukhin
>            Assignee: Sergey Shelukhin
>            Priority: Critical
>         Attachments: HIVE-5265.D12861.1.patch
>
>
> See HIVE-5264. Postgres aborts transaction on any failed query, so the fallback doesn't
work.
> Original code used to do rollback/restart tx on SQL failure, but then it was removed
to allow usage in cases like dropTable/etc., where there's external tx present and we cannot
partially rollback.
> Looks like the solution for now is to reinstate the rollback/reopen, and prohibit the
usage inside external transactions.

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