[HIVE-5265] Direct SQL fallback broken on Postgres

• Type: Bug
• Status: Closed
• Priority: Critical
• Resolution: Fixed
• Affects Version/s: 0.12.0
• Fix Version/s: 0.12.0
• Assignee: Sergey Shelukhin
• Reporter: Sergey Shelukhin
• Created: 11/Sep/13 02:24
• Updated: 15/Oct/13 23:31
• Resolved: 12/Sep/13 12:11

Description

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.