Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Not able to update and delete from hive on hue.

Not able to update and delete from hive on hue.

New Contributor

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.

1 REPLY 1
Highlighted

Re: Not able to update and delete from hive on hue.

New Contributor

Latest update

=============

if i insert a row from hue ,i am not able to delete that from hive cli.

But insert and delete works fine directly from hive cli.

Don't have an account?
Coming from Hortonworks? Activate your account here