Hadoop Hive ACID query error
This is probably because you had the wrong transaction manager at the time of creating the table or loading the data into the table.
In my case, i had org.apache.hadoop.hive.ql.lockmgr.DummyTxnManager
instead of org.apache.hadoop.hive.ql.lockmgr.DbTxnManager
To get rid of the error, you need to drop the table, set the correct transaction manager i.e
hive> set hive.txn.manager = org.apache.hadoop.hive.ql.lockmgr.DbTxnManager;
and then re-create the table.