PageRenderTime 22ms CodeModel.GetById 16ms app.highlight 1ms RepoModel.GetById 1ms app.codeStats 1ms

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

#
text | 24 lines | 22 code | 2 blank | 0 comment | 0 complexity | d8f1c9fc9490d6b60fa46ae643db8dcd MD5 | raw file
 1set hive.optimize.ppd=true;
 2
 3EXPLAIN
 4SELECT src1.c1, src2.c4 
 5FROM
 6(SELECT src.key as c1, src.value as c2 from src where src.key <> '302' ) src1
 7JOIN
 8(SELECT src.key as c3, src.value as c4 from src where src.key <> '305' ) src2
 9ON src1.c1 = src2.c3 AND src1.c1 < '400'
10JOIN
11(SELECT src.key as c5, src.value as c6 from src where src.key <> '306' ) src3
12ON src1.c2 = src3.c6
13WHERE src1.c1 <> '311' and (src1.c2 <> 'val_50' or src1.c1 > '1') and (src2.c3 <> '10' or src1.c1 <> '10') and (src2.c3 <> '14') and (sqrt(src3.c5) <> 13);
14
15SELECT src1.c1, src2.c4 
16FROM
17(SELECT src.key as c1, src.value as c2 from src where src.key <> '302' ) src1
18JOIN
19(SELECT src.key as c3, src.value as c4 from src where src.key <> '305' ) src2
20ON src1.c1 = src2.c3 AND src1.c1 < '400'
21JOIN
22(SELECT src.key as c5, src.value as c6 from src where src.key <> '306' ) src3
23ON src1.c2 = src3.c6
24WHERE src1.c1 <> '311' and (src1.c2 <> 'val_50' or src1.c1 > '1') and (src2.c3 <> '10' or src1.c1 <> '10') and (src2.c3 <> '14') and (sqrt(src3.c5) <> 13);