ACID Transactions in Hive

Qubole supports ACID transactions from Hive 3.1.1 (beta) and it has optimized open-source Hive ACID transactions. Hive ACID transactions enable atomicity of operations at the row level, which allows a Hive client to read from a partition or table and simultaneously, another Hive client can add rows to the same partition or table. It also brings with it the support for commands such as UPDATE, DELETE and MERGE, and enables corresponding use cases in an efficient and cost-effective manner.

Qubole supports Hive ACID transactions in Spark and Presto as well. Hive ACID Transactions describes how to get started, the required setup, and the Hive ACID tables engine matrix, which are listed below:

• Required Setup

• Getting Started

• ACID Table Features Engine Matrix

Refer to the following topics for operations and usage details:

• Using Hive ACID Tables
• Managing Hive Transactions
• Compaction of Hive Transaction Delta Directories