auto_join16.q | searchcode

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

#
text | 18 lines | 14 code | 4 blank | 0 comment | 0 complexity | 78a0079e836a6397e77b3997a8a794f2 MD5 | raw file
Possible License(s): Apache-2.0, BSD-3-Clause, JSON, CPL-1.0



set hive.auto.convert.join = true;


explain
SELECT sum(hash(subq.key, tab.value)) 
FROM 
(select a.key, a.value from src a where a.key > 10 ) subq 
JOIN src tab 
ON (subq.key = tab.key and subq.key > 20 and subq.value = tab.value) 
where tab.value < 200;

SELECT sum(hash(subq.key, tab.value)) 
FROM 
(select a.key, a.value from src a where a.key > 10 ) subq 
JOIN src tab 
ON (subq.key = tab.key and subq.key > 20 and subq.value = tab.value) 
where tab.value < 200;