question Re: Does anyone else experience ACID update and delete errors like below? in Archives of Support Questions (Read Only)

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

Anilbagga08 — Wed, 20 Jul 2016 03:09:41 GMT

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

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

Anilbagga08 — Wed, 20 Jul 2016 05:28:40 GMT

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

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

Former Member — Wed, 20 Jul 2016 12:36:06 GMT

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?

bajpaiharishdut — Fri, 24 Mar 2017 20:01:50 GMT

@kishore sanchina it's working 🙂