测试环境 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') ;