--! qt:dataset:src | |
set hive.mapred.mode=nonstrict; | |
set hive.auto.convert.join = true; | |
-- SORT_QUERY_RESULTS | |
explain | |
SELECT * FROM | |
(SELECT * FROM src WHERE key+1 < 10) a | |
JOIN | |
(SELECT * FROM src WHERE key+2 < 10) b | |
ON a.key+1=b.key+2; | |
SELECT * FROM | |
(SELECT * FROM src WHERE key+1 < 10) a | |
JOIN | |
(SELECT * FROM src WHERE key+2 < 10) b | |
ON a.key+1=b.key+2; |