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>
        <description>metadata is stored in a MySQL server</description>
    </property>
    <property>
        <name>javax.jdo.option...