–Gives Hadoop and Hive version
set system:sun.java.command;
–Client Side
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 ;
–a positive number on at least one instance of the Thrift metastore service

—————–
Conclusion: As on March 2017 Hive version in Hartonworks is 1.2.https://hortonworks.com/blog/available-now-hdp-2-3/
– This don’t have support for transactions
– To get support, we need to wait for 2.x to be part of hortonworks HDP 2.x
– For now decouple tables..outside process can directly write to Hive table A. and update table B with its status.
– From BigData application use CDAP/HDP abstraction or use Apache Phoenix (https://phoenix.apache.org/) API to merge and manage data required for business layer.
– Enabling global transactions and enabling table level transactions is confusing and still lot of clarity needs to come in the system.
—————–