set hive.support.concurrency=true;
set hive.txn.manager=org.apache.hadoop.hive.ql.lockmgr.DbTxnManager;
set hive.exec.dynamic.partition=true;
set hive.vectorized.execution.enabled=true;

drop table if exists testacid1;

create table testacid1(id int) clustered by (id) into 2 buckets stored as orc tblproperties("transactional"="true");

insert into table testacid1 values (1),(2),(3),(4);

set hive.compute.query.using.stats=false;

set hive.vectorized.execution.enabled;

select count(1) from testacid1;

drop table testacid1;
set hive.exec.orc.delta.streaming.optimizations.enabled=true;

create table testacid1(id int) clustered by (id) into 2 buckets stored as orc tblproperties("transactional"="true");

insert into table testacid1 values (1),(2),(3),(4);

select count(1) from testacid1;