SET hive.vectorized.execution.enabled=false;
set hive.stats.filter.range.uniform=false;

create table tx_n2(a int,u int);
insert into tx_n2 values (1,1),(2,2),(3,3),(4,4),(5,5),(6,6),(7,7),(10,10);

create table px(a int,p int);
insert into px values (2,2),(3,3),(5,5),(7,7),(11,11);


set hive.explain.user=true;
set hive.query.reexecution.enabled=true;
set hive.query.reexecution.strategies=overlay,reoptimize,recompile_without_cbo;

explain REOPTIMIZATION 
select sum(u*p) from tx_n2 join px on (u=p) where u<10 and p>2;

set hive.auto.convert.join=false;
explain analyze
select sum(u*p) from tx_n2 join px on (u=p) where u<10 and p>2;
set hive.auto.convert.join=true;
explain analyze
select sum(u*p) from tx_n2 join px on (u=p) where u<10 and p>2;

set zzz=1;
set reexec.overlay.zzz=2000;

explain
select assert_true_oom(${hiveconf:zzz} > sum(u*p)) from tx_n2 join px on (tx_n2.a=px.a) where u<10 and p>2;
select assert_true_oom(${hiveconf:zzz} > sum(u*p)) from tx_n2 join px on (tx_n2.a=px.a) where u<10 and p>2;