PageRenderTime 21ms CodeModel.GetById 15ms app.highlight 2ms RepoModel.GetById 1ms app.codeStats 0ms

/tags/release-0.0.0-rc0/hive/external/ql/src/test/results/clientpositive/mapreduce4.q.out

#
text | 644 lines | 638 code | 6 blank | 0 comment | 0 complexity | 6a0363cb334e0a0c517416a4096e296e 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
  9MAP src.key, CAST(src.key / 10 AS INT), CAST(src.key % 10 AS INT), src.value
 10USING '/bin/cat' AS (tkey, ten, one, tvalue)
 11DISTRIBUTE BY tvalue, tkey
 12SORT BY ten DESC, one ASC
 13PREHOOK: type: QUERY
 14POSTHOOK: query: EXPLAIN
 15FROM src
 16INSERT OVERWRITE TABLE dest1
 17MAP src.key, CAST(src.key / 10 AS INT), CAST(src.key % 10 AS INT), src.value
 18USING '/bin/cat' AS (tkey, ten, one, tvalue)
 19DISTRIBUTE BY tvalue, tkey
 20SORT BY ten DESC, one ASC
 21POSTHOOK: type: QUERY
 22ABSTRACT SYNTAX TREE:
 23  (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME src))) (TOK_INSERT (TOK_DESTINATION (TOK_TAB (TOK_TABNAME dest1))) (TOK_SELECT (TOK_SELEXPR (TOK_TRANSFORM (TOK_EXPLIST (. (TOK_TABLE_OR_COL src) key) (TOK_FUNCTION TOK_INT (/ (. (TOK_TABLE_OR_COL src) key) 10)) (TOK_FUNCTION TOK_INT (% (. (TOK_TABLE_OR_COL src) key) 10)) (. (TOK_TABLE_OR_COL src) value)) TOK_SERDE TOK_RECORDWRITER '/bin/cat' TOK_SERDE TOK_RECORDREADER (TOK_ALIASLIST tkey ten one tvalue)))) (TOK_DISTRIBUTEBY (TOK_TABLE_OR_COL tvalue) (TOK_TABLE_OR_COL tkey)) (TOK_SORTBY (TOK_TABSORTCOLNAMEDESC (TOK_TABLE_OR_COL ten)) (TOK_TABSORTCOLNAMEASC (TOK_TABLE_OR_COL one)))))
 24
 25STAGE DEPENDENCIES:
 26  Stage-1 is a root stage
 27  Stage-0 depends on stages: Stage-1
 28  Stage-2 depends on stages: Stage-0
 29
 30STAGE PLANS:
 31  Stage: Stage-1
 32    Map Reduce
 33      Alias -> Map Operator Tree:
 34        src 
 35          TableScan
 36            alias: src
 37            Select Operator
 38              expressions:
 39                    expr: key
 40                    type: string
 41                    expr: UDFToInteger((key / 10))
 42                    type: int
 43                    expr: UDFToInteger((key % 10))
 44                    type: int
 45                    expr: value
 46                    type: string
 47              outputColumnNames: _col0, _col1, _col2, _col3
 48              Transform Operator
 49                command: /bin/cat
 50                output info:
 51                    input format: org.apache.hadoop.mapred.TextInputFormat
 52                    output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
 53                Reduce Output Operator
 54                  key expressions:
 55                        expr: _col1
 56                        type: string
 57                        expr: _col2
 58                        type: string
 59                  sort order: -+
 60                  Map-reduce partition columns:
 61                        expr: _col3
 62                        type: string
 63                        expr: _col0
 64                        type: string
 65                  tag: -1
 66                  value expressions:
 67                        expr: _col0
 68                        type: string
 69                        expr: _col1
 70                        type: string
 71                        expr: _col2
 72                        type: string
 73                        expr: _col3
 74                        type: string
 75      Reduce Operator Tree:
 76        Extract
 77          Select Operator
 78            expressions:
 79                  expr: UDFToInteger(_col0)
 80                  type: int
 81                  expr: UDFToInteger(_col1)
 82                  type: int
 83                  expr: UDFToInteger(_col2)
 84                  type: int
 85                  expr: _col3
 86                  type: string
 87            outputColumnNames: _col0, _col1, _col2, _col3
 88            File Output Operator
 89              compressed: false
 90              GlobalTableId: 1
 91              table:
 92                  input format: org.apache.hadoop.mapred.TextInputFormat
 93                  output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
 94                  serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
 95                  name: default.dest1
 96
 97  Stage: Stage-0
 98    Move Operator
 99      tables:
100          replace: true
101          table:
102              input format: org.apache.hadoop.mapred.TextInputFormat
103              output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
104              serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
105              name: default.dest1
106
107  Stage: Stage-2
108    Stats-Aggr Operator
109
110
111PREHOOK: query: FROM src
112INSERT OVERWRITE TABLE dest1
113MAP src.key, CAST(src.key / 10 AS INT), CAST(src.key % 10 AS INT), src.value
114USING '/bin/cat' AS (tkey, ten, one, tvalue)
115DISTRIBUTE BY tvalue, tkey
116SORT BY ten DESC, one ASC
117PREHOOK: type: QUERY
118PREHOOK: Input: default@src
119PREHOOK: Output: default@dest1
120POSTHOOK: query: FROM src
121INSERT OVERWRITE TABLE dest1
122MAP src.key, CAST(src.key / 10 AS INT), CAST(src.key % 10 AS INT), src.value
123USING '/bin/cat' AS (tkey, ten, one, tvalue)
124DISTRIBUTE BY tvalue, tkey
125SORT BY ten DESC, one ASC
126POSTHOOK: type: QUERY
127POSTHOOK: Input: default@src
128POSTHOOK: Output: default@dest1
129POSTHOOK: Lineage: dest1.key SCRIPT [(src)src.FieldSchema(name:key, type:string, comment:default), (src)src.FieldSchema(name:value, type:string, comment:default), ]
130POSTHOOK: Lineage: dest1.one SCRIPT [(src)src.FieldSchema(name:key, type:string, comment:default), (src)src.FieldSchema(name:value, type:string, comment:default), ]
131POSTHOOK: Lineage: dest1.ten SCRIPT [(src)src.FieldSchema(name:key, type:string, comment:default), (src)src.FieldSchema(name:value, type:string, comment:default), ]
132POSTHOOK: Lineage: dest1.value SCRIPT [(src)src.FieldSchema(name:key, type:string, comment:default), (src)src.FieldSchema(name:value, type:string, comment:default), ]
133PREHOOK: query: SELECT dest1.* FROM dest1
134PREHOOK: type: QUERY
135PREHOOK: Input: default@dest1
136PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_16-40-10_476_6558985744990648204/-mr-10000
137POSTHOOK: query: SELECT dest1.* FROM dest1
138POSTHOOK: type: QUERY
139POSTHOOK: Input: default@dest1
140POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_16-40-10_476_6558985744990648204/-mr-10000
141POSTHOOK: Lineage: dest1.key SCRIPT [(src)src.FieldSchema(name:key, type:string, comment:default), (src)src.FieldSchema(name:value, type:string, comment:default), ]
142POSTHOOK: Lineage: dest1.one SCRIPT [(src)src.FieldSchema(name:key, type:string, comment:default), (src)src.FieldSchema(name:value, type:string, comment:default), ]
143POSTHOOK: Lineage: dest1.ten SCRIPT [(src)src.FieldSchema(name:key, type:string, comment:default), (src)src.FieldSchema(name:value, type:string, comment:default), ]
144POSTHOOK: Lineage: dest1.value SCRIPT [(src)src.FieldSchema(name:key, type:string, comment:default), (src)src.FieldSchema(name:value, type:string, comment:default), ]
14590	9	0	val_90
14690	9	0	val_90
14790	9	0	val_90
14892	9	2	val_92
14995	9	5	val_95
15095	9	5	val_95
15196	9	6	val_96
15297	9	7	val_97
15397	9	7	val_97
15498	9	8	val_98
15598	9	8	val_98
15680	8	0	val_80
15782	8	2	val_82
15883	8	3	val_83
15983	8	3	val_83
16084	8	4	val_84
16184	8	4	val_84
16285	8	5	val_85
16386	8	6	val_86
16487	8	7	val_87
16570	7	0	val_70
16670	7	0	val_70
16770	7	0	val_70
16872	7	2	val_72
16972	7	2	val_72
17074	7	4	val_74
17176	7	6	val_76
17276	7	6	val_76
17377	7	7	val_77
17478	7	8	val_78
17564	6	4	val_64
17665	6	5	val_65
17766	6	6	val_66
17867	6	7	val_67
17967	6	7	val_67
18069	6	9	val_69
18151	5	1	val_51
18251	5	1	val_51
18353	5	3	val_53
18454	5	4	val_54
18557	5	7	val_57
18658	5	8	val_58
18758	5	8	val_58
188490	49	0	val_490
189491	49	1	val_491
190492	49	2	val_492
191492	49	2	val_492
192493	49	3	val_493
193494	49	4	val_494
194495	49	5	val_495
195496	49	6	val_496
196497	49	7	val_497
197498	49	8	val_498
198498	49	8	val_498
199498	49	8	val_498
200480	48	0	val_480
201480	48	0	val_480
202480	48	0	val_480
203481	48	1	val_481
204482	48	2	val_482
205483	48	3	val_483
206484	48	4	val_484
207485	48	5	val_485
208487	48	7	val_487
209489	48	9	val_489
210489	48	9	val_489
211489	48	9	val_489
212489	48	9	val_489
213470	47	0	val_470
214472	47	2	val_472
215475	47	5	val_475
216477	47	7	val_477
217478	47	8	val_478
218478	47	8	val_478
219479	47	9	val_479
220460	46	0	val_460
221462	46	2	val_462
222462	46	2	val_462
223463	46	3	val_463
224463	46	3	val_463
225466	46	6	val_466
226466	46	6	val_466
227466	46	6	val_466
228467	46	7	val_467
229468	46	8	val_468
230468	46	8	val_468
231468	46	8	val_468
232468	46	8	val_468
233469	46	9	val_469
234469	46	9	val_469
235469	46	9	val_469
236469	46	9	val_469
237469	46	9	val_469
238452	45	2	val_452
239453	45	3	val_453
240454	45	4	val_454
241454	45	4	val_454
242454	45	4	val_454
243455	45	5	val_455
244457	45	7	val_457
245458	45	8	val_458
246458	45	8	val_458
247459	45	9	val_459
248459	45	9	val_459
249443	44	3	val_443
250444	44	4	val_444
251446	44	6	val_446
252448	44	8	val_448
253449	44	9	val_449
254430	43	0	val_430
255430	43	0	val_430
256430	43	0	val_430
257431	43	1	val_431
258431	43	1	val_431
259431	43	1	val_431
260432	43	2	val_432
261435	43	5	val_435
262436	43	6	val_436
263437	43	7	val_437
264438	43	8	val_438
265438	43	8	val_438
266438	43	8	val_438
267439	43	9	val_439
268439	43	9	val_439
269421	42	1	val_421
270424	42	4	val_424
271424	42	4	val_424
272427	42	7	val_427
273429	42	9	val_429
274429	42	9	val_429
275411	41	1	val_411
276413	41	3	val_413
277413	41	3	val_413
278414	41	4	val_414
279414	41	4	val_414
280417	41	7	val_417
281417	41	7	val_417
282417	41	7	val_417
283418	41	8	val_418
284419	41	9	val_419
285400	40	0	val_400
286401	40	1	val_401
287401	40	1	val_401
288401	40	1	val_401
289401	40	1	val_401
290401	40	1	val_401
291402	40	2	val_402
292403	40	3	val_403
293403	40	3	val_403
294403	40	3	val_403
295404	40	4	val_404
296404	40	4	val_404
297406	40	6	val_406
298406	40	6	val_406
299406	40	6	val_406
300406	40	6	val_406
301407	40	7	val_407
302409	40	9	val_409
303409	40	9	val_409
304409	40	9	val_409
30541	4	1	val_41
30642	4	2	val_42
30742	4	2	val_42
30843	4	3	val_43
30944	4	4	val_44
31047	4	7	val_47
311392	39	2	val_392
312393	39	3	val_393
313394	39	4	val_394
314395	39	5	val_395
315395	39	5	val_395
316396	39	6	val_396
317396	39	6	val_396
318396	39	6	val_396
319397	39	7	val_397
320397	39	7	val_397
321399	39	9	val_399
322399	39	9	val_399
323382	38	2	val_382
324382	38	2	val_382
325384	38	4	val_384
326384	38	4	val_384
327384	38	4	val_384
328386	38	6	val_386
329389	38	9	val_389
330373	37	3	val_373
331374	37	4	val_374
332375	37	5	val_375
333377	37	7	val_377
334378	37	8	val_378
335379	37	9	val_379
336360	36	0	val_360
337362	36	2	val_362
338364	36	4	val_364
339365	36	5	val_365
340366	36	6	val_366
341367	36	7	val_367
342367	36	7	val_367
343368	36	8	val_368
344369	36	9	val_369
345369	36	9	val_369
346369	36	9	val_369
347351	35	1	val_351
348353	35	3	val_353
349353	35	3	val_353
350356	35	6	val_356
351341	34	1	val_341
352342	34	2	val_342
353342	34	2	val_342
354344	34	4	val_344
355344	34	4	val_344
356345	34	5	val_345
357348	34	8	val_348
358348	34	8	val_348
359348	34	8	val_348
360348	34	8	val_348
361348	34	8	val_348
362331	33	1	val_331
363331	33	1	val_331
364332	33	2	val_332
365333	33	3	val_333
366333	33	3	val_333
367335	33	5	val_335
368336	33	6	val_336
369338	33	8	val_338
370339	33	9	val_339
371321	32	1	val_321
372321	32	1	val_321
373322	32	2	val_322
374322	32	2	val_322
375323	32	3	val_323
376325	32	5	val_325
377325	32	5	val_325
378327	32	7	val_327
379327	32	7	val_327
380327	32	7	val_327
381310	31	0	val_310
382311	31	1	val_311
383311	31	1	val_311
384311	31	1	val_311
385315	31	5	val_315
386316	31	6	val_316
387316	31	6	val_316
388316	31	6	val_316
389317	31	7	val_317
390317	31	7	val_317
391318	31	8	val_318
392318	31	8	val_318
393318	31	8	val_318
394302	30	2	val_302
395305	30	5	val_305
396306	30	6	val_306
397307	30	7	val_307
398307	30	7	val_307
399308	30	8	val_308
400309	30	9	val_309
401309	30	9	val_309
40230	3	0	val_30
40333	3	3	val_33
40434	3	4	val_34
40535	3	5	val_35
40635	3	5	val_35
40735	3	5	val_35
40837	3	7	val_37
40937	3	7	val_37
410291	29	1	val_291
411292	29	2	val_292
412296	29	6	val_296
413298	29	8	val_298
414298	29	8	val_298
415298	29	8	val_298
416280	28	0	val_280
417280	28	0	val_280
418281	28	1	val_281
419281	28	1	val_281
420282	28	2	val_282
421282	28	2	val_282
422283	28	3	val_283
423284	28	4	val_284
424285	28	5	val_285
425286	28	6	val_286
426287	28	7	val_287
427288	28	8	val_288
428288	28	8	val_288
429289	28	9	val_289
430272	27	2	val_272
431272	27	2	val_272
432273	27	3	val_273
433273	27	3	val_273
434273	27	3	val_273
435274	27	4	val_274
436275	27	5	val_275
437277	27	7	val_277
438277	27	7	val_277
439277	27	7	val_277
440277	27	7	val_277
441278	27	8	val_278
442278	27	8	val_278
443260	26	0	val_260
444262	26	2	val_262
445263	26	3	val_263
446265	26	5	val_265
447265	26	5	val_265
448266	26	6	val_266
449252	25	2	val_252
450255	25	5	val_255
451255	25	5	val_255
452256	25	6	val_256
453256	25	6	val_256
454257	25	7	val_257
455258	25	8	val_258
456241	24	1	val_241
457242	24	2	val_242
458242	24	2	val_242
459244	24	4	val_244
460247	24	7	val_247
461248	24	8	val_248
462249	24	9	val_249
463230	23	0	val_230
464230	23	0	val_230
465230	23	0	val_230
466230	23	0	val_230
467230	23	0	val_230
468233	23	3	val_233
469233	23	3	val_233
470235	23	5	val_235
471237	23	7	val_237
472237	23	7	val_237
473238	23	8	val_238
474238	23	8	val_238
475239	23	9	val_239
476239	23	9	val_239
477221	22	1	val_221
478221	22	1	val_221
479222	22	2	val_222
480223	22	3	val_223
481223	22	3	val_223
482224	22	4	val_224
483224	22	4	val_224
484226	22	6	val_226
485228	22	8	val_228
486229	22	9	val_229
487229	22	9	val_229
488213	21	3	val_213
489213	21	3	val_213
490214	21	4	val_214
491216	21	6	val_216
492216	21	6	val_216
493217	21	7	val_217
494217	21	7	val_217
495218	21	8	val_218
496219	21	9	val_219
497219	21	9	val_219
498200	20	0	val_200
499200	20	0	val_200
500201	20	1	val_201
501202	20	2	val_202
502203	20	3	val_203
503203	20	3	val_203
504205	20	5	val_205
505205	20	5	val_205
506207	20	7	val_207
507207	20	7	val_207
508208	20	8	val_208
509208	20	8	val_208
510208	20	8	val_208
511209	20	9	val_209
512209	20	9	val_209
51320	2	0	val_20
51424	2	4	val_24
51524	2	4	val_24
51626	2	6	val_26
51726	2	6	val_26
51827	2	7	val_27
51928	2	8	val_28
520190	19	0	val_190
521191	19	1	val_191
522191	19	1	val_191
523192	19	2	val_192
524193	19	3	val_193
525193	19	3	val_193
526193	19	3	val_193
527194	19	4	val_194
528195	19	5	val_195
529195	19	5	val_195
530196	19	6	val_196
531197	19	7	val_197
532197	19	7	val_197
533199	19	9	val_199
534199	19	9	val_199
535199	19	9	val_199
536180	18	0	val_180
537181	18	1	val_181
538183	18	3	val_183
539186	18	6	val_186
540187	18	7	val_187
541187	18	7	val_187
542187	18	7	val_187
543189	18	9	val_189
544170	17	0	val_170
545172	17	2	val_172
546172	17	2	val_172
547174	17	4	val_174
548174	17	4	val_174
549175	17	5	val_175
550175	17	5	val_175
551176	17	6	val_176
552176	17	6	val_176
553177	17	7	val_177
554178	17	8	val_178
555179	17	9	val_179
556179	17	9	val_179
557160	16	0	val_160
558162	16	2	val_162
559163	16	3	val_163
560164	16	4	val_164
561164	16	4	val_164
562165	16	5	val_165
563165	16	5	val_165
564166	16	6	val_166
565167	16	7	val_167
566167	16	7	val_167
567167	16	7	val_167
568168	16	8	val_168
569169	16	9	val_169
570169	16	9	val_169
571169	16	9	val_169
572169	16	9	val_169
573150	15	0	val_150
574152	15	2	val_152
575152	15	2	val_152
576153	15	3	val_153
577155	15	5	val_155
578156	15	6	val_156
579157	15	7	val_157
580158	15	8	val_158
581143	14	3	val_143
582145	14	5	val_145
583146	14	6	val_146
584146	14	6	val_146
585149	14	9	val_149
586149	14	9	val_149
587131	13	1	val_131
588133	13	3	val_133
589134	13	4	val_134
590134	13	4	val_134
591136	13	6	val_136
592137	13	7	val_137
593137	13	7	val_137
594138	13	8	val_138
595138	13	8	val_138
596138	13	8	val_138
597138	13	8	val_138
598120	12	0	val_120
599120	12	0	val_120
600125	12	5	val_125
601125	12	5	val_125
602126	12	6	val_126
603128	12	8	val_128
604128	12	8	val_128
605128	12	8	val_128
606129	12	9	val_129
607129	12	9	val_129
608111	11	1	val_111
609113	11	3	val_113
610113	11	3	val_113
611114	11	4	val_114
612116	11	6	val_116
613118	11	8	val_118
614118	11	8	val_118
615119	11	9	val_119
616119	11	9	val_119
617119	11	9	val_119
618100	10	0	val_100
619100	10	0	val_100
620103	10	3	val_103
621103	10	3	val_103
622104	10	4	val_104
623104	10	4	val_104
624105	10	5	val_105
62510	1	0	val_10
62611	1	1	val_11
62712	1	2	val_12
62812	1	2	val_12
62915	1	5	val_15
63015	1	5	val_15
63117	1	7	val_17
63218	1	8	val_18
63318	1	8	val_18
63419	1	9	val_19
6350	0	0	val_0
6360	0	0	val_0
6370	0	0	val_0
6382	0	2	val_2
6394	0	4	val_4
6405	0	5	val_5
6415	0	5	val_5
6425	0	5	val_5
6438	0	8	val_8
6449	0	9	val_9