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

 1set hive.auto.convert.join = true;
 2
 3explain
 4SELECT sum(hash(src1.c1, src2.c4)) 
 5FROM
 6(SELECT src.key as c1, src.value as c2 from src) src1
 7JOIN
 8(SELECT src.key as c3, src.value as c4 from src) src2
 9ON src1.c1 = src2.c3 AND src1.c1 < 100;
10
11SELECT sum(hash(src1.c1, src2.c4)) 
12FROM
13(SELECT src.key as c1, src.value as c2 from src) src1
14JOIN
15(SELECT src.key as c3, src.value as c4 from src) src2
16ON src1.c1 = src2.c3 AND src1.c1 < 100;