April 2016
Beginner
268 pages
5h 32m
English
Content preview from Apache Hive CookbookBecome an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
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> ...