I was also facing same issue like you. Then I had followed these steps  and it worked for me :   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=2;   Then I changed added hive.in.test property=true in the hive-site.xml file in /usr/lib/hive location.   After that I restarted the Hive from HUE and then ran the update command and it worked for me. ... View more