PageRenderTime 33ms CodeModel.GetById 20ms app.highlight 6ms RepoModel.GetById 1ms app.codeStats 0ms

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

#
text | 635 lines | 629 code | 6 blank | 0 comment | 0 complexity | d3e6c259838aeca8aedb92d67f5bf3f1 MD5 | raw file
  1PREHOOK: query: CREATE TABLE dest1(key INT, ten INT, one INT, value STRING) STORED AS TEXTFILE
  2PREHOOK: type: CREATETABLE
  3POSTHOOK: query: CREATE TABLE dest1(key INT, ten INT, one INT, value STRING) STORED AS TEXTFILE
  4POSTHOOK: type: CREATETABLE
  5POSTHOOK: Output: default@dest1
  6PREHOOK: query: EXPLAIN
  7FROM src
  8INSERT OVERWRITE TABLE dest1
  9SELECT src.key as c1, CAST(src.key / 10 AS INT) as c2, CAST(src.key % 10 AS INT) as c3, src.value as c4
 10DISTRIBUTE BY c4, c1
 11SORT BY c2 DESC, c3 ASC
 12PREHOOK: type: QUERY
 13POSTHOOK: query: EXPLAIN
 14FROM src
 15INSERT OVERWRITE TABLE dest1
 16SELECT src.key as c1, CAST(src.key / 10 AS INT) as c2, CAST(src.key % 10 AS INT) as c3, src.value as c4
 17DISTRIBUTE BY c4, c1
 18SORT BY c2 DESC, c3 ASC
 19POSTHOOK: type: QUERY
 20ABSTRACT SYNTAX TREE:
 21  (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME src))) (TOK_INSERT (TOK_DESTINATION (TOK_TAB (TOK_TABNAME dest1))) (TOK_SELECT (TOK_SELEXPR (. (TOK_TABLE_OR_COL src) key) c1) (TOK_SELEXPR (TOK_FUNCTION TOK_INT (/ (. (TOK_TABLE_OR_COL src) key) 10)) c2) (TOK_SELEXPR (TOK_FUNCTION TOK_INT (% (. (TOK_TABLE_OR_COL src) key) 10)) c3) (TOK_SELEXPR (. (TOK_TABLE_OR_COL src) value) c4)) (TOK_DISTRIBUTEBY (TOK_TABLE_OR_COL c4) (TOK_TABLE_OR_COL c1)) (TOK_SORTBY (TOK_TABSORTCOLNAMEDESC (TOK_TABLE_OR_COL c2)) (TOK_TABSORTCOLNAMEASC (TOK_TABLE_OR_COL c3)))))
 22
 23STAGE DEPENDENCIES:
 24  Stage-1 is a root stage
 25  Stage-0 depends on stages: Stage-1
 26  Stage-2 depends on stages: Stage-0
 27
 28STAGE PLANS:
 29  Stage: Stage-1
 30    Map Reduce
 31      Alias -> Map Operator Tree:
 32        src 
 33          TableScan
 34            alias: src
 35            Select Operator
 36              expressions:
 37                    expr: key
 38                    type: string
 39                    expr: UDFToInteger((key / 10))
 40                    type: int
 41                    expr: UDFToInteger((key % 10))
 42                    type: int
 43                    expr: value
 44                    type: string
 45              outputColumnNames: _col0, _col1, _col2, _col3
 46              Reduce Output Operator
 47                key expressions:
 48                      expr: _col1
 49                      type: int
 50                      expr: _col2
 51                      type: int
 52                sort order: -+
 53                Map-reduce partition columns:
 54                      expr: _col3
 55                      type: string
 56                      expr: _col0
 57                      type: string
 58                tag: -1
 59                value expressions:
 60                      expr: _col0
 61                      type: string
 62                      expr: _col1
 63                      type: int
 64                      expr: _col2
 65                      type: int
 66                      expr: _col3
 67                      type: string
 68      Reduce Operator Tree:
 69        Extract
 70          Select Operator
 71            expressions:
 72                  expr: UDFToInteger(_col0)
 73                  type: int
 74                  expr: _col1
 75                  type: int
 76                  expr: _col2
 77                  type: int
 78                  expr: _col3
 79                  type: string
 80            outputColumnNames: _col0, _col1, _col2, _col3
 81            File Output Operator
 82              compressed: false
 83              GlobalTableId: 1
 84              table:
 85                  input format: org.apache.hadoop.mapred.TextInputFormat
 86                  output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
 87                  serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
 88                  name: default.dest1
 89
 90  Stage: Stage-0
 91    Move Operator
 92      tables:
 93          replace: true
 94          table:
 95              input format: org.apache.hadoop.mapred.TextInputFormat
 96              output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
 97              serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
 98              name: default.dest1
 99
100  Stage: Stage-2
101    Stats-Aggr Operator
102
103
104PREHOOK: query: FROM src
105INSERT OVERWRITE TABLE dest1
106SELECT src.key as c1, CAST(src.key / 10 AS INT) as c2, CAST(src.key % 10 AS INT) as c3, src.value as c4
107DISTRIBUTE BY c4, c1
108SORT BY c2 DESC, c3 ASC
109PREHOOK: type: QUERY
110PREHOOK: Input: default@src
111PREHOOK: Output: default@dest1
112POSTHOOK: query: FROM src
113INSERT OVERWRITE TABLE dest1
114SELECT src.key as c1, CAST(src.key / 10 AS INT) as c2, CAST(src.key % 10 AS INT) as c3, src.value as c4
115DISTRIBUTE BY c4, c1
116SORT BY c2 DESC, c3 ASC
117POSTHOOK: type: QUERY
118POSTHOOK: Input: default@src
119POSTHOOK: Output: default@dest1
120POSTHOOK: Lineage: dest1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
121POSTHOOK: Lineage: dest1.one EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
122POSTHOOK: Lineage: dest1.ten EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
123POSTHOOK: Lineage: dest1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
124PREHOOK: query: SELECT dest1.* FROM dest1
125PREHOOK: type: QUERY
126PREHOOK: Input: default@dest1
127PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_16-40-15_899_2072494023559539789/-mr-10000
128POSTHOOK: query: SELECT dest1.* FROM dest1
129POSTHOOK: type: QUERY
130POSTHOOK: Input: default@dest1
131POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_16-40-15_899_2072494023559539789/-mr-10000
132POSTHOOK: Lineage: dest1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
133POSTHOOK: Lineage: dest1.one EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
134POSTHOOK: Lineage: dest1.ten EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
135POSTHOOK: Lineage: dest1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
136490	49	0	val_490
137491	49	1	val_491
138492	49	2	val_492
139492	49	2	val_492
140493	49	3	val_493
141494	49	4	val_494
142495	49	5	val_495
143496	49	6	val_496
144497	49	7	val_497
145498	49	8	val_498
146498	49	8	val_498
147498	49	8	val_498
148480	48	0	val_480
149480	48	0	val_480
150480	48	0	val_480
151481	48	1	val_481
152482	48	2	val_482
153483	48	3	val_483
154484	48	4	val_484
155485	48	5	val_485
156487	48	7	val_487
157489	48	9	val_489
158489	48	9	val_489
159489	48	9	val_489
160489	48	9	val_489
161470	47	0	val_470
162472	47	2	val_472
163475	47	5	val_475
164477	47	7	val_477
165478	47	8	val_478
166478	47	8	val_478
167479	47	9	val_479
168460	46	0	val_460
169462	46	2	val_462
170462	46	2	val_462
171463	46	3	val_463
172463	46	3	val_463
173466	46	6	val_466
174466	46	6	val_466
175466	46	6	val_466
176467	46	7	val_467
177468	46	8	val_468
178468	46	8	val_468
179468	46	8	val_468
180468	46	8	val_468
181469	46	9	val_469
182469	46	9	val_469
183469	46	9	val_469
184469	46	9	val_469
185469	46	9	val_469
186452	45	2	val_452
187453	45	3	val_453
188454	45	4	val_454
189454	45	4	val_454
190454	45	4	val_454
191455	45	5	val_455
192457	45	7	val_457
193458	45	8	val_458
194458	45	8	val_458
195459	45	9	val_459
196459	45	9	val_459
197443	44	3	val_443
198444	44	4	val_444
199446	44	6	val_446
200448	44	8	val_448
201449	44	9	val_449
202430	43	0	val_430
203430	43	0	val_430
204430	43	0	val_430
205431	43	1	val_431
206431	43	1	val_431
207431	43	1	val_431
208432	43	2	val_432
209435	43	5	val_435
210436	43	6	val_436
211437	43	7	val_437
212438	43	8	val_438
213438	43	8	val_438
214438	43	8	val_438
215439	43	9	val_439
216439	43	9	val_439
217421	42	1	val_421
218424	42	4	val_424
219424	42	4	val_424
220427	42	7	val_427
221429	42	9	val_429
222429	42	9	val_429
223411	41	1	val_411
224413	41	3	val_413
225413	41	3	val_413
226414	41	4	val_414
227414	41	4	val_414
228417	41	7	val_417
229417	41	7	val_417
230417	41	7	val_417
231418	41	8	val_418
232419	41	9	val_419
233400	40	0	val_400
234401	40	1	val_401
235401	40	1	val_401
236401	40	1	val_401
237401	40	1	val_401
238401	40	1	val_401
239402	40	2	val_402
240403	40	3	val_403
241403	40	3	val_403
242403	40	3	val_403
243404	40	4	val_404
244404	40	4	val_404
245406	40	6	val_406
246406	40	6	val_406
247406	40	6	val_406
248406	40	6	val_406
249407	40	7	val_407
250409	40	9	val_409
251409	40	9	val_409
252409	40	9	val_409
253392	39	2	val_392
254393	39	3	val_393
255394	39	4	val_394
256395	39	5	val_395
257395	39	5	val_395
258396	39	6	val_396
259396	39	6	val_396
260396	39	6	val_396
261397	39	7	val_397
262397	39	7	val_397
263399	39	9	val_399
264399	39	9	val_399
265382	38	2	val_382
266382	38	2	val_382
267384	38	4	val_384
268384	38	4	val_384
269384	38	4	val_384
270386	38	6	val_386
271389	38	9	val_389
272373	37	3	val_373
273374	37	4	val_374
274375	37	5	val_375
275377	37	7	val_377
276378	37	8	val_378
277379	37	9	val_379
278360	36	0	val_360
279362	36	2	val_362
280364	36	4	val_364
281365	36	5	val_365
282366	36	6	val_366
283367	36	7	val_367
284367	36	7	val_367
285368	36	8	val_368
286369	36	9	val_369
287369	36	9	val_369
288369	36	9	val_369
289351	35	1	val_351
290353	35	3	val_353
291353	35	3	val_353
292356	35	6	val_356
293341	34	1	val_341
294342	34	2	val_342
295342	34	2	val_342
296344	34	4	val_344
297344	34	4	val_344
298345	34	5	val_345
299348	34	8	val_348
300348	34	8	val_348
301348	34	8	val_348
302348	34	8	val_348
303348	34	8	val_348
304331	33	1	val_331
305331	33	1	val_331
306332	33	2	val_332
307333	33	3	val_333
308333	33	3	val_333
309335	33	5	val_335
310336	33	6	val_336
311338	33	8	val_338
312339	33	9	val_339
313321	32	1	val_321
314321	32	1	val_321
315322	32	2	val_322
316322	32	2	val_322
317323	32	3	val_323
318325	32	5	val_325
319325	32	5	val_325
320327	32	7	val_327
321327	32	7	val_327
322327	32	7	val_327
323310	31	0	val_310
324311	31	1	val_311
325311	31	1	val_311
326311	31	1	val_311
327315	31	5	val_315
328316	31	6	val_316
329316	31	6	val_316
330316	31	6	val_316
331317	31	7	val_317
332317	31	7	val_317
333318	31	8	val_318
334318	31	8	val_318
335318	31	8	val_318
336302	30	2	val_302
337305	30	5	val_305
338306	30	6	val_306
339307	30	7	val_307
340307	30	7	val_307
341308	30	8	val_308
342309	30	9	val_309
343309	30	9	val_309
344291	29	1	val_291
345292	29	2	val_292
346296	29	6	val_296
347298	29	8	val_298
348298	29	8	val_298
349298	29	8	val_298
350280	28	0	val_280
351280	28	0	val_280
352281	28	1	val_281
353281	28	1	val_281
354282	28	2	val_282
355282	28	2	val_282
356283	28	3	val_283
357284	28	4	val_284
358285	28	5	val_285
359286	28	6	val_286
360287	28	7	val_287
361288	28	8	val_288
362288	28	8	val_288
363289	28	9	val_289
364272	27	2	val_272
365272	27	2	val_272
366273	27	3	val_273
367273	27	3	val_273
368273	27	3	val_273
369274	27	4	val_274
370275	27	5	val_275
371277	27	7	val_277
372277	27	7	val_277
373277	27	7	val_277
374277	27	7	val_277
375278	27	8	val_278
376278	27	8	val_278
377260	26	0	val_260
378262	26	2	val_262
379263	26	3	val_263
380265	26	5	val_265
381265	26	5	val_265
382266	26	6	val_266
383252	25	2	val_252
384255	25	5	val_255
385255	25	5	val_255
386256	25	6	val_256
387256	25	6	val_256
388257	25	7	val_257
389258	25	8	val_258
390241	24	1	val_241
391242	24	2	val_242
392242	24	2	val_242
393244	24	4	val_244
394247	24	7	val_247
395248	24	8	val_248
396249	24	9	val_249
397230	23	0	val_230
398230	23	0	val_230
399230	23	0	val_230
400230	23	0	val_230
401230	23	0	val_230
402233	23	3	val_233
403233	23	3	val_233
404235	23	5	val_235
405237	23	7	val_237
406237	23	7	val_237
407238	23	8	val_238
408238	23	8	val_238
409239	23	9	val_239
410239	23	9	val_239
411221	22	1	val_221
412221	22	1	val_221
413222	22	2	val_222
414223	22	3	val_223
415223	22	3	val_223
416224	22	4	val_224
417224	22	4	val_224
418226	22	6	val_226
419228	22	8	val_228
420229	22	9	val_229
421229	22	9	val_229
422213	21	3	val_213
423213	21	3	val_213
424214	21	4	val_214
425216	21	6	val_216
426216	21	6	val_216
427217	21	7	val_217
428217	21	7	val_217
429218	21	8	val_218
430219	21	9	val_219
431219	21	9	val_219
432200	20	0	val_200
433200	20	0	val_200
434201	20	1	val_201
435202	20	2	val_202
436203	20	3	val_203
437203	20	3	val_203
438205	20	5	val_205
439205	20	5	val_205
440207	20	7	val_207
441207	20	7	val_207
442208	20	8	val_208
443208	20	8	val_208
444208	20	8	val_208
445209	20	9	val_209
446209	20	9	val_209
447190	19	0	val_190
448191	19	1	val_191
449191	19	1	val_191
450192	19	2	val_192
451193	19	3	val_193
452193	19	3	val_193
453193	19	3	val_193
454194	19	4	val_194
455195	19	5	val_195
456195	19	5	val_195
457196	19	6	val_196
458197	19	7	val_197
459197	19	7	val_197
460199	19	9	val_199
461199	19	9	val_199
462199	19	9	val_199
463180	18	0	val_180
464181	18	1	val_181
465183	18	3	val_183
466186	18	6	val_186
467187	18	7	val_187
468187	18	7	val_187
469187	18	7	val_187
470189	18	9	val_189
471170	17	0	val_170
472172	17	2	val_172
473172	17	2	val_172
474174	17	4	val_174
475174	17	4	val_174
476175	17	5	val_175
477175	17	5	val_175
478176	17	6	val_176
479176	17	6	val_176
480177	17	7	val_177
481178	17	8	val_178
482179	17	9	val_179
483179	17	9	val_179
484160	16	0	val_160
485162	16	2	val_162
486163	16	3	val_163
487164	16	4	val_164
488164	16	4	val_164
489165	16	5	val_165
490165	16	5	val_165
491166	16	6	val_166
492167	16	7	val_167
493167	16	7	val_167
494167	16	7	val_167
495168	16	8	val_168
496169	16	9	val_169
497169	16	9	val_169
498169	16	9	val_169
499169	16	9	val_169
500150	15	0	val_150
501152	15	2	val_152
502152	15	2	val_152
503153	15	3	val_153
504155	15	5	val_155
505156	15	6	val_156
506157	15	7	val_157
507158	15	8	val_158
508143	14	3	val_143
509145	14	5	val_145
510146	14	6	val_146
511146	14	6	val_146
512149	14	9	val_149
513149	14	9	val_149
514131	13	1	val_131
515133	13	3	val_133
516134	13	4	val_134
517134	13	4	val_134
518136	13	6	val_136
519137	13	7	val_137
520137	13	7	val_137
521138	13	8	val_138
522138	13	8	val_138
523138	13	8	val_138
524138	13	8	val_138
525120	12	0	val_120
526120	12	0	val_120
527125	12	5	val_125
528125	12	5	val_125
529126	12	6	val_126
530128	12	8	val_128
531128	12	8	val_128
532128	12	8	val_128
533129	12	9	val_129
534129	12	9	val_129
535111	11	1	val_111
536113	11	3	val_113
537113	11	3	val_113
538114	11	4	val_114
539116	11	6	val_116
540118	11	8	val_118
541118	11	8	val_118
542119	11	9	val_119
543119	11	9	val_119
544119	11	9	val_119
545100	10	0	val_100
546100	10	0	val_100
547103	10	3	val_103
548103	10	3	val_103
549104	10	4	val_104
550104	10	4	val_104
551105	10	5	val_105
55290	9	0	val_90
55390	9	0	val_90
55490	9	0	val_90
55592	9	2	val_92
55695	9	5	val_95
55795	9	5	val_95
55896	9	6	val_96
55997	9	7	val_97
56097	9	7	val_97
56198	9	8	val_98
56298	9	8	val_98
56380	8	0	val_80
56482	8	2	val_82
56583	8	3	val_83
56683	8	3	val_83
56784	8	4	val_84
56884	8	4	val_84
56985	8	5	val_85
57086	8	6	val_86
57187	8	7	val_87
57270	7	0	val_70
57370	7	0	val_70
57470	7	0	val_70
57572	7	2	val_72
57672	7	2	val_72
57774	7	4	val_74
57876	7	6	val_76
57976	7	6	val_76
58077	7	7	val_77
58178	7	8	val_78
58264	6	4	val_64
58365	6	5	val_65
58466	6	6	val_66
58567	6	7	val_67
58667	6	7	val_67
58769	6	9	val_69
58851	5	1	val_51
58951	5	1	val_51
59053	5	3	val_53
59154	5	4	val_54
59257	5	7	val_57
59358	5	8	val_58
59458	5	8	val_58
59541	4	1	val_41
59642	4	2	val_42
59742	4	2	val_42
59843	4	3	val_43
59944	4	4	val_44
60047	4	7	val_47
60130	3	0	val_30
60233	3	3	val_33
60334	3	4	val_34
60435	3	5	val_35
60535	3	5	val_35
60635	3	5	val_35
60737	3	7	val_37
60837	3	7	val_37
60920	2	0	val_20
61024	2	4	val_24
61124	2	4	val_24
61226	2	6	val_26
61326	2	6	val_26
61427	2	7	val_27
61528	2	8	val_28
61610	1	0	val_10
61711	1	1	val_11
61812	1	2	val_12
61912	1	2	val_12
62015	1	5	val_15
62115	1	5	val_15
62217	1	7	val_17
62318	1	8	val_18
62418	1	8	val_18
62519	1	9	val_19
6260	0	0	val_0
6270	0	0	val_0
6280	0	0	val_0
6292	0	2	val_2
6304	0	4	val_4
6315	0	5	val_5
6325	0	5	val_5
6335	0	5	val_5
6348	0	8	val_8
6359	0	9	val_9