Can we do updates and deletes in hive

Technical Discussions Hive
#1

Hi Sir,

Can you please suggest me on the below

  1. can we do row level updates and deletes using hive? Google says that it is possible and implemented from hive version 0.14.

our version of hive is 1.2.1000…

But when i tried i’m getting error . Can you please suggest. Thank you.

#2

Hi @rn06031982,

Yes with the hive version 0.14 onwards we can do row-level updates and deletes. I’ve enabled them. Please check now and it should work.

Thanks

#3

Thank you very much for the reply. I’ll get back to you after testing sir. Thank you

#4

i just tried and it is not working for me. getting below exception

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