/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
Possible License(s): Apache-2.0, BSD-3-Clause, JSON, CPL-1.0
- PREHOOK: query: EXPLAIN
- SELECT src.key as c3 from src where src.key > '2'
- PREHOOK: type: QUERY
- POSTHOOK: query: EXPLAIN
- SELECT src.key as c3 from src where src.key > '2'
- POSTHOOK: type: QUERY
- ABSTRACT SYNTAX TREE:
- (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'))))
- STAGE DEPENDENCIES:
- Stage-1 is a root stage
- Stage-0 is a root stage
- STAGE PLANS:
- Stage: Stage-1
- Map Reduce
- Alias -> Map Operator Tree:
- src
- TableScan
- alias: src
- Filter Operator
- predicate:
- expr: (key > '2')
- type: boolean
- Filter Operator
- predicate:
- expr: (key > '2')
- type: boolean
- Select Operator
- expressions:
- expr: key
- type: string
- outputColumnNames: _col0
- File Output Operator
- compressed: false
- GlobalTableId: 0
- table:
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- Stage: Stage-0
- Fetch Operator
- limit: -1
- PREHOOK: query: SELECT src.key as c3 from src where src.key > '2'
- PREHOOK: type: QUERY
- PREHOOK: Input: default@src
- PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_16-56-18_823_4035711180151393629/-mr-10000
- POSTHOOK: query: SELECT src.key as c3 from src where src.key > '2'
- POSTHOOK: type: QUERY
- POSTHOOK: Input: default@src
- POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_16-56-18_823_4035711180151393629/-mr-10000
- 238
- 86
- 311
- 27
- 409
- 255
- 278
- 98
- 484
- 265
- 401
- 273
- 224
- 369
- 66
- 213
- 406
- 429
- 374
- 469
- 495
- 37
- 327
- 281
- 277
- 209
- 82
- 403
- 417
- 430
- 252
- 292
- 219
- 287
- 338
- 446
- 459
- 394
- 237
- 482
- 413
- 494
- 207
- 466
- 208
- 399
- 396
- 247
- 417
- 489
- 377
- 397
- 309
- 365
- 266
- 439
- 342
- 367
- 325
- 475
- 203
- 339
- 455
- 311
- 316
- 57
- 302
- 205
- 438
- 345
- 20
- 489
- 378
- 221
- 92
- 47
- 72
- 4
- 280
- 35
- 427
- 277
- 208
- 356
- 399
- 382
- 498
- 386
- 437
- 469
- 286
- 54
- 459
- 51
- 239
- 213
- 216
- 430
- 278
- 289
- 221
- 65
- 318
- 332
- 311
- 275
- 241
- 83
- 333
- 284
- 230
- 67
- 260
- 404
- 384
- 489
- 353
- 373
- 272
- 217
- 84
- 348
- 466
- 58
- 8
- 411
- 230
- 208
- 348
- 24
- 463
- 431
- 42
- 496
- 322
- 468
- 393
- 454
- 298
- 418
- 96
- 26
- 327
- 230
- 205
- 51
- 404
- 43
- 436
- 469
- 468
- 308
- 95
- 288
- 481
- 457
- 98
- 282
- 318
- 318
- 409
- 470
- 369
- 316
- 413
- 85
- 77
- 490
- 87
- 364
- 395
- 282
- 238
- 419
- 72
- 90
- 307
- 435
- 277
- 273
- 306
- 224
- 309
- 389
- 327
- 242
- 369
- 392
- 272
- 331
- 401
- 242
- 452
- 226
- 5
- 497
- 402
- 396
- 317
- 395
- 58
- 35
- 336
- 95
- 34
- 229
- 233
- 472
- 322
- 498
- 42
- 321
- 430
- 489
- 458
- 78
- 76
- 41
- 223
- 492
- 449
- 218
- 228
- 453
- 30
- 209
- 64
- 468
- 76
- 74
- 342
- 69
- 230
- 33
- 368
- 296
- 216
- 367
- 344
- 274
- 219
- 239
- 485
- 223
- 256
- 263
- 70
- 487
- 480
- 401
- 288
- 5
- 244
- 438
- 467
- 432
- 202
- 316
- 229
- 469
- 463
- 280
- 35
- 283
- 331
- 235
- 80
- 44
- 321
- 335
- 466
- 366
- 403
- 483
- 53
- 257
- 406
- 409
- 406
- 401
- 258
- 90
- 203
- 262
- 348
- 424
- 396
- 201
- 217
- 431
- 454
- 478
- 298
- 431
- 424
- 382
- 5
- 70
- 397
- 480
- 291
- 24
- 351
- 255
- 70
- 438
- 414
- 200
- 491
- 237
- 439
- 360
- 248
- 479
- 305
- 417
- 444
- 429
- 443
- 323
- 325
- 277
- 230
- 478
- 468
- 310
- 317
- 333
- 493
- 460
- 207
- 249
- 265
- 480
- 83
- 353
- 214
- 462
- 233
- 406
- 454
- 375
- 401
- 421
- 407
- 384
- 256
- 26
- 67
- 384
- 379
- 462
- 492
- 298
- 9
- 341
- 498
- 458
- 362
- 285
- 348
- 273
- 281
- 344
- 97
- 469
- 315
- 84
- 28
- 37
- 448
- 348
- 307
- 414
- 477
- 222
- 90
- 403
- 400
- 200
- 97