While i set ACID property hive getting Hang, and i forced to do ctl+c
I have created a table with the following command:
hive > SET hive.support.concurrency=true; SET hive.enforce.bucketing=true; SET hive.exec.dynamic.partition.mode=nonstrict; SET hive.txn.manager=org.apache.hadoop.hive.ql.lockmgr.DbTxnManager; SET hive.compactor.initiator.on=true; SET hive.compactor.worker.threads=1; set hive.optimize.sort.dynamic.partition=false;
hive> create table testuser (x int, y string) clustered by (x) into 2 buckets stored as ORC tblproperties ("transactional" = "true");
above query get hang after setting ACID property. I also try to set it in AMBARI and got same hive hanging problem. After removing ACID property hive works fine.
Hive CLI shell is getting hung and I have to run Ctrl + C command to get out of the shell. I am not able to understand why is this happening ?
Any help to resolve this problem will be very helpful.