Enabling transactions in Hive
In this recipe, you will learn how to configure the Hive metastore to enable Atomicity, Consistency, Isolation, Durability (ACID) properties for a Hive table. Insert, Update and Delete are not possible in Hive until the ACID properties are not enabled. Also table must to be Bucketed in Hive if Insert, Update and Delete feature are to be used.
Transactions including inserts, updates, and deletes are available from Hive 1.0.0 and above.
Getting ready
To allow the user to execute transactional commands, the user needs to configure the metastore with transactional tables. The user needs to set the following properties in hive-site.xml:
<configuration> <property> <name>javax.jdo.option.ConnectionURL</name> <value>jdbc:mysql://localhost:3306/hivedb</value> ...
Get Apache Hive Cookbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
