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 the prerequisites, supported ACID features, and Hive ACID compaction that applies to all three query engines.

Refer to the following topics for operations and usage details.