[HIVE-9675] Support START TRANSACTION/COMMIT/ROLLBACK commands

• Type: New Feature
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 0.14.0
• Component/s: SQL, Transactions
• Assignee: Unassigned
• Reporter: Eugene Koifman
• Created: 12/Feb/15 22:06
• Updated: 28/Jul/21 14:13

Description

Hive 0.14 added support for insert/update/delete statements with ACID semantics. Hive 0.14 only supports auto-commit mode. We need to add support for START TRANSACTION/COMMIT/ROLLBACK commands so that the user can demarcate transaction boundaries.

Issue Links

• is blocked by: HIVE-13622 WriteSet tracking optimizations
• is blocked by: HIVE-10148 update of bucketing column should not be allowed
• is blocked by: HIVE-10152 ErrorMsg.formatToErrorMsgMap has bad regex
• is related to: HIVE-6207 Integrate HCatalog with locking
• relates to: HDFS-9814 Advance Hybrid Cloud Architecture (AHA) - HDFS Block Level Leases (Locks)
• relates to: HIVE-13061 Advance Hybrid Cloud Architecture (AHA) - Advance Hive (Umbrella) JIRA -- Enhanced Updates & others
• relates to: HIVE-10924 add support for MERGE statement
• relates to: HIVE-5317 Implement insert, update, and delete in Hive with full ACID support

Sub-Tasks

• Enhance storage layer to create one delta file per write: Resolved
• Add support in parser and wire up to txn manager: Resolved
• Enhance DbLockManger to support multi-statement txns: Open
• Update JDBC Driver to support transaction related API: Open
• Doc Notes: Open
• Support START TRANSACTION/COMMIT/ROLLBACK commands: support SQL2011 reserved keywords: Resolved
• add support for "set autocommit": Open
• CLI doesn't show errors regarding transactions: Open
• Disable multi-statment transaction control statements until HIVE-11078: Closed
• Ensure that non-acid tables cannot be written to in a txn: Open
• prevent insert into acid and non-acid tables in the same txn: Open
• AcidUtils.getAcidState()/Cleaner - make it consistent wrt multiple base files etc: Open
• IOW Mechanics of multiple commands with OVERWRITE in a singe transactions: Open
• Hive.getValidPartitionsInPath() issue: Resolved
• TxnHandler.checkLock() will re-acquire the same lock: Open