drop table if exists test_join_1; | |
drop table if exists test_join_2; | |
create table test_join_1(a string, b string); | |
create table test_join_2(a string, b string); | |
explain | |
select * from | |
( | |
SELECT a a, b b | |
FROM test_join_1 | |
)t1 | |
join | |
( | |
SELECT a a, b b | |
FROM test_join_1 | |
)t2 | |
on t1.a = t2.a | |
and t1.a = t2.b | |
join | |
( | |
select a from test_join_2 | |
)t3 on t1.a = t3.a; | |
drop table test_join_1; | |
drop table test_join_2; |