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

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

#
text | 614 lines | 608 code | 6 blank | 0 comment | 0 complexity | ed23a0ff20d53716b9f1f11604620084 MD5 | raw file
  1PREHOOK: query: EXPLAIN EXTENDED
  2SELECT s.*
  3FROM (SELECT a.* FROM srcbucket TABLESAMPLE (BUCKET 1 OUT OF 2 on key) a) s
  4PREHOOK: type: QUERY
  5POSTHOOK: query: EXPLAIN EXTENDED
  6SELECT s.*
  7FROM (SELECT a.* FROM srcbucket TABLESAMPLE (BUCKET 1 OUT OF 2 on key) a) s
  8POSTHOOK: type: QUERY
  9ABSTRACT SYNTAX TREE:
 10  (TOK_QUERY (TOK_FROM (TOK_SUBQUERY (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME srcbucket) (TOK_TABLESAMPLE 1 2 (TOK_TABLE_OR_COL key)) a)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_ALLCOLREF (TOK_TABNAME a)))))) s)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_ALLCOLREF (TOK_TABNAME s))))))
 11
 12STAGE DEPENDENCIES:
 13  Stage-1 is a root stage
 14  Stage-0 is a root stage
 15
 16STAGE PLANS:
 17  Stage: Stage-1
 18    Map Reduce
 19      Alias -> Map Operator Tree:
 20        s:a 
 21          TableScan
 22            alias: a
 23            GatherStats: false
 24            Filter Operator
 25              isSamplingPred: false
 26              predicate:
 27                  expr: (((hash(key) & 2147483647) % 2) = 0)
 28                  type: boolean
 29              Filter Operator
 30                isSamplingPred: true
 31                predicate:
 32                    expr: (((hash(key) & 2147483647) % 2) = 0)
 33                    type: boolean
 34                Select Operator
 35                  expressions:
 36                        expr: key
 37                        type: int
 38                        expr: value
 39                        type: string
 40                  outputColumnNames: _col0, _col1
 41                  Select Operator
 42                    expressions:
 43                          expr: _col0
 44                          type: int
 45                          expr: _col1
 46                          type: string
 47                    outputColumnNames: _col0, _col1
 48                    File Output Operator
 49                      compressed: false
 50                      GlobalTableId: 0
 51                      directory: file:/tmp/sdong/hive_2011-02-10_17-03-59_702_2188871527602970364/-ext-10001
 52                      NumFilesPerFileSink: 1
 53                      Stats Publishing Key Prefix: file:/tmp/sdong/hive_2011-02-10_17-03-59_702_2188871527602970364/-ext-10001/
 54                      table:
 55                          input format: org.apache.hadoop.mapred.TextInputFormat
 56                          output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
 57                          properties:
 58                            columns _col0,_col1
 59                            columns.types int:string
 60                            serialization.format 1
 61                      TotalFiles: 1
 62                      GatherStats: false
 63                      MultiFileSpray: false
 64      Needs Tagging: false
 65      Path -> Alias:
 66        pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/srcbucket/srcbucket0.txt [s:a]
 67      Path -> Partition:
 68        pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/srcbucket/srcbucket0.txt 
 69          Partition
 70            base file name: srcbucket0.txt
 71            input format: org.apache.hadoop.mapred.TextInputFormat
 72            output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
 73            properties:
 74              bucket_count 2
 75              bucket_field_name key
 76              columns key,value
 77              columns.types int:string
 78              file.inputformat org.apache.hadoop.mapred.TextInputFormat
 79              file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
 80              location pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/srcbucket
 81              name default.srcbucket
 82              serialization.ddl struct srcbucket { i32 key, string value}
 83              serialization.format 1
 84              serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
 85              transient_lastDdlTime 1297378966
 86            serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
 87          
 88              input format: org.apache.hadoop.mapred.TextInputFormat
 89              output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
 90              properties:
 91                bucket_count 2
 92                bucket_field_name key
 93                columns key,value
 94                columns.types int:string
 95                file.inputformat org.apache.hadoop.mapred.TextInputFormat
 96                file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
 97                location pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/srcbucket
 98                name default.srcbucket
 99                serialization.ddl struct srcbucket { i32 key, string value}
100                serialization.format 1
101                serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
102                transient_lastDdlTime 1297378966
103              serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
104              name: default.srcbucket
105            name: default.srcbucket
106
107  Stage: Stage-0
108    Fetch Operator
109      limit: -1
110
111
112PREHOOK: query: SELECT s.*
113FROM (SELECT a.* FROM srcbucket TABLESAMPLE (BUCKET 1 OUT OF 2 on key) a) s
114PREHOOK: type: QUERY
115PREHOOK: Input: default@srcbucket
116PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-03-59_885_5868752797870290038/-mr-10000
117POSTHOOK: query: SELECT s.*
118FROM (SELECT a.* FROM srcbucket TABLESAMPLE (BUCKET 1 OUT OF 2 on key) a) s
119POSTHOOK: type: QUERY
120POSTHOOK: Input: default@srcbucket
121POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-03-59_885_5868752797870290038/-mr-10000
122474	val_475
12362	val_63
124468	val_469
125272	val_273
126448	val_449
127246	val_247
128440	val_441
129278	val_279
130296	val_297
131428	val_429
132126	val_127
133106	val_107
134356	val_357
135490	val_491
136402	val_403
137128	val_129
13810	val_11
139226	val_227
140110	val_111
1410	val_1
142240	val_241
143286	val_287
144408	val_409
145476	val_477
146482	val_483
14748	val_49
148424	val_425
149226	val_227
150494	val_495
151488	val_489
15294	val_95
15350	val_51
154402	val_403
155128	val_129
156468	val_469
157314	val_315
158224	val_225
159344	val_345
1604	val_5
161206	val_207
162114	val_115
16356	val_57
164114	val_115
165254	val_255
166390	val_391
167304	val_305
168264	val_265
169196	val_197
170238	val_239
17120	val_21
172492	val_493
17382	val_83
17458	val_59
17586	val_87
176438	val_439
177360	val_361
178222	val_223
17942	val_43
180338	val_339
18168	val_69
18216	val_17
183492	val_493
184376	val_377
185120	val_121
186306	val_307
187426	val_427
188132	val_133
189446	val_447
190386	val_387
191388	val_389
192184	val_185
193284	val_285
194246	val_247
195262	val_263
196122	val_123
197438	val_439
198390	val_391
199352	val_353
200226	val_227
201328	val_329
202382	val_383
203342	val_343
204480	val_481
205102	val_103
206480	val_481
207318	val_319
208392	val_393
209476	val_477
210258	val_259
211174	val_175
212252	val_253
213114	val_115
214264	val_265
21548	val_49
216336	val_337
217340	val_341
218390	val_391
219484	val_485
2206	val_7
221260	val_261
2222	val_3
223170	val_171
224164	val_165
225118	val_119
226310	val_311
227104	val_105
22880	val_81
229326	val_327
230450	val_451
231140	val_141
232212	val_213
233308	val_309
23430	val_31
235358	val_359
236416	val_417
23742	val_43
238386	val_387
239454	val_455
240364	val_365
24120	val_21
24252	val_53
24340	val_41
2448	val_9
245168	val_169
246384	val_385
247324	val_325
248310	val_311
249206	val_207
250404	val_405
251206	val_207
252226	val_227
253262	val_263
254260	val_261
255328	val_329
256322	val_323
257122	val_123
258404	val_405
259384	val_385
26076	val_77
261116	val_117
26242	val_43
263104	val_105
264406	val_407
26532	val_33
266132	val_133
267192	val_193
26858	val_59
26970	val_71
270356	val_357
271352	val_353
27252	val_53
273330	val_331
274138	val_139
275160	val_161
276454	val_455
27776	val_77
278174	val_175
279412	val_413
28016	val_17
281204	val_205
282126	val_127
283274	val_275
284374	val_375
285494	val_495
286216	val_217
287470	val_471
288196	val_197
289302	val_303
290450	val_451
29112	val_13
292398	val_399
293334	val_335
294384	val_385
29560	val_61
296442	val_443
29752	val_53
298404	val_405
299446	val_447
300300	val_301
3010	val_1
302268	val_269
303392	val_393
304104	val_105
305436	val_437
306156	val_157
307118	val_119
308172	val_173
309244	val_245
3106	val_7
311284	val_285
312164	val_165
313136	val_137
314462	val_463
315432	val_433
316496	val_497
317144	val_145
318408	val_409
319152	val_153
320382	val_383
321348	val_349
322122	val_123
323292	val_293
324182	val_183
325474	val_475
326310	val_311
32752	val_53
328486	val_487
329152	val_153
330378	val_379
331414	val_415
332256	val_257
333292	val_293
334412	val_413
33540	val_41
336478	val_479
337178	val_179
338100	val_101
339156	val_157
340228	val_229
34122	val_23
342248	val_249
343402	val_403
34462	val_63
345162	val_163
346244	val_245
347276	val_277
34846	val_47
34978	val_79
350134	val_135
351196	val_197
352410	val_411
35382	val_83
354440	val_441
355100	val_101
356308	val_309
357430	val_431
358468	val_469
359152	val_153
360138	val_139
36176	val_77
362300	val_301
363478	val_479
364118	val_119
365178	val_179
366242	val_243
367244	val_245
368238	val_238
36986	val_86
370278	val_278
37198	val_98
372484	val_484
373150	val_150
374224	val_224
37566	val_66
376128	val_128
377146	val_146
378406	val_406
379374	val_374
380152	val_152
38182	val_82
382166	val_166
383430	val_430
384252	val_252
385292	val_292
386338	val_338
387446	val_446
388394	val_394
389482	val_482
390174	val_174
391494	val_494
392466	val_466
393208	val_208
394174	val_174
395396	val_396
396162	val_162
397266	val_266
398342	val_342
3990	val_0
400128	val_128
401316	val_316
402302	val_302
403438	val_438
404170	val_170
40520	val_20
406378	val_378
40792	val_92
40872	val_72
4094	val_4
410280	val_280
411208	val_208
412356	val_356
413382	val_382
414498	val_498
415386	val_386
416192	val_192
417286	val_286
418176	val_176
41954	val_54
420138	val_138
421216	val_216
422430	val_430
423278	val_278
424176	val_176
425318	val_318
426332	val_332
427180	val_180
428284	val_284
42912	val_12
430230	val_230
431260	val_260
432404	val_404
433384	val_384
434272	val_272
435138	val_138
43684	val_84
437348	val_348
438466	val_466
43958	val_58
4408	val_8
441230	val_230
442208	val_208
443348	val_348
44424	val_24
445172	val_172
44642	val_42
447158	val_158
448496	val_496
4490	val_0
450322	val_322
451468	val_468
452454	val_454
453100	val_100
454298	val_298
455418	val_418
45696	val_96
45726	val_26
458230	val_230
459120	val_120
460404	val_404
461436	val_436
462156	val_156
463468	val_468
464308	val_308
465196	val_196
466288	val_288
46798	val_98
468282	val_282
469318	val_318
470318	val_318
471470	val_470
472316	val_316
4730	val_0
474490	val_490
475364	val_364
476118	val_118
477134	val_134
478282	val_282
479138	val_138
480238	val_238
481118	val_118
48272	val_72
48390	val_90
48410	val_10
485306	val_306
486224	val_224
487242	val_242
488392	val_392
489272	val_272
490242	val_242
491452	val_452
492226	val_226
493402	val_402
494396	val_396
49558	val_58
496336	val_336
497168	val_168
49834	val_34
499472	val_472
500322	val_322
501498	val_498
502160	val_160
50342	val_42
504430	val_430
505458	val_458
50678	val_78
50776	val_76
508492	val_492
509218	val_218
510228	val_228
511138	val_138
51230	val_30
51364	val_64
514468	val_468
51576	val_76
51674	val_74
517342	val_342
518230	val_230
519368	val_368
520296	val_296
521216	val_216
522344	val_344
523274	val_274
524116	val_116
525256	val_256
52670	val_70
527480	val_480
528288	val_288
529244	val_244
530438	val_438
531128	val_128
532432	val_432
533202	val_202
534316	val_316
535280	val_280
5362	val_2
53780	val_80
53844	val_44
539104	val_104
540466	val_466
541366	val_366
542406	val_406
543190	val_190
544406	val_406
545114	val_114
546258	val_258
54790	val_90
548262	val_262
549348	val_348
550424	val_424
55112	val_12
552396	val_396
553164	val_164
554454	val_454
555478	val_478
556298	val_298
557164	val_164
558424	val_424
559382	val_382
56070	val_70
561480	val_480
56224	val_24
563104	val_104
56470	val_70
565438	val_438
566414	val_414
567200	val_200
568360	val_360
569248	val_248
570444	val_444
571120	val_120
572230	val_230
573478	val_478
574178	val_178
575468	val_468
576310	val_310
577460	val_460
578480	val_480
579136	val_136
580172	val_172
581214	val_214
582462	val_462
583406	val_406
584454	val_454
585384	val_384
586256	val_256
58726	val_26
588134	val_134
589384	val_384
59018	val_18
591462	val_462
592492	val_492
593100	val_100
594298	val_298
595498	val_498
596146	val_146
597458	val_458
598362	val_362
599186	val_186
600348	val_348
60118	val_18
602344	val_344
60384	val_84
60428	val_28
605448	val_448
606152	val_152
607348	val_348
608194	val_194
609414	val_414
610222	val_222
611126	val_126
61290	val_90
613400	val_400
614200	val_200