Have you tried Disabling the ACID for that particular session and then try to run perform the query:- 1- Login to beeline or Hive CLI 2- Disable ACID for the session:- set hive.txn.manager=org.apache.hadoop.hive.ql.lockmgr.DummyTxnManager; set hive.support.concurrency=false; 3- Run the Query now to copy the data. ... View more