/tags/release-0.0.0-rc0/hive/external/ql/src/test/queries/clientpositive/auto_join16.q

 1
 2set hive.auto.convert.join = true;
 3
 4
 5explain
 6SELECT sum(hash(subq.key, tab.value)) 
 7FROM 
 8(select a.key, a.value from src a where a.key > 10 ) subq 
 9JOIN src tab 
10ON (subq.key = tab.key and subq.key > 20 and subq.value = tab.value) 
11where tab.value < 200;
12
13SELECT sum(hash(subq.key, tab.value)) 
14FROM 
15(select a.key, a.value from src a where a.key > 10 ) subq 
16JOIN src tab 
17ON (subq.key = tab.key and subq.key > 20 and subq.value = tab.value) 
18where tab.value < 200;