Hive table does not respond to select query. ACID

Question

My hive query does not respond at all on a table .Any select query on the table doesnt respond

I have created this table using a select query.

Tried to change the type to ORC

Tried to make TBLPROPERTIES('transactional'='true')

I have ACID properties enabled for DB, for update operations.

If the ACID properties are not enabled then select works. But i cant disable it.

Tried changing to tez by set hive.execution.engine=tez; .

`set hive.txn.manager=org.apache.hadoop.hive.ql.lockmgr.DbTxnManager;
set hive.enforce.bucketing=true;
set hive.exec.dynamic.partition.mode=nostrict;
set hive.compactor.initiator.on=true;
set hive.compactor.worker.threads=1;`

Any suggestions?

hive version : Hive 2.1.1-mapr-1803