Hive update/delete not working in CDH 5.12

[#1]

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]

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

---

[#3]

Hi,

No I didnot proceed , did it work for you?

Thanks