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

/tags/release-0.2.0-rc0/hive/external/contrib/src/test/results/clientpositive/serde_typedbytes2.q.out

#
text | 659 lines | 650 code | 9 blank | 0 comment | 0 complexity | 34a2f26d46505749be6616828cd7cb31 MD5 | raw file
  1PREHOOK: query: drop table dest1
  2PREHOOK: type: DROPTABLE
  3POSTHOOK: query: drop table dest1
  4POSTHOOK: type: DROPTABLE
  5PREHOOK: query: CREATE TABLE dest1(key SMALLINT, value STRING) STORED AS TEXTFILE
  6PREHOOK: type: CREATETABLE
  7POSTHOOK: query: CREATE TABLE dest1(key SMALLINT, value STRING) STORED AS TEXTFILE
  8POSTHOOK: type: CREATETABLE
  9POSTHOOK: Output: default@dest1
 10PREHOOK: query: EXPLAIN
 11FROM (
 12  FROM src
 13  SELECT TRANSFORM(cast(src.key as smallint), src.value) ROW FORMAT SERDE 'org.apache.hadoop.hive.contrib.serde2.TypedBytesSerDe'
 14  RECORDWRITER 'org.apache.hadoop.hive.contrib.util.typedbytes.TypedBytesRecordWriter'
 15  USING '/bin/cat'
 16  AS (tkey smallint, tvalue string) ROW FORMAT SERDE 'org.apache.hadoop.hive.contrib.serde2.TypedBytesSerDe'
 17  RECORDREADER 'org.apache.hadoop.hive.contrib.util.typedbytes.TypedBytesRecordReader'
 18) tmap
 19INSERT OVERWRITE TABLE dest1 SELECT tkey, tvalue
 20PREHOOK: type: QUERY
 21POSTHOOK: query: EXPLAIN
 22FROM (
 23  FROM src
 24  SELECT TRANSFORM(cast(src.key as smallint), src.value) ROW FORMAT SERDE 'org.apache.hadoop.hive.contrib.serde2.TypedBytesSerDe'
 25  RECORDWRITER 'org.apache.hadoop.hive.contrib.util.typedbytes.TypedBytesRecordWriter'
 26  USING '/bin/cat'
 27  AS (tkey smallint, tvalue string) ROW FORMAT SERDE 'org.apache.hadoop.hive.contrib.serde2.TypedBytesSerDe'
 28  RECORDREADER 'org.apache.hadoop.hive.contrib.util.typedbytes.TypedBytesRecordReader'
 29) tmap
 30INSERT OVERWRITE TABLE dest1 SELECT tkey, tvalue
 31POSTHOOK: type: QUERY
 32ABSTRACT SYNTAX TREE:
 33  (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_FUNCTION TOK_SMALLINT (. (TOK_TABLE_OR_COL src) key)) (. (TOK_TABLE_OR_COL src) value)) (TOK_SERDE (TOK_SERDENAME 'org.apache.hadoop.hive.contrib.serde2.TypedBytesSerDe')) (TOK_RECORDWRITER 'org.apache.hadoop.hive.contrib.util.typedbytes.TypedBytesRecordWriter') '/bin/cat' (TOK_SERDE (TOK_SERDENAME 'org.apache.hadoop.hive.contrib.serde2.TypedBytesSerDe')) (TOK_RECORDREADER 'org.apache.hadoop.hive.contrib.util.typedbytes.TypedBytesRecordReader') (TOK_TABCOLLIST (TOK_TABCOL tkey TOK_SMALLINT) (TOK_TABCOL tvalue TOK_STRING))))))) 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)))))
 34
 35STAGE DEPENDENCIES:
 36  Stage-1 is a root stage
 37  Stage-5 depends on stages: Stage-1 , consists of Stage-4, Stage-3
 38  Stage-4
 39  Stage-0 depends on stages: Stage-4, Stage-3
 40  Stage-2 depends on stages: Stage-0
 41  Stage-3
 42
 43STAGE PLANS:
 44  Stage: Stage-1
 45    Map Reduce
 46      Alias -> Map Operator Tree:
 47        tmap:src 
 48          TableScan
 49            alias: src
 50            Select Operator
 51              expressions:
 52                    expr: UDFToShort(key)
 53                    type: smallint
 54                    expr: value
 55                    type: string
 56              outputColumnNames: _col0, _col1
 57              Transform Operator
 58                command: /bin/cat
 59                output info:
 60                    input format: org.apache.hadoop.mapred.TextInputFormat
 61                    output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
 62                Select Operator
 63                  expressions:
 64                        expr: _col0
 65                        type: smallint
 66                        expr: _col1
 67                        type: string
 68                  outputColumnNames: _col0, _col1
 69                  File Output Operator
 70                    compressed: false
 71                    GlobalTableId: 1
 72                    table:
 73                        input format: org.apache.hadoop.mapred.TextInputFormat
 74                        output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
 75                        serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
 76                        name: default.dest1
 77
 78  Stage: Stage-5
 79    Conditional Operator
 80
 81  Stage: Stage-4
 82    Move Operator
 83      files:
 84          hdfs directory: true
 85          destination: pfile:/data/users/sdong/www/open-source-hive3/build/contrib/scratchdir/hive_2011-02-16_20-10-03_968_615132022372343485/-ext-10000
 86
 87  Stage: Stage-0
 88    Move Operator
 89      tables:
 90          replace: true
 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-2
 98    Stats-Aggr Operator
 99
100  Stage: Stage-3
101    Map Reduce
102      Alias -> Map Operator Tree:
103        pfile:/data/users/sdong/www/open-source-hive3/build/contrib/scratchdir/hive_2011-02-16_20-10-03_968_615132022372343485/-ext-10002 
104            File Output Operator
105              compressed: false
106              GlobalTableId: 0
107              table:
108                  input format: org.apache.hadoop.mapred.TextInputFormat
109                  output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
110                  serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
111                  name: default.dest1
112
113
114PREHOOK: query: FROM (
115  FROM src
116  SELECT TRANSFORM(cast(src.key as smallint), src.value) ROW FORMAT SERDE 'org.apache.hadoop.hive.contrib.serde2.TypedBytesSerDe'
117  RECORDWRITER 'org.apache.hadoop.hive.contrib.util.typedbytes.TypedBytesRecordWriter'
118  USING '/bin/cat'
119  AS (tkey smallint, tvalue string) ROW FORMAT SERDE 'org.apache.hadoop.hive.contrib.serde2.TypedBytesSerDe'
120  RECORDREADER 'org.apache.hadoop.hive.contrib.util.typedbytes.TypedBytesRecordReader'
121) tmap
122INSERT OVERWRITE TABLE dest1 SELECT tkey, tvalue
123PREHOOK: type: QUERY
124PREHOOK: Input: default@src
125PREHOOK: Output: default@dest1
126POSTHOOK: query: FROM (
127  FROM src
128  SELECT TRANSFORM(cast(src.key as smallint), src.value) ROW FORMAT SERDE 'org.apache.hadoop.hive.contrib.serde2.TypedBytesSerDe'
129  RECORDWRITER 'org.apache.hadoop.hive.contrib.util.typedbytes.TypedBytesRecordWriter'
130  USING '/bin/cat'
131  AS (tkey smallint, tvalue string) ROW FORMAT SERDE 'org.apache.hadoop.hive.contrib.serde2.TypedBytesSerDe'
132  RECORDREADER 'org.apache.hadoop.hive.contrib.util.typedbytes.TypedBytesRecordReader'
133) tmap
134INSERT OVERWRITE TABLE dest1 SELECT tkey, tvalue
135POSTHOOK: type: QUERY
136POSTHOOK: Input: default@src
137POSTHOOK: Output: default@dest1
138POSTHOOK: Lineage: dest1.key SCRIPT [(src)src.FieldSchema(name:key, type:string, comment:default), (src)src.FieldSchema(name:value, type:string, comment:default), ]
139POSTHOOK: Lineage: dest1.value SCRIPT [(src)src.FieldSchema(name:key, type:string, comment:default), (src)src.FieldSchema(name:value, type:string, comment:default), ]
140PREHOOK: query: SELECT dest1.* FROM dest1
141PREHOOK: type: QUERY
142PREHOOK: Input: default@dest1
143PREHOOK: Output: file:/tmp/sdong/hive_2011-02-16_20-10-08_600_4521724841834838529/-mr-10000
144POSTHOOK: query: SELECT dest1.* FROM dest1
145POSTHOOK: type: QUERY
146POSTHOOK: Input: default@dest1
147POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-16_20-10-08_600_4521724841834838529/-mr-10000
148POSTHOOK: Lineage: dest1.key SCRIPT [(src)src.FieldSchema(name:key, type:string, comment:default), (src)src.FieldSchema(name:value, type:string, comment:default), ]
149POSTHOOK: Lineage: dest1.value SCRIPT [(src)src.FieldSchema(name:key, type:string, comment:default), (src)src.FieldSchema(name:value, type:string, comment:default), ]
150238	val_238
15186	val_86
152311	val_311
15327	val_27
154165	val_165
155409	val_409
156255	val_255
157278	val_278
15898	val_98
159484	val_484
160265	val_265
161193	val_193
162401	val_401
163150	val_150
164273	val_273
165224	val_224
166369	val_369
16766	val_66
168128	val_128
169213	val_213
170146	val_146
171406	val_406
172429	val_429
173374	val_374
174152	val_152
175469	val_469
176145	val_145
177495	val_495
17837	val_37
179327	val_327
180281	val_281
181277	val_277
182209	val_209
18315	val_15
18482	val_82
185403	val_403
186166	val_166
187417	val_417
188430	val_430
189252	val_252
190292	val_292
191219	val_219
192287	val_287
193153	val_153
194193	val_193
195338	val_338
196446	val_446
197459	val_459
198394	val_394
199237	val_237
200482	val_482
201174	val_174
202413	val_413
203494	val_494
204207	val_207
205199	val_199
206466	val_466
207208	val_208
208174	val_174
209399	val_399
210396	val_396
211247	val_247
212417	val_417
213489	val_489
214162	val_162
215377	val_377
216397	val_397
217309	val_309
218365	val_365
219266	val_266
220439	val_439
221342	val_342
222367	val_367
223325	val_325
224167	val_167
225195	val_195
226475	val_475
22717	val_17
228113	val_113
229155	val_155
230203	val_203
231339	val_339
2320	val_0
233455	val_455
234128	val_128
235311	val_311
236316	val_316
23757	val_57
238302	val_302
239205	val_205
240149	val_149
241438	val_438
242345	val_345
243129	val_129
244170	val_170
24520	val_20
246489	val_489
247157	val_157
248378	val_378
249221	val_221
25092	val_92
251111	val_111
25247	val_47
25372	val_72
2544	val_4
255280	val_280
25635	val_35
257427	val_427
258277	val_277
259208	val_208
260356	val_356
261399	val_399
262169	val_169
263382	val_382
264498	val_498
265125	val_125
266386	val_386
267437	val_437
268469	val_469
269192	val_192
270286	val_286
271187	val_187
272176	val_176
27354	val_54
274459	val_459
27551	val_51
276138	val_138
277103	val_103
278239	val_239
279213	val_213
280216	val_216
281430	val_430
282278	val_278
283176	val_176
284289	val_289
285221	val_221
28665	val_65
287318	val_318
288332	val_332
289311	val_311
290275	val_275
291137	val_137
292241	val_241
29383	val_83
294333	val_333
295180	val_180
296284	val_284
29712	val_12
298230	val_230
299181	val_181
30067	val_67
301260	val_260
302404	val_404
303384	val_384
304489	val_489
305353	val_353
306373	val_373
307272	val_272
308138	val_138
309217	val_217
31084	val_84
311348	val_348
312466	val_466
31358	val_58
3148	val_8
315411	val_411
316230	val_230
317208	val_208
318348	val_348
31924	val_24
320463	val_463
321431	val_431
322179	val_179
323172	val_172
32442	val_42
325129	val_129
326158	val_158
327119	val_119
328496	val_496
3290	val_0
330322	val_322
331197	val_197
332468	val_468
333393	val_393
334454	val_454
335100	val_100
336298	val_298
337199	val_199
338191	val_191
339418	val_418
34096	val_96
34126	val_26
342165	val_165
343327	val_327
344230	val_230
345205	val_205
346120	val_120
347131	val_131
34851	val_51
349404	val_404
35043	val_43
351436	val_436
352156	val_156
353469	val_469
354468	val_468
355308	val_308
35695	val_95
357196	val_196
358288	val_288
359481	val_481
360457	val_457
36198	val_98
362282	val_282
363197	val_197
364187	val_187
365318	val_318
366318	val_318
367409	val_409
368470	val_470
369137	val_137
370369	val_369
371316	val_316
372169	val_169
373413	val_413
37485	val_85
37577	val_77
3760	val_0
377490	val_490
37887	val_87
379364	val_364
380179	val_179
381118	val_118
382134	val_134
383395	val_395
384282	val_282
385138	val_138
386238	val_238
387419	val_419
38815	val_15
389118	val_118
39072	val_72
39190	val_90
392307	val_307
39319	val_19
394435	val_435
39510	val_10
396277	val_277
397273	val_273
398306	val_306
399224	val_224
400309	val_309
401389	val_389
402327	val_327
403242	val_242
404369	val_369
405392	val_392
406272	val_272
407331	val_331
408401	val_401
409242	val_242
410452	val_452
411177	val_177
412226	val_226
4135	val_5
414497	val_497
415402	val_402
416396	val_396
417317	val_317
418395	val_395
41958	val_58
42035	val_35
421336	val_336
42295	val_95
42311	val_11
424168	val_168
42534	val_34
426229	val_229
427233	val_233
428143	val_143
429472	val_472
430322	val_322
431498	val_498
432160	val_160
433195	val_195
43442	val_42
435321	val_321
436430	val_430
437119	val_119
438489	val_489
439458	val_458
44078	val_78
44176	val_76
44241	val_41
443223	val_223
444492	val_492
445149	val_149
446449	val_449
447218	val_218
448228	val_228
449138	val_138
450453	val_453
45130	val_30
452209	val_209
45364	val_64
454468	val_468
45576	val_76
45674	val_74
457342	val_342
45869	val_69
459230	val_230
46033	val_33
461368	val_368
462103	val_103
463296	val_296
464113	val_113
465216	val_216
466367	val_367
467344	val_344
468167	val_167
469274	val_274
470219	val_219
471239	val_239
472485	val_485
473116	val_116
474223	val_223
475256	val_256
476263	val_263
47770	val_70
478487	val_487
479480	val_480
480401	val_401
481288	val_288
482191	val_191
4835	val_5
484244	val_244
485438	val_438
486128	val_128
487467	val_467
488432	val_432
489202	val_202
490316	val_316
491229	val_229
492469	val_469
493463	val_463
494280	val_280
4952	val_2
49635	val_35
497283	val_283
498331	val_331
499235	val_235
50080	val_80
50144	val_44
502193	val_193
503321	val_321
504335	val_335
505104	val_104
506466	val_466
507366	val_366
508175	val_175
509403	val_403
510483	val_483
51153	val_53
512105	val_105
513257	val_257
514406	val_406
515409	val_409
516190	val_190
517406	val_406
518401	val_401
519114	val_114
520258	val_258
52190	val_90
522203	val_203
523262	val_262
524348	val_348
525424	val_424
52612	val_12
527396	val_396
528201	val_201
529217	val_217
530164	val_164
531431	val_431
532454	val_454
533478	val_478
534298	val_298
535125	val_125
536431	val_431
537164	val_164
538424	val_424
539187	val_187
540382	val_382
5415	val_5
54270	val_70
543397	val_397
544480	val_480
545291	val_291
54624	val_24
547351	val_351
548255	val_255
549104	val_104
55070	val_70
551163	val_163
552438	val_438
553119	val_119
554414	val_414
555200	val_200
556491	val_491
557237	val_237
558439	val_439
559360	val_360
560248	val_248
561479	val_479
562305	val_305
563417	val_417
564199	val_199
565444	val_444
566120	val_120
567429	val_429
568169	val_169
569443	val_443
570323	val_323
571325	val_325
572277	val_277
573230	val_230
574478	val_478
575178	val_178
576468	val_468
577310	val_310
578317	val_317
579333	val_333
580493	val_493
581460	val_460
582207	val_207
583249	val_249
584265	val_265
585480	val_480
58683	val_83
587136	val_136
588353	val_353
589172	val_172
590214	val_214
591462	val_462
592233	val_233
593406	val_406
594133	val_133
595175	val_175
596189	val_189
597454	val_454
598375	val_375
599401	val_401
600421	val_421
601407	val_407
602384	val_384
603256	val_256
60426	val_26
605134	val_134
60667	val_67
607384	val_384
608379	val_379
60918	val_18
610462	val_462
611492	val_492
612100	val_100
613298	val_298
6149	val_9
615341	val_341
616498	val_498
617146	val_146
618458	val_458
619362	val_362
620186	val_186
621285	val_285
622348	val_348
623167	val_167
62418	val_18
625273	val_273
626183	val_183
627281	val_281
628344	val_344
62997	val_97
630469	val_469
631315	val_315
63284	val_84
63328	val_28
63437	val_37
635448	val_448
636152	val_152
637348	val_348
638307	val_307
639194	val_194
640414	val_414
641477	val_477
642222	val_222
643126	val_126
64490	val_90
645169	val_169
646403	val_403
647400	val_400
648200	val_200
64997	val_97
650PREHOOK: query: drop table dest1
651PREHOOK: type: DROPTABLE
652PREHOOK: Input: default@dest1
653PREHOOK: Output: default@dest1
654POSTHOOK: query: drop table dest1
655POSTHOOK: type: DROPTABLE
656POSTHOOK: Input: default@dest1
657POSTHOOK: Output: default@dest1
658POSTHOOK: Lineage: dest1.key SCRIPT [(src)src.FieldSchema(name:key, type:string, comment:default), (src)src.FieldSchema(name:value, type:string, comment:default), ]
659POSTHOOK: Lineage: dest1.value SCRIPT [(src)src.FieldSchema(name:key, type:string, comment:default), (src)src.FieldSchema(name:value, type:string, comment:default), ]