Objective is to update and delete a row in a table.
I know I need those values set in hive for ACID to be enabled:
I set them in hive and create a table
create table db.myTable(
partitioned by (
stored as parquet TBLPROPERTIES('transactional' = 'true');
trying to update using
update db.myTable set str2 = 'blabla' where dt '2016-01-01'
There is a row in myTable belonging to the partion 2016-01-01, but the update fails with
Error while compiling statement: FAILED: SemanticException [Error 10294]: Attempt to do update or delete using transaction manager that does not support these operations
Any suggestions as to what might be wrong?
I have the same problem both using Parquet file and using ORC File with Hive.