| --! qt:dataset:src |
| set hive.mapred.mode=nonstrict; |
| set hive.explain.user=false; |
| -- SORT_QUERY_RESULTS |
| |
| create table A_n2 as |
| select * from src; |
| |
| create table B_n2 as |
| 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_n2 join B_n2; |
| |
| explain select * from B_n2 d1 join B_n2 d2 on d1.key = d2.key join A_n2; |
| |
| explain select * from A_n2 join |
| (select d1.key |
| from B_n2 d1 join B_n2 d2 on d1.key = d2.key |
| where 1 = 1 group by d1.key) od1; |
| |
| explain select * from A_n2 join (select d1.key from B_n2 d1 join B_n2 d2 where 1 = 1 group by d1.key) od1; |
| |
| explain select * from |
| (select A_n2.key from A_n2 group by key) ss join |
| (select d1.key from B_n2 d1 join B_n2 d2 on d1.key = d2.key where 1 = 1 group by d1.key) od1; |
| |
| |