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
