Reply
Contributor
Posts: 38
Registered: ‎07-11-2017

Hive update/delete not working in CDH 5.12

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

New Contributor
Posts: 1
Registered: ‎02-20-2018

Re: Hive update/delete not working in CDH 5.12

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
Contributor
Posts: 38
Registered: ‎07-11-2017

Re: Hive update/delete not working in CDH 5.12

Hi,

 

No I didnot proceed , did it work for you?

 

Thanks

Announcements