I am not able to delete or update in hive table .
create table testTableNew(id int ,name string ) clustered by (id) into 2 buckets stored as orc TBLPROPERTIES('transactional'='true');
insert into table testTableNew values('101','syri');
select * from testtablenew;
delete from testTableNew where id = '101';
set name = praveen
where id = 101;
I have added few properties in hive-site.xml also :
After restart the Hive service also same error i am facing.
Quick Start VM - 5.8 and Hive version - 1.1.0.
Please guide me to sort this issue.
I haven't found any solutions to the problem (tried Hive CLI and HUE query editor). I will try to do a workaround...
What do you mean by "prerequisites"?
Deletes can only be performed on tables that support ACID. More over your tables's file format should be ORC
Below are the properties that needs to be set .
hive.support.concurrency true (default is false) hive.enforce.bucketing true (default is false) (Not required as of Hive 2.0) hive.exec.dynamic.partition.mode nonstrict (default is strict)
Also i would suggest you to take look into kudu.