How to perform update in hive?

Question

When I use update statement I get the following response.

update t1 set t1.id=t2.id , t1.name=t2.name ,t1.age=t2.age where t2.id in (select id from t1);

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

Can anyone provide me a solution for this?

techprat techprat · Accepted Answer · 2017-03-27T12:31:31

You have to enables your tables for transactional process, you have to mention this while creating table schema.

You can refer to the website below as in to know how to achieve that.