**1. 通過命令行方式開啟事務，當前session有效** ```sql 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; set hive.compactor.initiator.on = true; set hive.compactor.worker.threads = 1; ``` <br/> **2. 通過配置文件hive-site.xml** ```xml <property> <name>hive.support.concurrency</name> <value>true</value> </property> <property> <name>hive.txn.manager</name> <value>org.apache.hadoop.hive.ql.lockmgr.DbTxnManager</value> </property> ``` <br/> **3. 通過UI工具（如Ambari)設置**  <br/> 按照上面的方式之一開啟Hive事務后，創建如下的支持事務的分桶表： ```sql create table dim_Product ( product_sk int , product_code int , product_name varchar(128), product_category varchar(256), version varchar(32), effective_date date, expiry_date date ) -- 在Hive中只有分桶表支持事務 clustered by (product_sk ) into 8 buckets -- 設置屬性transactional'='true'開啟事務支持 stored as orc tblproperties('transactional'='true'); ```