set hive.auto.convert.join=true; | |
create table tu ( a integer ); | |
create table tv ( b integer ); | |
insert into tu values (1),(2),(3),(4),(5); | |
insert into tv values (1),(2),(3),(4),(5); | |
explain | |
with t as ( | |
select a+b as s from tu,tv where a>1 and b>2 and a*a=b | |
) | |
select sum(t1.s) from t as t1, t as t2 where t1.s=t2.s+1 | |
union all | |
select sum(t1.s) from t as t1, t as t2 where t1.s+1=t2.s; | |