PageRenderTime 23ms CodeModel.GetById 12ms app.highlight 7ms RepoModel.GetById 1ms app.codeStats 0ms

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

#
text | 644 lines | 635 code | 9 blank | 0 comment | 0 complexity | fbdf402ac4fd8a88098859d73a2b9830 MD5 | raw file
  1PREHOOK: query: CREATE TABLE dest1(key INT, value STRING) STORED AS TEXTFILE
  2PREHOOK: type: CREATETABLE
  3POSTHOOK: query: CREATE TABLE dest1(key INT, value STRING) STORED AS TEXTFILE
  4POSTHOOK: type: CREATETABLE
  5POSTHOOK: Output: default@dest1
  6PREHOOK: query: EXPLAIN
  7FROM (
  8  FROM src
  9  SELECT TRANSFORM(src.key, src.value) ROW FORMAT DELIMITED FIELDS TERMINATED BY '\002'
 10  USING '/bin/cat'
 11  AS (tkey, tvalue) ROW FORMAT DELIMITED FIELDS TERMINATED BY '\002'
 12) tmap
 13INSERT OVERWRITE TABLE dest1 SELECT tkey, tvalue
 14PREHOOK: type: QUERY
 15POSTHOOK: query: EXPLAIN
 16FROM (
 17  FROM src
 18  SELECT TRANSFORM(src.key, src.value) ROW FORMAT DELIMITED FIELDS TERMINATED BY '\002'
 19  USING '/bin/cat'
 20  AS (tkey, tvalue) ROW FORMAT DELIMITED FIELDS TERMINATED BY '\002'
 21) tmap
 22INSERT OVERWRITE TABLE dest1 SELECT tkey, tvalue
 23POSTHOOK: type: QUERY
 24ABSTRACT SYNTAX TREE:
 25  (TOK_QUERY (TOK_FROM (TOK_SUBQUERY (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME src))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_TRANSFORM (TOK_EXPLIST (. (TOK_TABLE_OR_COL src) key) (. (TOK_TABLE_OR_COL src) value)) (TOK_SERDE (TOK_SERDEPROPS (TOK_TABLEROWFORMATFIELD '\002'))) TOK_RECORDWRITER '/bin/cat' (TOK_SERDE (TOK_SERDEPROPS (TOK_TABLEROWFORMATFIELD '\002'))) TOK_RECORDREADER (TOK_ALIASLIST tkey tvalue)))))) tmap)) (TOK_INSERT (TOK_DESTINATION (TOK_TAB (TOK_TABNAME dest1))) (TOK_SELECT (TOK_SELEXPR (TOK_TABLE_OR_COL tkey)) (TOK_SELEXPR (TOK_TABLE_OR_COL tvalue)))))
 26
 27STAGE DEPENDENCIES:
 28  Stage-1 is a root stage
 29  Stage-5 depends on stages: Stage-1 , consists of Stage-4, Stage-3
 30  Stage-4
 31  Stage-0 depends on stages: Stage-4, Stage-3
 32  Stage-2 depends on stages: Stage-0
 33  Stage-3
 34
 35STAGE PLANS:
 36  Stage: Stage-1
 37    Map Reduce
 38      Alias -> Map Operator Tree:
 39        tmap:src 
 40          TableScan
 41            alias: src
 42            Select Operator
 43              expressions:
 44                    expr: key
 45                    type: string
 46                    expr: value
 47                    type: string
 48              outputColumnNames: _col0, _col1
 49              Transform Operator
 50                command: /bin/cat
 51                output info:
 52                    input format: org.apache.hadoop.mapred.TextInputFormat
 53                    output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
 54                Select Operator
 55                  expressions:
 56                        expr: _col0
 57                        type: string
 58                        expr: _col1
 59                        type: string
 60                  outputColumnNames: _col0, _col1
 61                  Select Operator
 62                    expressions:
 63                          expr: UDFToInteger(_col0)
 64                          type: int
 65                          expr: _col1
 66                          type: string
 67                    outputColumnNames: _col0, _col1
 68                    File Output Operator
 69                      compressed: false
 70                      GlobalTableId: 1
 71                      table:
 72                          input format: org.apache.hadoop.mapred.TextInputFormat
 73                          output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
 74                          serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
 75                          name: default.dest1
 76
 77  Stage: Stage-5
 78    Conditional Operator
 79
 80  Stage: Stage-4
 81    Move Operator
 82      files:
 83          hdfs directory: true
 84          destination: pfile:/data/users/sdong/www/open-source-hive1/build/ql/scratchdir/hive_2011-02-10_15-55-41_805_4495946797587418312/-ext-10000
 85
 86  Stage: Stage-0
 87    Move Operator
 88      tables:
 89          replace: true
 90          table:
 91              input format: org.apache.hadoop.mapred.TextInputFormat
 92              output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
 93              serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
 94              name: default.dest1
 95
 96  Stage: Stage-2
 97    Stats-Aggr Operator
 98
 99  Stage: Stage-3
100    Map Reduce
101      Alias -> Map Operator Tree:
102        pfile:/data/users/sdong/www/open-source-hive1/build/ql/scratchdir/hive_2011-02-10_15-55-41_805_4495946797587418312/-ext-10002 
103            File Output Operator
104              compressed: false
105              GlobalTableId: 0
106              table:
107                  input format: org.apache.hadoop.mapred.TextInputFormat
108                  output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
109                  serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
110                  name: default.dest1
111
112
113PREHOOK: query: FROM (
114  FROM src
115  SELECT TRANSFORM(src.key, src.value) ROW FORMAT DELIMITED FIELDS TERMINATED BY '\002'
116  USING '/bin/cat'
117  AS (tkey, tvalue) ROW FORMAT DELIMITED FIELDS TERMINATED BY '\002'
118) tmap
119INSERT OVERWRITE TABLE dest1 SELECT tkey, tvalue
120PREHOOK: type: QUERY
121PREHOOK: Input: default@src
122PREHOOK: Output: default@dest1
123POSTHOOK: query: FROM (
124  FROM src
125  SELECT TRANSFORM(src.key, src.value) ROW FORMAT DELIMITED FIELDS TERMINATED BY '\002'
126  USING '/bin/cat'
127  AS (tkey, tvalue) ROW FORMAT DELIMITED FIELDS TERMINATED BY '\002'
128) tmap
129INSERT OVERWRITE TABLE dest1 SELECT tkey, tvalue
130POSTHOOK: type: QUERY
131POSTHOOK: Input: default@src
132POSTHOOK: Output: default@dest1
133POSTHOOK: Lineage: dest1.key SCRIPT [(src)src.FieldSchema(name:key, type:string, comment:default), (src)src.FieldSchema(name:value, type:string, comment:default), ]
134POSTHOOK: Lineage: dest1.value SCRIPT [(src)src.FieldSchema(name:key, type:string, comment:default), (src)src.FieldSchema(name:value, type:string, comment:default), ]
135PREHOOK: query: SELECT dest1.* FROM dest1
136PREHOOK: type: QUERY
137PREHOOK: Input: default@dest1
138PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_15-55-46_560_5120229936470328869/-mr-10000
139POSTHOOK: query: SELECT dest1.* FROM dest1
140POSTHOOK: type: QUERY
141POSTHOOK: Input: default@dest1
142POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_15-55-46_560_5120229936470328869/-mr-10000
143POSTHOOK: Lineage: dest1.key 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), ]
145238	val_238
14686	val_86
147311	val_311
14827	val_27
149165	val_165
150409	val_409
151255	val_255
152278	val_278
15398	val_98
154484	val_484
155265	val_265
156193	val_193
157401	val_401
158150	val_150
159273	val_273
160224	val_224
161369	val_369
16266	val_66
163128	val_128
164213	val_213
165146	val_146
166406	val_406
167429	val_429
168374	val_374
169152	val_152
170469	val_469
171145	val_145
172495	val_495
17337	val_37
174327	val_327
175281	val_281
176277	val_277
177209	val_209
17815	val_15
17982	val_82
180403	val_403
181166	val_166
182417	val_417
183430	val_430
184252	val_252
185292	val_292
186219	val_219
187287	val_287
188153	val_153
189193	val_193
190338	val_338
191446	val_446
192459	val_459
193394	val_394
194237	val_237
195482	val_482
196174	val_174
197413	val_413
198494	val_494
199207	val_207
200199	val_199
201466	val_466
202208	val_208
203174	val_174
204399	val_399
205396	val_396
206247	val_247
207417	val_417
208489	val_489
209162	val_162
210377	val_377
211397	val_397
212309	val_309
213365	val_365
214266	val_266
215439	val_439
216342	val_342
217367	val_367
218325	val_325
219167	val_167
220195	val_195
221475	val_475
22217	val_17
223113	val_113
224155	val_155
225203	val_203
226339	val_339
2270	val_0
228455	val_455
229128	val_128
230311	val_311
231316	val_316
23257	val_57
233302	val_302
234205	val_205
235149	val_149
236438	val_438
237345	val_345
238129	val_129
239170	val_170
24020	val_20
241489	val_489
242157	val_157
243378	val_378
244221	val_221
24592	val_92
246111	val_111
24747	val_47
24872	val_72
2494	val_4
250280	val_280
25135	val_35
252427	val_427
253277	val_277
254208	val_208
255356	val_356
256399	val_399
257169	val_169
258382	val_382
259498	val_498
260125	val_125
261386	val_386
262437	val_437
263469	val_469
264192	val_192
265286	val_286
266187	val_187
267176	val_176
26854	val_54
269459	val_459
27051	val_51
271138	val_138
272103	val_103
273239	val_239
274213	val_213
275216	val_216
276430	val_430
277278	val_278
278176	val_176
279289	val_289
280221	val_221
28165	val_65
282318	val_318
283332	val_332
284311	val_311
285275	val_275
286137	val_137
287241	val_241
28883	val_83
289333	val_333
290180	val_180
291284	val_284
29212	val_12
293230	val_230
294181	val_181
29567	val_67
296260	val_260
297404	val_404
298384	val_384
299489	val_489
300353	val_353
301373	val_373
302272	val_272
303138	val_138
304217	val_217
30584	val_84
306348	val_348
307466	val_466
30858	val_58
3098	val_8
310411	val_411
311230	val_230
312208	val_208
313348	val_348
31424	val_24
315463	val_463
316431	val_431
317179	val_179
318172	val_172
31942	val_42
320129	val_129
321158	val_158
322119	val_119
323496	val_496
3240	val_0
325322	val_322
326197	val_197
327468	val_468
328393	val_393
329454	val_454
330100	val_100
331298	val_298
332199	val_199
333191	val_191
334418	val_418
33596	val_96
33626	val_26
337165	val_165
338327	val_327
339230	val_230
340205	val_205
341120	val_120
342131	val_131
34351	val_51
344404	val_404
34543	val_43
346436	val_436
347156	val_156
348469	val_469
349468	val_468
350308	val_308
35195	val_95
352196	val_196
353288	val_288
354481	val_481
355457	val_457
35698	val_98
357282	val_282
358197	val_197
359187	val_187
360318	val_318
361318	val_318
362409	val_409
363470	val_470
364137	val_137
365369	val_369
366316	val_316
367169	val_169
368413	val_413
36985	val_85
37077	val_77
3710	val_0
372490	val_490
37387	val_87
374364	val_364
375179	val_179
376118	val_118
377134	val_134
378395	val_395
379282	val_282
380138	val_138
381238	val_238
382419	val_419
38315	val_15
384118	val_118
38572	val_72
38690	val_90
387307	val_307
38819	val_19
389435	val_435
39010	val_10
391277	val_277
392273	val_273
393306	val_306
394224	val_224
395309	val_309
396389	val_389
397327	val_327
398242	val_242
399369	val_369
400392	val_392
401272	val_272
402331	val_331
403401	val_401
404242	val_242
405452	val_452
406177	val_177
407226	val_226
4085	val_5
409497	val_497
410402	val_402
411396	val_396
412317	val_317
413395	val_395
41458	val_58
41535	val_35
416336	val_336
41795	val_95
41811	val_11
419168	val_168
42034	val_34
421229	val_229
422233	val_233
423143	val_143
424472	val_472
425322	val_322
426498	val_498
427160	val_160
428195	val_195
42942	val_42
430321	val_321
431430	val_430
432119	val_119
433489	val_489
434458	val_458
43578	val_78
43676	val_76
43741	val_41
438223	val_223
439492	val_492
440149	val_149
441449	val_449
442218	val_218
443228	val_228
444138	val_138
445453	val_453
44630	val_30
447209	val_209
44864	val_64
449468	val_468
45076	val_76
45174	val_74
452342	val_342
45369	val_69
454230	val_230
45533	val_33
456368	val_368
457103	val_103
458296	val_296
459113	val_113
460216	val_216
461367	val_367
462344	val_344
463167	val_167
464274	val_274
465219	val_219
466239	val_239
467485	val_485
468116	val_116
469223	val_223
470256	val_256
471263	val_263
47270	val_70
473487	val_487
474480	val_480
475401	val_401
476288	val_288
477191	val_191
4785	val_5
479244	val_244
480438	val_438
481128	val_128
482467	val_467
483432	val_432
484202	val_202
485316	val_316
486229	val_229
487469	val_469
488463	val_463
489280	val_280
4902	val_2
49135	val_35
492283	val_283
493331	val_331
494235	val_235
49580	val_80
49644	val_44
497193	val_193
498321	val_321
499335	val_335
500104	val_104
501466	val_466
502366	val_366
503175	val_175
504403	val_403
505483	val_483
50653	val_53
507105	val_105
508257	val_257
509406	val_406
510409	val_409
511190	val_190
512406	val_406
513401	val_401
514114	val_114
515258	val_258
51690	val_90
517203	val_203
518262	val_262
519348	val_348
520424	val_424
52112	val_12
522396	val_396
523201	val_201
524217	val_217
525164	val_164
526431	val_431
527454	val_454
528478	val_478
529298	val_298
530125	val_125
531431	val_431
532164	val_164
533424	val_424
534187	val_187
535382	val_382
5365	val_5
53770	val_70
538397	val_397
539480	val_480
540291	val_291
54124	val_24
542351	val_351
543255	val_255
544104	val_104
54570	val_70
546163	val_163
547438	val_438
548119	val_119
549414	val_414
550200	val_200
551491	val_491
552237	val_237
553439	val_439
554360	val_360
555248	val_248
556479	val_479
557305	val_305
558417	val_417
559199	val_199
560444	val_444
561120	val_120
562429	val_429
563169	val_169
564443	val_443
565323	val_323
566325	val_325
567277	val_277
568230	val_230
569478	val_478
570178	val_178
571468	val_468
572310	val_310
573317	val_317
574333	val_333
575493	val_493
576460	val_460
577207	val_207
578249	val_249
579265	val_265
580480	val_480
58183	val_83
582136	val_136
583353	val_353
584172	val_172
585214	val_214
586462	val_462
587233	val_233
588406	val_406
589133	val_133
590175	val_175
591189	val_189
592454	val_454
593375	val_375
594401	val_401
595421	val_421
596407	val_407
597384	val_384
598256	val_256
59926	val_26
600134	val_134
60167	val_67
602384	val_384
603379	val_379
60418	val_18
605462	val_462
606492	val_492
607100	val_100
608298	val_298
6099	val_9
610341	val_341
611498	val_498
612146	val_146
613458	val_458
614362	val_362
615186	val_186
616285	val_285
617348	val_348
618167	val_167
61918	val_18
620273	val_273
621183	val_183
622281	val_281
623344	val_344
62497	val_97
625469	val_469
626315	val_315
62784	val_84
62828	val_28
62937	val_37
630448	val_448
631152	val_152
632348	val_348
633307	val_307
634194	val_194
635414	val_414
636477	val_477
637222	val_222
638126	val_126
63990	val_90
640169	val_169
641403	val_403
642400	val_400
643200	val_200
64497	val_97