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.

Hive update/delete not working in CDH 5.12

Hive update/delete not working in CDH 5.12

Explorer

Hi,

 

I am getting the below error in Hive when I tried to update and delete. I am using hive version 1.1.0 in CDH 5.12

FAILED: SemanticException [Error 10294]: Attempt to do update or delete using transaction manager that does not support these operations.

 

I created table and stored in ORC format and no bucketing and had transactional set to true.

 

Please let me know what are the properties that need to be added or modified to make this work?

 

Thanks,

Renuka

2 REPLIES 2

Re: Hive update/delete not working in CDH 5.12

New Contributor

Hi,

 

Did you proceed with this and does it work? I am facing the same issue.

 

Thanks,

Abinaya


@renuka20 wrote:

Hi,

 

I am getting the below error in Hive when I tried to update and delete. I am using hive version 1.1.0 in CDH 5.12

FAILED: SemanticException [Error 10294]: Attempt to do update or delete using transaction manager that does not support these operations.

 

I created table and stored in ORC format and no bucketing and had transactional set to true.

 

Please let me know what are the properties that need to be added or modified to make this work?

 

Thanks,

Renuka


 

Highlighted

Re: Hive update/delete not working in CDH 5.12

Explorer

Hi,

 

No I didnot proceed , did it work for you?

 

Thanks