hive支持事务及单行操作 update delete

 

测试环境  Hive 1.2.1000.2.6.0.3-8

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=1;

drop table tmp_ccc_20180716;
create table tmp_ccc_20180716(id int,age int)
clustered by (id) into 8 buckets
stored as orc 
TBLPROPERTIES ('transactional'='true')
;
-- 建表语句必须带有 into buckets 子句和 stored as orc TBLPROPERTIES ('transactional'='true') 子句，并且不能带有 sorted by 子句。
insert into table tmp_ccc_20180716 values(1,2);
insert into table tmp_ccc_20180716 values(2,3);
insert into table tmp_ccc_20180716 values(3,4);
update tmp_ccc_20180716 set age = 2 where id = 1;
delete from tmp_ccc_20180716 where id = 2;
select * from tmp_ccc_20180716;

drop table tmp_ccc_20180716;
create table tmp_ccc_20180716(id int,age int)
clustered by (id) into 8 buckets
stored as orc TBLPROPERTIES ('transactional'='true')
;