https://community.cloudera.com/t5/Support-Questions/Copying-data-from-ACID-table-to-a-non-ACID-enabled-table/m-p/216597#M178506 <P>Have you tried Disabling the ACID for that particular session and then try to run perform the query:- </P><P>1- Login to beeline or Hive CLI </P><P>2- Disable ACID for the session:- </P><OL> <LI>set hive.txn.manager=org.apache.hadoop.hive.ql.lockmgr.DummyTxnManager;</LI><LI>set hive.support.concurrency=false;</LI></OL><P>3- Run the Query now to copy the data.</P> Mon, 19 Mar 2018 02:59:16 GMT knadar 2018-03-19T02:59:16Z