[
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
