PageRenderTime 30ms CodeModel.GetById 16ms app.highlight 7ms RepoModel.GetById 1ms app.codeStats 1ms

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

#
text | 434 lines | 429 code | 5 blank | 0 comment | 0 complexity | 618d8aee68b1f693abd8deaa67a145a7 MD5 | raw file
  1PREHOOK: query: EXPLAIN
  2SELECT src.key as c3 from src where src.key > '2'
  3PREHOOK: type: QUERY
  4POSTHOOK: query: EXPLAIN
  5SELECT src.key as c3 from src where src.key > '2'
  6POSTHOOK: type: QUERY
  7ABSTRACT SYNTAX TREE:
  8  (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME src))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (. (TOK_TABLE_OR_COL src) key) c3)) (TOK_WHERE (> (. (TOK_TABLE_OR_COL src) key) '2'))))
  9
 10STAGE DEPENDENCIES:
 11  Stage-1 is a root stage
 12  Stage-0 is a root stage
 13
 14STAGE PLANS:
 15  Stage: Stage-1
 16    Map Reduce
 17      Alias -> Map Operator Tree:
 18        src 
 19          TableScan
 20            alias: src
 21            Filter Operator
 22              predicate:
 23                  expr: (key > '2')
 24                  type: boolean
 25              Filter Operator
 26                predicate:
 27                    expr: (key > '2')
 28                    type: boolean
 29                Select Operator
 30                  expressions:
 31                        expr: key
 32                        type: string
 33                  outputColumnNames: _col0
 34                  File Output Operator
 35                    compressed: false
 36                    GlobalTableId: 0
 37                    table:
 38                        input format: org.apache.hadoop.mapred.TextInputFormat
 39                        output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
 40
 41  Stage: Stage-0
 42    Fetch Operator
 43      limit: -1
 44
 45
 46PREHOOK: query: SELECT src.key as c3 from src where src.key > '2'
 47PREHOOK: type: QUERY
 48PREHOOK: Input: default@src
 49PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_16-56-18_823_4035711180151393629/-mr-10000
 50POSTHOOK: query: SELECT src.key as c3 from src where src.key > '2'
 51POSTHOOK: type: QUERY
 52POSTHOOK: Input: default@src
 53POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_16-56-18_823_4035711180151393629/-mr-10000
 54238
 5586
 56311
 5727
 58409
 59255
 60278
 6198
 62484
 63265
 64401
 65273
 66224
 67369
 6866
 69213
 70406
 71429
 72374
 73469
 74495
 7537
 76327
 77281
 78277
 79209
 8082
 81403
 82417
 83430
 84252
 85292
 86219
 87287
 88338
 89446
 90459
 91394
 92237
 93482
 94413
 95494
 96207
 97466
 98208
 99399
100396
101247
102417
103489
104377
105397
106309
107365
108266
109439
110342
111367
112325
113475
114203
115339
116455
117311
118316
11957
120302
121205
122438
123345
12420
125489
126378
127221
12892
12947
13072
1314
132280
13335
134427
135277
136208
137356
138399
139382
140498
141386
142437
143469
144286
14554
146459
14751
148239
149213
150216
151430
152278
153289
154221
15565
156318
157332
158311
159275
160241
16183
162333
163284
164230
16567
166260
167404
168384
169489
170353
171373
172272
173217
17484
175348
176466
17758
1788
179411
180230
181208
182348
18324
184463
185431
18642
187496
188322
189468
190393
191454
192298
193418
19496
19526
196327
197230
198205
19951
200404
20143
202436
203469
204468
205308
20695
207288
208481
209457
21098
211282
212318
213318
214409
215470
216369
217316
218413
21985
22077
221490
22287
223364
224395
225282
226238
227419
22872
22990
230307
231435
232277
233273
234306
235224
236309
237389
238327
239242
240369
241392
242272
243331
244401
245242
246452
247226
2485
249497
250402
251396
252317
253395
25458
25535
256336
25795
25834
259229
260233
261472
262322
263498
26442
265321
266430
267489
268458
26978
27076
27141
272223
273492
274449
275218
276228
277453
27830
279209
28064
281468
28276
28374
284342
28569
286230
28733
288368
289296
290216
291367
292344
293274
294219
295239
296485
297223
298256
299263
30070
301487
302480
303401
304288
3055
306244
307438
308467
309432
310202
311316
312229
313469
314463
315280
31635
317283
318331
319235
32080
32144
322321
323335
324466
325366
326403
327483
32853
329257
330406
331409
332406
333401
334258
33590
336203
337262
338348
339424
340396
341201
342217
343431
344454
345478
346298
347431
348424
349382
3505
35170
352397
353480
354291
35524
356351
357255
35870
359438
360414
361200
362491
363237
364439
365360
366248
367479
368305
369417
370444
371429
372443
373323
374325
375277
376230
377478
378468
379310
380317
381333
382493
383460
384207
385249
386265
387480
38883
389353
390214
391462
392233
393406
394454
395375
396401
397421
398407
399384
400256
40126
40267
403384
404379
405462
406492
407298
4089
409341
410498
411458
412362
413285
414348
415273
416281
417344
41897
419469
420315
42184
42228
42337
424448
425348
426307
427414
428477
429222
43090
431403
432400
433200
43497