PageRenderTime 24ms CodeModel.GetById 14ms app.highlight 5ms RepoModel.GetById 1ms app.codeStats 0ms

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

#
text | 420 lines | 408 code | 12 blank | 0 comment | 0 complexity | e161908599a1a0932ed2733449ec4706 MD5 | raw file
  1PREHOOK: query: EXPLAIN
  2SELECT *
  3FROM srcpart a JOIN srcpart b
  4ON a.key = b.key
  5WHERE a.ds = '2008-04-08' AND
  6      b.ds = '2008-04-08' AND
  7      CASE a.key
  8        WHEN '27' THEN TRUE
  9        WHEN '38' THEN FALSE
 10        ELSE NULL
 11       END
 12ORDER BY a.key, a.value, a.ds, a.hr, b.key, b.value, b.ds, b.hr
 13PREHOOK: type: QUERY
 14POSTHOOK: query: EXPLAIN
 15SELECT *
 16FROM srcpart a JOIN srcpart b
 17ON a.key = b.key
 18WHERE a.ds = '2008-04-08' AND
 19      b.ds = '2008-04-08' AND
 20      CASE a.key
 21        WHEN '27' THEN TRUE
 22        WHEN '38' THEN FALSE
 23        ELSE NULL
 24       END
 25ORDER BY a.key, a.value, a.ds, a.hr, b.key, b.value, b.ds, b.hr
 26POSTHOOK: type: QUERY
 27ABSTRACT SYNTAX TREE:
 28  (TOK_QUERY (TOK_FROM (TOK_JOIN (TOK_TABREF (TOK_TABNAME srcpart) a) (TOK_TABREF (TOK_TABNAME srcpart) 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_ALLCOLREF)) (TOK_WHERE (AND (AND (= (. (TOK_TABLE_OR_COL a) ds) '2008-04-08') (= (. (TOK_TABLE_OR_COL b) ds) '2008-04-08')) (TOK_FUNCTION CASE (. (TOK_TABLE_OR_COL a) key) '27' TRUE '38' FALSE TOK_NULL))) (TOK_ORDERBY (TOK_TABSORTCOLNAMEASC (. (TOK_TABLE_OR_COL a) key)) (TOK_TABSORTCOLNAMEASC (. (TOK_TABLE_OR_COL a) value)) (TOK_TABSORTCOLNAMEASC (. (TOK_TABLE_OR_COL a) ds)) (TOK_TABSORTCOLNAMEASC (. (TOK_TABLE_OR_COL a) hr)) (TOK_TABSORTCOLNAMEASC (. (TOK_TABLE_OR_COL b) key)) (TOK_TABSORTCOLNAMEASC (. (TOK_TABLE_OR_COL b) value)) (TOK_TABSORTCOLNAMEASC (. (TOK_TABLE_OR_COL b) ds)) (TOK_TABSORTCOLNAMEASC (. (TOK_TABLE_OR_COL b) hr)))))
 29
 30STAGE DEPENDENCIES:
 31  Stage-1 is a root stage
 32  Stage-2 depends on stages: Stage-1
 33  Stage-0 is a root stage
 34
 35STAGE PLANS:
 36  Stage: Stage-1
 37    Map Reduce
 38      Alias -> Map Operator Tree:
 39        a 
 40          TableScan
 41            alias: a
 42            Filter Operator
 43              predicate:
 44                  expr: CASE (key) WHEN ('27') THEN (true) WHEN ('38') THEN (false) ELSE (null) END
 45                  type: boolean
 46              Reduce Output Operator
 47                key expressions:
 48                      expr: key
 49                      type: string
 50                sort order: +
 51                Map-reduce partition columns:
 52                      expr: key
 53                      type: string
 54                tag: 0
 55                value expressions:
 56                      expr: key
 57                      type: string
 58                      expr: value
 59                      type: string
 60                      expr: ds
 61                      type: string
 62                      expr: hr
 63                      type: string
 64        b 
 65          TableScan
 66            alias: b
 67            Reduce Output Operator
 68              key expressions:
 69                    expr: key
 70                    type: string
 71              sort order: +
 72              Map-reduce partition columns:
 73                    expr: key
 74                    type: string
 75              tag: 1
 76              value expressions:
 77                    expr: key
 78                    type: string
 79                    expr: value
 80                    type: string
 81                    expr: ds
 82                    type: string
 83                    expr: hr
 84                    type: string
 85      Reduce Operator Tree:
 86        Join Operator
 87          condition map:
 88               Inner Join 0 to 1
 89          condition expressions:
 90            0 {VALUE._col0} {VALUE._col1} {VALUE._col2} {VALUE._col3}
 91            1 {VALUE._col0} {VALUE._col1} {VALUE._col2} {VALUE._col3}
 92          handleSkewJoin: false
 93          outputColumnNames: _col0, _col1, _col2, _col3, _col6, _col7, _col8, _col9
 94          Filter Operator
 95            predicate:
 96                expr: (((_col2 = '2008-04-08') and (_col8 = '2008-04-08')) and CASE (_col0) WHEN ('27') THEN (true) WHEN ('38') THEN (false) ELSE (null) END)
 97                type: boolean
 98            Select Operator
 99              expressions:
100                    expr: _col0
101                    type: string
102                    expr: _col1
103                    type: string
104                    expr: _col2
105                    type: string
106                    expr: _col3
107                    type: string
108                    expr: _col6
109                    type: string
110                    expr: _col7
111                    type: string
112                    expr: _col8
113                    type: string
114                    expr: _col9
115                    type: string
116              outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7
117              File Output Operator
118                compressed: false
119                GlobalTableId: 0
120                table:
121                    input format: org.apache.hadoop.mapred.SequenceFileInputFormat
122                    output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
123
124  Stage: Stage-2
125    Map Reduce
126      Alias -> Map Operator Tree:
127        file:/var/folders/uc/ucuNeMAVGQGzy3459D8z2+++Z0Q/-Tmp-/amarsri/hive_2011-03-22_02-53-19_011_6078693060764998539/-mr-10002 
128            Reduce Output Operator
129              key expressions:
130                    expr: _col0
131                    type: string
132                    expr: _col1
133                    type: string
134                    expr: _col2
135                    type: string
136                    expr: _col3
137                    type: string
138                    expr: _col4
139                    type: string
140                    expr: _col5
141                    type: string
142                    expr: _col6
143                    type: string
144                    expr: _col7
145                    type: string
146              sort order: ++++++++
147              tag: -1
148              value expressions:
149                    expr: _col0
150                    type: string
151                    expr: _col1
152                    type: string
153                    expr: _col2
154                    type: string
155                    expr: _col3
156                    type: string
157                    expr: _col4
158                    type: string
159                    expr: _col5
160                    type: string
161                    expr: _col6
162                    type: string
163                    expr: _col7
164                    type: string
165      Reduce Operator Tree:
166        Extract
167          File Output Operator
168            compressed: false
169            GlobalTableId: 0
170            table:
171                input format: org.apache.hadoop.mapred.TextInputFormat
172                output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
173
174  Stage: Stage-0
175    Fetch Operator
176      limit: -1
177
178
179PREHOOK: query: SELECT *
180FROM srcpart a JOIN srcpart b
181ON a.key = b.key
182WHERE a.ds = '2008-04-08' AND
183      b.ds = '2008-04-08' AND
184      CASE a.key
185        WHEN '27' THEN TRUE
186        WHEN '38' THEN FALSE
187        ELSE NULL
188       END
189ORDER BY a.key, a.value, a.ds, a.hr, b.key, b.value, b.ds, b.hr
190PREHOOK: type: QUERY
191PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
192PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
193PREHOOK: Output: file:/var/folders/uc/ucuNeMAVGQGzy3459D8z2+++Z0Q/-Tmp-/amarsri/hive_2011-03-22_02-53-20_085_7457265695938103038/-mr-10000
194POSTHOOK: query: SELECT *
195FROM srcpart a JOIN srcpart b
196ON a.key = b.key
197WHERE a.ds = '2008-04-08' AND
198      b.ds = '2008-04-08' AND
199      CASE a.key
200        WHEN '27' THEN TRUE
201        WHEN '38' THEN FALSE
202        ELSE NULL
203       END
204ORDER BY a.key, a.value, a.ds, a.hr, b.key, b.value, b.ds, b.hr
205POSTHOOK: type: QUERY
206POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
207POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
208POSTHOOK: Output: file:/var/folders/uc/ucuNeMAVGQGzy3459D8z2+++Z0Q/-Tmp-/amarsri/hive_2011-03-22_02-53-20_085_7457265695938103038/-mr-10000
20927	val_27	2008-04-08	11	27	val_27	2008-04-08	11
21027	val_27	2008-04-08	11	27	val_27	2008-04-08	12
21127	val_27	2008-04-08	12	27	val_27	2008-04-08	11
21227	val_27	2008-04-08	12	27	val_27	2008-04-08	12
213PREHOOK: query: EXPLAIN
214SELECT *
215FROM srcpart a JOIN srcpart b
216ON a.key = b.key
217WHERE a.ds = '2008-04-08' AND
218      b.ds = '2008-04-08' AND
219      CASE a.key
220        WHEN '27' THEN TRUE
221        WHEN '38' THEN FALSE
222        ELSE NULL
223       END
224ORDER BY a.key, a.value, a.ds, a.hr, b.key, b.value, b.ds, b.hr
225PREHOOK: type: QUERY
226POSTHOOK: query: EXPLAIN
227SELECT *
228FROM srcpart a JOIN srcpart b
229ON a.key = b.key
230WHERE a.ds = '2008-04-08' AND
231      b.ds = '2008-04-08' AND
232      CASE a.key
233        WHEN '27' THEN TRUE
234        WHEN '38' THEN FALSE
235        ELSE NULL
236       END
237ORDER BY a.key, a.value, a.ds, a.hr, b.key, b.value, b.ds, b.hr
238POSTHOOK: type: QUERY
239ABSTRACT SYNTAX TREE:
240  (TOK_QUERY (TOK_FROM (TOK_JOIN (TOK_TABREF (TOK_TABNAME srcpart) a) (TOK_TABREF (TOK_TABNAME srcpart) 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_ALLCOLREF)) (TOK_WHERE (AND (AND (= (. (TOK_TABLE_OR_COL a) ds) '2008-04-08') (= (. (TOK_TABLE_OR_COL b) ds) '2008-04-08')) (TOK_FUNCTION CASE (. (TOK_TABLE_OR_COL a) key) '27' TRUE '38' FALSE TOK_NULL))) (TOK_ORDERBY (TOK_TABSORTCOLNAMEASC (. (TOK_TABLE_OR_COL a) key)) (TOK_TABSORTCOLNAMEASC (. (TOK_TABLE_OR_COL a) value)) (TOK_TABSORTCOLNAMEASC (. (TOK_TABLE_OR_COL a) ds)) (TOK_TABSORTCOLNAMEASC (. (TOK_TABLE_OR_COL a) hr)) (TOK_TABSORTCOLNAMEASC (. (TOK_TABLE_OR_COL b) key)) (TOK_TABSORTCOLNAMEASC (. (TOK_TABLE_OR_COL b) value)) (TOK_TABSORTCOLNAMEASC (. (TOK_TABLE_OR_COL b) ds)) (TOK_TABSORTCOLNAMEASC (. (TOK_TABLE_OR_COL b) hr)))))
241
242STAGE DEPENDENCIES:
243  Stage-1 is a root stage
244  Stage-2 depends on stages: Stage-1
245  Stage-0 is a root stage
246
247STAGE PLANS:
248  Stage: Stage-1
249    Map Reduce
250      Alias -> Map Operator Tree:
251        a 
252          TableScan
253            alias: a
254            Filter Operator
255              predicate:
256                  expr: CASE (key) WHEN ('27') THEN (true) WHEN ('38') THEN (false) ELSE (null) END
257                  type: boolean
258              Reduce Output Operator
259                key expressions:
260                      expr: key
261                      type: string
262                sort order: +
263                Map-reduce partition columns:
264                      expr: key
265                      type: string
266                tag: 0
267                value expressions:
268                      expr: key
269                      type: string
270                      expr: value
271                      type: string
272                      expr: ds
273                      type: string
274                      expr: hr
275                      type: string
276        b 
277          TableScan
278            alias: b
279            Reduce Output Operator
280              key expressions:
281                    expr: key
282                    type: string
283              sort order: +
284              Map-reduce partition columns:
285                    expr: key
286                    type: string
287              tag: 1
288              value expressions:
289                    expr: key
290                    type: string
291                    expr: value
292                    type: string
293                    expr: ds
294                    type: string
295                    expr: hr
296                    type: string
297      Reduce Operator Tree:
298        Join Operator
299          condition map:
300               Inner Join 0 to 1
301          condition expressions:
302            0 {VALUE._col0} {VALUE._col1} {VALUE._col2} {VALUE._col3}
303            1 {VALUE._col0} {VALUE._col1} {VALUE._col2} {VALUE._col3}
304          handleSkewJoin: false
305          outputColumnNames: _col0, _col1, _col2, _col3, _col6, _col7, _col8, _col9
306          Select Operator
307            expressions:
308                  expr: _col0
309                  type: string
310                  expr: _col1
311                  type: string
312                  expr: _col2
313                  type: string
314                  expr: _col3
315                  type: string
316                  expr: _col6
317                  type: string
318                  expr: _col7
319                  type: string
320                  expr: _col8
321                  type: string
322                  expr: _col9
323                  type: string
324            outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7
325            File Output Operator
326              compressed: false
327              GlobalTableId: 0
328              table:
329                  input format: org.apache.hadoop.mapred.SequenceFileInputFormat
330                  output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
331
332  Stage: Stage-2
333    Map Reduce
334      Alias -> Map Operator Tree:
335        file:/var/folders/uc/ucuNeMAVGQGzy3459D8z2+++Z0Q/-Tmp-/amarsri/hive_2011-03-22_02-53-40_322_7654615073140246084/-mr-10002 
336            Reduce Output Operator
337              key expressions:
338                    expr: _col0
339                    type: string
340                    expr: _col1
341                    type: string
342                    expr: _col2
343                    type: string
344                    expr: _col3
345                    type: string
346                    expr: _col4
347                    type: string
348                    expr: _col5
349                    type: string
350                    expr: _col6
351                    type: string
352                    expr: _col7
353                    type: string
354              sort order: ++++++++
355              tag: -1
356              value expressions:
357                    expr: _col0
358                    type: string
359                    expr: _col1
360                    type: string
361                    expr: _col2
362                    type: string
363                    expr: _col3
364                    type: string
365                    expr: _col4
366                    type: string
367                    expr: _col5
368                    type: string
369                    expr: _col6
370                    type: string
371                    expr: _col7
372                    type: string
373      Reduce Operator Tree:
374        Extract
375          File Output Operator
376            compressed: false
377            GlobalTableId: 0
378            table:
379                input format: org.apache.hadoop.mapred.TextInputFormat
380                output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
381
382  Stage: Stage-0
383    Fetch Operator
384      limit: -1
385
386
387PREHOOK: query: SELECT *
388FROM srcpart a JOIN srcpart b
389ON a.key = b.key
390WHERE a.ds = '2008-04-08' AND
391      b.ds = '2008-04-08' AND
392      CASE a.key
393        WHEN '27' THEN TRUE
394        WHEN '38' THEN FALSE
395        ELSE NULL
396       END
397ORDER BY a.key, a.value, a.ds, a.hr, b.key, b.value, b.ds, b.hr
398PREHOOK: type: QUERY
399PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
400PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
401PREHOOK: Output: file:/var/folders/uc/ucuNeMAVGQGzy3459D8z2+++Z0Q/-Tmp-/amarsri/hive_2011-03-22_02-53-40_840_3692167909003016050/-mr-10000
402POSTHOOK: query: SELECT *
403FROM srcpart a JOIN srcpart b
404ON a.key = b.key
405WHERE a.ds = '2008-04-08' AND
406      b.ds = '2008-04-08' AND
407      CASE a.key
408        WHEN '27' THEN TRUE
409        WHEN '38' THEN FALSE
410        ELSE NULL
411       END
412ORDER BY a.key, a.value, a.ds, a.hr, b.key, b.value, b.ds, b.hr
413POSTHOOK: type: QUERY
414POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
415POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
416POSTHOOK: Output: file:/var/folders/uc/ucuNeMAVGQGzy3459D8z2+++Z0Q/-Tmp-/amarsri/hive_2011-03-22_02-53-40_840_3692167909003016050/-mr-10000
41727	val_27	2008-04-08	11	27	val_27	2008-04-08	11
41827	val_27	2008-04-08	11	27	val_27	2008-04-08	12
41927	val_27	2008-04-08	12	27	val_27	2008-04-08	11
42027	val_27	2008-04-08	12	27	val_27	2008-04-08	12