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
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.