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:
Refer to the following topics for operations and usage details: