We must first establish the configuration parameters listed below for Hive's transaction support in order to create ACID transaction tables.

 

SET hive.support.concurrency=true;

SET hive.enforce.bucketing=true;

SET hive.exec.dynamic.partition.mode=nonstrict;

Set hive.txn.manager=org.apache.hadoop.hive.ql.lockmgr.DbTxnManager;