I am able to update and delete a table from hive shell. We are using Cloudera distributed hadoop for Poc. I have set the acid properties in hive-site.xml and restarted hive services and everything was working fine with hive shell. But when i used hive form hue i am not able to update and delete the same table. I am getting the below error.
- Error while compiling statement: FAILED: SemanticException [Error 10294]: Attempt to do update or delete using transaction manager that does not support these operations.
What ever parameters i set in hive-site.xml is not reflected in hive when accessed from hue.
For eg) set hive.support.concurrency is true in hive shell, but when i checked the same from hive.hue it shows false.
Experts please suggest where i am going wrong.