--! qt:dataset:src
set hive.mapred.mode=nonstrict;
set hive.cbo.returnpath.hiveop=true;
set hive.explain.user=false;
-- SORT_QUERY_RESULTS

create table A_n18 (key string, value string);
insert into A_n18
select * from src;

create table B_n14 (key string, value string);
insert into B_n14
select * from src order by key
limit 10;

set hive.auto.convert.join=true;
set hive.auto.convert.join.noconditionaltask=true;
set hive.auto.convert.join.noconditionaltask.size=10000000;

explain select * from A_n18 join B_n14;

explain select * from B_n14 d1 join B_n14 d2 on d1.key = d2.key join A_n18;

explain select * from A_n18 join 
         (select d1.key 
          from B_n14 d1 join B_n14 d2 on d1.key = d2.key 
          where 1 = 1 group by d1.key) od1;

explain select * from A_n18 join (select d1.key from B_n14 d1 join B_n14 d2 where 1 = 1 group by d1.key) od1;

explain select * from 
(select A_n18.key from A_n18 group by key) ss join 
(select d1.key from B_n14 d1 join B_n14 d2 on d1.key = d2.key where 1 = 1 group by d1.key) od1;