| |
| 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 t1.s from t as t1, t as t2 where t1.s=t2.s+1 |
| union all |
| select t1.s from t as t1, t as t2 where t1.s+1=t2.s; |
| |
| |
| with t as ( |
| select a+b as s from tu,tv where a>1 and b>2 and a*a=b |
| ) |
| select t1.s from t as t1, t as t2 where t1.s=t2.s+1 |
| union all |
| select t1.s from t as t1, t as t2 where t1.s+1=t2.s; |
| |