PageRenderTime 21ms CodeModel.GetById 13ms app.highlight 3ms RepoModel.GetById 1ms app.codeStats 0ms

/tags/release-0.2.0-rc0/hive/external/ql/src/test/results/clientpositive/ppd_outer_join1.q.out

#
text | 258 lines | 248 code | 10 blank | 0 comment | 0 complexity | 2d98295e04dc7eee97862e3ceaeb0b4c MD5 | raw file
  1PREHOOK: query: EXPLAIN
  2 FROM 
  3  src a
  4 LEFT OUTER JOIN 
  5  src b 
  6 ON (a.key = b.key)
  7 SELECT a.key, a.value, b.key, b.value
  8 WHERE a.key > 10 AND a.key < 20 AND b.key > 15 AND b.key < 25
  9PREHOOK: type: QUERY
 10POSTHOOK: query: EXPLAIN
 11 FROM 
 12  src a
 13 LEFT OUTER JOIN 
 14  src b 
 15 ON (a.key = b.key)
 16 SELECT a.key, a.value, b.key, b.value
 17 WHERE a.key > 10 AND a.key < 20 AND b.key > 15 AND b.key < 25
 18POSTHOOK: type: QUERY
 19ABSTRACT SYNTAX TREE:
 20  (TOK_QUERY (TOK_FROM (TOK_LEFTOUTERJOIN (TOK_TABREF (TOK_TABNAME src) a) (TOK_TABREF (TOK_TABNAME src) b) (= (. (TOK_TABLE_OR_COL a) key) (. (TOK_TABLE_OR_COL b) key)))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (. (TOK_TABLE_OR_COL a) key)) (TOK_SELEXPR (. (TOK_TABLE_OR_COL a) value)) (TOK_SELEXPR (. (TOK_TABLE_OR_COL b) key)) (TOK_SELEXPR (. (TOK_TABLE_OR_COL b) value))) (TOK_WHERE (AND (AND (AND (> (. (TOK_TABLE_OR_COL a) key) 10) (< (. (TOK_TABLE_OR_COL a) key) 20)) (> (. (TOK_TABLE_OR_COL b) key) 15)) (< (. (TOK_TABLE_OR_COL b) key) 25)))))
 21
 22STAGE DEPENDENCIES:
 23  Stage-1 is a root stage
 24  Stage-0 is a root stage
 25
 26STAGE PLANS:
 27  Stage: Stage-1
 28    Map Reduce
 29      Alias -> Map Operator Tree:
 30        a 
 31          TableScan
 32            alias: a
 33            Filter Operator
 34              predicate:
 35                  expr: ((key > 10) and (key < 20))
 36                  type: boolean
 37              Reduce Output Operator
 38                key expressions:
 39                      expr: key
 40                      type: string
 41                sort order: +
 42                Map-reduce partition columns:
 43                      expr: key
 44                      type: string
 45                tag: 0
 46                value expressions:
 47                      expr: key
 48                      type: string
 49                      expr: value
 50                      type: string
 51        b 
 52          TableScan
 53            alias: b
 54            Reduce Output Operator
 55              key expressions:
 56                    expr: key
 57                    type: string
 58              sort order: +
 59              Map-reduce partition columns:
 60                    expr: key
 61                    type: string
 62              tag: 1
 63              value expressions:
 64                    expr: key
 65                    type: string
 66                    expr: value
 67                    type: string
 68      Reduce Operator Tree:
 69        Join Operator
 70          condition map:
 71               Left Outer Join0 to 1
 72          condition expressions:
 73            0 {VALUE._col0} {VALUE._col1}
 74            1 {VALUE._col0} {VALUE._col1}
 75          handleSkewJoin: false
 76          outputColumnNames: _col0, _col1, _col4, _col5
 77          Filter Operator
 78            predicate:
 79                expr: ((((_col0 > 10) and (_col0 < 20)) and (_col4 > 15)) and (_col4 < 25))
 80                type: boolean
 81            Select Operator
 82              expressions:
 83                    expr: _col0
 84                    type: string
 85                    expr: _col1
 86                    type: string
 87                    expr: _col4
 88                    type: string
 89                    expr: _col5
 90                    type: string
 91              outputColumnNames: _col0, _col1, _col2, _col3
 92              File Output Operator
 93                compressed: false
 94                GlobalTableId: 0
 95                table:
 96                    input format: org.apache.hadoop.mapred.TextInputFormat
 97                    output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
 98
 99  Stage: Stage-0
100    Fetch Operator
101      limit: -1
102
103
104PREHOOK: query: FROM 
105  src a
106 LEFT OUTER JOIN 
107  src b 
108 ON (a.key = b.key)
109 SELECT a.key, a.value, b.key, b.value
110 WHERE a.key > 10 AND a.key < 20 AND b.key > 15 AND b.key < 25
111PREHOOK: type: QUERY
112PREHOOK: Input: default@src
113PREHOOK: Output: file:/var/folders/uc/ucuNeMAVGQGzy3459D8z2+++Z0Q/-Tmp-/amarsri/hive_2011-03-22_02-30-10_517_1449004673525932594/-mr-10000
114POSTHOOK: query: FROM 
115  src a
116 LEFT OUTER JOIN 
117  src b 
118 ON (a.key = b.key)
119 SELECT a.key, a.value, b.key, b.value
120 WHERE a.key > 10 AND a.key < 20 AND b.key > 15 AND b.key < 25
121POSTHOOK: type: QUERY
122POSTHOOK: Input: default@src
123POSTHOOK: Output: file:/var/folders/uc/ucuNeMAVGQGzy3459D8z2+++Z0Q/-Tmp-/amarsri/hive_2011-03-22_02-30-10_517_1449004673525932594/-mr-10000
12417	val_17	17	val_17
12518	val_18	18	val_18
12618	val_18	18	val_18
12718	val_18	18	val_18
12818	val_18	18	val_18
12919	val_19	19	val_19
130PREHOOK: query: EXPLAIN
131 FROM 
132  src a
133 LEFT OUTER JOIN 
134  src b 
135 ON (a.key = b.key)
136 SELECT a.key, a.value, b.key, b.value
137 WHERE a.key > 10 AND a.key < 20 AND b.key > 15 AND b.key < 25
138PREHOOK: type: QUERY
139POSTHOOK: query: EXPLAIN
140 FROM 
141  src a
142 LEFT OUTER JOIN 
143  src b 
144 ON (a.key = b.key)
145 SELECT a.key, a.value, b.key, b.value
146 WHERE a.key > 10 AND a.key < 20 AND b.key > 15 AND b.key < 25
147POSTHOOK: type: QUERY
148ABSTRACT SYNTAX TREE:
149  (TOK_QUERY (TOK_FROM (TOK_LEFTOUTERJOIN (TOK_TABREF (TOK_TABNAME src) a) (TOK_TABREF (TOK_TABNAME src) b) (= (. (TOK_TABLE_OR_COL a) key) (. (TOK_TABLE_OR_COL b) key)))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (. (TOK_TABLE_OR_COL a) key)) (TOK_SELEXPR (. (TOK_TABLE_OR_COL a) value)) (TOK_SELEXPR (. (TOK_TABLE_OR_COL b) key)) (TOK_SELEXPR (. (TOK_TABLE_OR_COL b) value))) (TOK_WHERE (AND (AND (AND (> (. (TOK_TABLE_OR_COL a) key) 10) (< (. (TOK_TABLE_OR_COL a) key) 20)) (> (. (TOK_TABLE_OR_COL b) key) 15)) (< (. (TOK_TABLE_OR_COL b) key) 25)))))
150
151STAGE DEPENDENCIES:
152  Stage-1 is a root stage
153  Stage-0 is a root stage
154
155STAGE PLANS:
156  Stage: Stage-1
157    Map Reduce
158      Alias -> Map Operator Tree:
159        a 
160          TableScan
161            alias: a
162            Filter Operator
163              predicate:
164                  expr: ((key > 10) and (key < 20))
165                  type: boolean
166              Reduce Output Operator
167                key expressions:
168                      expr: key
169                      type: string
170                sort order: +
171                Map-reduce partition columns:
172                      expr: key
173                      type: string
174                tag: 0
175                value expressions:
176                      expr: key
177                      type: string
178                      expr: value
179                      type: string
180        b 
181          TableScan
182            alias: b
183            Reduce Output Operator
184              key expressions:
185                    expr: key
186                    type: string
187              sort order: +
188              Map-reduce partition columns:
189                    expr: key
190                    type: string
191              tag: 1
192              value expressions:
193                    expr: key
194                    type: string
195                    expr: value
196                    type: string
197      Reduce Operator Tree:
198        Join Operator
199          condition map:
200               Left Outer Join0 to 1
201          condition expressions:
202            0 {VALUE._col0} {VALUE._col1}
203            1 {VALUE._col0} {VALUE._col1}
204          handleSkewJoin: false
205          outputColumnNames: _col0, _col1, _col4, _col5
206          Filter Operator
207            predicate:
208                expr: ((_col4 > 15) and (_col4 < 25))
209                type: boolean
210            Select Operator
211              expressions:
212                    expr: _col0
213                    type: string
214                    expr: _col1
215                    type: string
216                    expr: _col4
217                    type: string
218                    expr: _col5
219                    type: string
220              outputColumnNames: _col0, _col1, _col2, _col3
221              File Output Operator
222                compressed: false
223                GlobalTableId: 0
224                table:
225                    input format: org.apache.hadoop.mapred.TextInputFormat
226                    output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
227
228  Stage: Stage-0
229    Fetch Operator
230      limit: -1
231
232
233PREHOOK: query: FROM 
234  src a
235 LEFT OUTER JOIN 
236  src b 
237 ON (a.key = b.key)
238 SELECT a.key, a.value, b.key, b.value
239 WHERE a.key > 10 AND a.key < 20 AND b.key > 15 AND b.key < 25
240PREHOOK: type: QUERY
241PREHOOK: Input: default@src
242PREHOOK: Output: file:/var/folders/uc/ucuNeMAVGQGzy3459D8z2+++Z0Q/-Tmp-/amarsri/hive_2011-03-22_02-30-20_062_1274880924259137309/-mr-10000
243POSTHOOK: query: FROM 
244  src a
245 LEFT OUTER JOIN 
246  src b 
247 ON (a.key = b.key)
248 SELECT a.key, a.value, b.key, b.value
249 WHERE a.key > 10 AND a.key < 20 AND b.key > 15 AND b.key < 25
250POSTHOOK: type: QUERY
251POSTHOOK: Input: default@src
252POSTHOOK: Output: file:/var/folders/uc/ucuNeMAVGQGzy3459D8z2+++Z0Q/-Tmp-/amarsri/hive_2011-03-22_02-30-20_062_1274880924259137309/-mr-10000
25317	val_17	17	val_17
25418	val_18	18	val_18
25518	val_18	18	val_18
25618	val_18	18	val_18
25718	val_18	18	val_18
25819	val_19	19	val_19