Transactional Hive

transact-hive.hql

set hive.support.concurrency=true;
set hive.exec.dynamic.partition.mode=nonstrict;
set hive.txn.manager=org.apache.hadoop.hive.ql.lockmgr.DbTxnManager; 
set hive.compactor.initiator.on=true;
set hive.compactor.worker.threads=2 ;

CREATE TABLE AcidTest (name string, num int) clustered by (num) into 2 buckets STORED AS orc TBLPROPERTIES('transactional'='true');

INSERT INTO TABLE AcidTest VALUES ('one',1), ('two',2),('three',3),('four',4); 

UPDATE AcidTest SET name = 'dave' WHERE num > 2;

DELETE FROM AcidTest WHERE num < 2;

SELECT * FROM AcidTest;