Support for transactions in Hive 0.13 and later enables SQL atomicity of operations at the row level rather than at the level of a table or partition. This allows a Hive client to read from a partition at the same time that another Hive client is adding rows to the same partition. In addition, transactions provide a mechanism for streaming clients to rapidly update Hive tables and partitions. Hive transactions differ from RDBMS transactions in that each transaction has an identifier, and multiple transactions are grouped into a single transaction batch. A streaming client requests a set of transaction IDs after connecting to Hive and subsequently uses these transaction IDs one at a time during the initialization of new transaction batches. Clients write one or more records for each transaction and either commit or abort a transaction before moving to the next transaction.

ACID is an acronym for four required traits of database transactions: atomicity, consistency, isolation, and durability.

Administrators:

To use ACID-based transactions, administrators must use a transaction manager that supports ACID and the ORC file format. See Understanding and Administering Hive Compactions for how to set up a transaction manager.

Developers:

Developers and others utilize transactional SQL by:

	Note
	See the Hive wiki for more information about Hive's support of ACID semantics for transactions.