Support Questions
Find answers, ask questions, and share your expertise

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

Explorer

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

1 ACCEPTED SOLUTION

Accepted Solutions

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

Explorer

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

View solution in original post

3 REPLIES 3

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

Explorer

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

View solution in original post

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

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;

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

@kishore sanchina it's working 🙂