set hive.auto.convert.join=true;
set hive.auto.convert.join.noconditionaltask=true;
set hive.auto.convert.join.noconditionaltask.size=10000;

set hive.support.concurrency=true;
set hive.txn.manager=org.apache.hadoop.hive.ql.lockmgr.DbTxnManager;

drop table if exists acid1;
drop table if exists acid2;

create table acid1 (key int, value string) clustered by (key) into 2 buckets stored as orc tblproperties ("transactional"="true");
create table acid2 (key int, value string) clustered by (key) into 2 buckets stored as orc tblproperties ("transactional"="true");

insert into acid1 values (1, 'a'), (2, 'b'), (3, 'c'), (4, 'd'), (5, 'e'), (6, 'f'), (7, 'g'), (8, 'h');
insert into acid2 values (1,'a'),(3,'c'),(5,'e'),(7,'g');
alter table acid2 update statistics set('numRows'='210', 'rawDataSize'='840');
alter table acid1 update statistics set('numRows'='316', 'rawDataSize'='1265');
explain
select count(*) from acid1 join acid2 on acid1.key = acid2.key;
select count(*) from acid1 join acid2 on acid1.key = acid2.key;

drop table acid1;
drop table acid2;