blob: 23435f62f0b0c60df820380fcc98151480885f81 [file] [log] [blame]
--! qt:dataset:src1
--! qt:dataset:src
set hive.mapred.mode=nonstrict;
explain
select src1.key from src src1 join src src2 join src src3;
explain
select src1.key from src src1 join src src2 on src1.key=src2.key join src src3 on src1.key=src3.key;
explain
select src1.key from src src1 join src src2 join src src3 where src1.key=src2.key and src1.key=src3.key;
explain
select src1.key from src src1 join src src2 on 5 = src2.key join src src3 on src1.key=src3.key;
-- no merge
explain
select src1.key from src src1 left outer join src src2 join src src3;
explain
select src1.key from src src1 left outer join src src2 on src1.key=src2.key join src src3 on src1.key=src3.key;