PageRenderTime 15ms CodeModel.GetById 8ms app.highlight 3ms RepoModel.GetById 1ms app.codeStats 0ms

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

#
text | 71 lines | 61 code | 10 blank | 0 comment | 0 complexity | 4dc90cc35c9c371cee49853a6f050281 MD5 | raw file
 1set hive.optimize.ppd=true;
 2
 3EXPLAIN EXTENDED
 4 FROM 
 5  src a
 6 LEFT OUTER JOIN 
 7  srcpart b 
 8 ON (a.key = b.key AND b.ds = '2008-04-08')
 9 SELECT a.key, a.value, b.key, b.value
10 WHERE a.key > 10 AND a.key < 20 AND b.key > 15 AND b.key < 25;
11
12 FROM 
13  src a
14 LEFT OUTER JOIN 
15  srcpart b 
16 ON (a.key = b.key AND b.ds = '2008-04-08')
17 SELECT a.key, a.value, b.key, b.value
18 WHERE a.key > 10 AND a.key < 20 AND b.key > 15 AND b.key < 25;
19
20EXPLAIN EXTENDED
21 FROM 
22  srcpart a
23 LEFT OUTER JOIN 
24  src b 
25 ON (a.key = b.key AND a.ds = '2008-04-08')
26 SELECT a.key, a.value, b.key, b.value
27 WHERE a.key > 10 AND a.key < 20 AND b.key > 15 AND b.key < 25;
28
29 FROM 
30  srcpart a
31 LEFT OUTER JOIN 
32  src b 
33 ON (a.key = b.key AND a.ds = '2008-04-08')
34 SELECT a.key, a.value, b.key, b.value
35 WHERE a.key > 10 AND a.key < 20 AND b.key > 15 AND b.key < 25;
36
37
38EXPLAIN EXTENDED
39 FROM 
40  src a
41 LEFT OUTER JOIN 
42  srcpart b 
43 ON (a.key = b.key)
44 SELECT a.key, a.value, b.key, b.value
45 WHERE a.key > 10 AND a.key < 20 AND b.key > 15 AND b.key < 25 AND b.ds = '2008-04-08';
46
47 FROM 
48  src a
49 LEFT OUTER JOIN 
50  srcpart b 
51 ON (a.key = b.key)
52 SELECT a.key, a.value, b.key, b.value
53 WHERE a.key > 10 AND a.key < 20 AND b.key > 15 AND b.key < 25 AND b.ds = '2008-04-08';
54
55EXPLAIN EXTENDED
56 FROM 
57  srcpart a
58 LEFT OUTER JOIN 
59  src b 
60 ON (a.key = b.key)
61 SELECT a.key, a.value, b.key, b.value
62 WHERE a.key > 10 AND a.key < 20 AND b.key > 15 AND b.key < 25 AND a.ds = '2008-04-08';
63
64 FROM 
65  srcpart a
66 LEFT OUTER JOIN 
67  src b 
68 ON (a.key = b.key)
69 SELECT a.key, a.value, b.key, b.value
70 WHERE a.key > 10 AND a.key < 20 AND b.key > 15 AND b.key < 25 AND a.ds = '2008-04-08';
71