Does anyone else experience ACID update and delete errors like below?

[#1]

hive> UPDATE emp SET sal = 3000.00 WHERE age = 35; FAILED: SemanticException [Error 10122]: Bucketized tables do not support INSERT INTO: Table: default.emp hive> DELETE FROM emp where sal is null; FAILED: SemanticException [Error 10122]: Bucketized tables do not support INSERT INTO: Table: default.emp

[#2 · Accepted solution]

Figured this out. I had to drop and recreate the table after turning ACID transactions on and the statements worked.

[#3]

Step-1

create table testTableNew(id int ,name string ) clustered by (id) into 2 buckets

stored as orc TBLPROPERTIES('transactional'='true');

Step-2

insert into table testTableNew values (1,'row1'),(2,'row2'),(3,'row3');

step-3

update testTableNew set name = 'updateRow2' where id = 2;

Step-4

delete from testTableNew where id = 1;

[#4]

@kishore sanchina it's working 🙂