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

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

#
text | 1274 lines | 1249 code | 25 blank | 0 comment | 0 complexity | c8b0194490a9f8d129c05a3de9a97cc6 MD5 | raw file
   1PREHOOK: query: EXPLAIN SELECT count(value) AS c FROM src GROUP BY key HAVING c > 3
   2PREHOOK: type: QUERY
   3POSTHOOK: query: EXPLAIN SELECT count(value) AS c FROM src GROUP BY key HAVING c > 3
   4POSTHOOK: type: QUERY
   5ABSTRACT SYNTAX TREE:
   6  (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME src))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION count (TOK_TABLE_OR_COL value)) c)) (TOK_GROUPBY (TOK_TABLE_OR_COL key)) (TOK_HAVING (> (TOK_TABLE_OR_COL c) 3))))
   7
   8STAGE DEPENDENCIES:
   9  Stage-1 is a root stage
  10  Stage-0 is a root stage
  11
  12STAGE PLANS:
  13  Stage: Stage-1
  14    Map Reduce
  15      Alias -> Map Operator Tree:
  16        src 
  17          TableScan
  18            alias: src
  19            Select Operator
  20              expressions:
  21                    expr: key
  22                    type: string
  23                    expr: value
  24                    type: string
  25              outputColumnNames: key, value
  26              Group By Operator
  27                aggregations:
  28                      expr: count(value)
  29                bucketGroup: false
  30                keys:
  31                      expr: key
  32                      type: string
  33                mode: hash
  34                outputColumnNames: _col0, _col1
  35                Reduce Output Operator
  36                  key expressions:
  37                        expr: _col0
  38                        type: string
  39                  sort order: +
  40                  Map-reduce partition columns:
  41                        expr: _col0
  42                        type: string
  43                  tag: -1
  44                  value expressions:
  45                        expr: _col1
  46                        type: bigint
  47      Reduce Operator Tree:
  48        Group By Operator
  49          aggregations:
  50                expr: count(VALUE._col0)
  51          bucketGroup: false
  52          keys:
  53                expr: KEY._col0
  54                type: string
  55          mode: mergepartial
  56          outputColumnNames: _col0, _col1
  57          Filter Operator
  58            predicate:
  59                expr: (_col1 > 3)
  60                type: boolean
  61            Select Operator
  62              expressions:
  63                    expr: _col1
  64                    type: bigint
  65              outputColumnNames: _col0
  66              File Output Operator
  67                compressed: false
  68                GlobalTableId: 0
  69                table:
  70                    input format: org.apache.hadoop.mapred.TextInputFormat
  71                    output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
  72
  73  Stage: Stage-0
  74    Fetch Operator
  75      limit: -1
  76
  77
  78PREHOOK: query: SELECT count(value) AS c FROM src GROUP BY key HAVING c > 3
  79PREHOOK: type: QUERY
  80PREHOOK: Input: default@src
  81PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_01-55-25_061_1887192452567405688/-mr-10000
  82POSTHOOK: query: SELECT count(value) AS c FROM src GROUP BY key HAVING c > 3
  83POSTHOOK: type: QUERY
  84POSTHOOK: Input: default@src
  85POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_01-55-25_061_1887192452567405688/-mr-10000
  864
  874
  885
  894
  905
  915
  924
  934
  945
  954
  96PREHOOK: query: EXPLAIN SELECT key, max(value) AS c FROM src GROUP BY key HAVING key != 302
  97PREHOOK: type: QUERY
  98POSTHOOK: query: EXPLAIN SELECT key, max(value) AS c FROM src GROUP BY key HAVING key != 302
  99POSTHOOK: type: QUERY
 100ABSTRACT SYNTAX TREE:
 101  (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 key)) (TOK_SELEXPR (TOK_FUNCTION max (TOK_TABLE_OR_COL value)) c)) (TOK_GROUPBY (TOK_TABLE_OR_COL key)) (TOK_HAVING (!= (TOK_TABLE_OR_COL key) 302))))
 102
 103STAGE DEPENDENCIES:
 104  Stage-1 is a root stage
 105  Stage-0 is a root stage
 106
 107STAGE PLANS:
 108  Stage: Stage-1
 109    Map Reduce
 110      Alias -> Map Operator Tree:
 111        src 
 112          TableScan
 113            alias: src
 114            Filter Operator
 115              predicate:
 116                  expr: (key <> 302)
 117                  type: boolean
 118              Select Operator
 119                expressions:
 120                      expr: key
 121                      type: string
 122                      expr: value
 123                      type: string
 124                outputColumnNames: key, value
 125                Group By Operator
 126                  aggregations:
 127                        expr: max(value)
 128                  bucketGroup: false
 129                  keys:
 130                        expr: key
 131                        type: string
 132                  mode: hash
 133                  outputColumnNames: _col0, _col1
 134                  Reduce Output Operator
 135                    key expressions:
 136                          expr: _col0
 137                          type: string
 138                    sort order: +
 139                    Map-reduce partition columns:
 140                          expr: _col0
 141                          type: string
 142                    tag: -1
 143                    value expressions:
 144                          expr: _col1
 145                          type: string
 146      Reduce Operator Tree:
 147        Group By Operator
 148          aggregations:
 149                expr: max(VALUE._col0)
 150          bucketGroup: false
 151          keys:
 152                expr: KEY._col0
 153                type: string
 154          mode: mergepartial
 155          outputColumnNames: _col0, _col1
 156          Select Operator
 157            expressions:
 158                  expr: _col0
 159                  type: string
 160                  expr: _col1
 161                  type: string
 162            outputColumnNames: _col0, _col1
 163            File Output Operator
 164              compressed: false
 165              GlobalTableId: 0
 166              table:
 167                  input format: org.apache.hadoop.mapred.TextInputFormat
 168                  output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
 169
 170  Stage: Stage-0
 171    Fetch Operator
 172      limit: -1
 173
 174
 175PREHOOK: query: SELECT key, max(value) AS c FROM src GROUP BY key HAVING key != 302
 176PREHOOK: type: QUERY
 177PREHOOK: Input: default@src
 178PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_01-55-28_939_197667381386821930/-mr-10000
 179POSTHOOK: query: SELECT key, max(value) AS c FROM src GROUP BY key HAVING key != 302
 180POSTHOOK: type: QUERY
 181POSTHOOK: Input: default@src
 182POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_01-55-28_939_197667381386821930/-mr-10000
 1830	val_0
 18410	val_10
 185100	val_100
 186103	val_103
 187104	val_104
 188105	val_105
 18911	val_11
 190111	val_111
 191113	val_113
 192114	val_114
 193116	val_116
 194118	val_118
 195119	val_119
 19612	val_12
 197120	val_120
 198125	val_125
 199126	val_126
 200128	val_128
 201129	val_129
 202131	val_131
 203133	val_133
 204134	val_134
 205136	val_136
 206137	val_137
 207138	val_138
 208143	val_143
 209145	val_145
 210146	val_146
 211149	val_149
 21215	val_15
 213150	val_150
 214152	val_152
 215153	val_153
 216155	val_155
 217156	val_156
 218157	val_157
 219158	val_158
 220160	val_160
 221162	val_162
 222163	val_163
 223164	val_164
 224165	val_165
 225166	val_166
 226167	val_167
 227168	val_168
 228169	val_169
 22917	val_17
 230170	val_170
 231172	val_172
 232174	val_174
 233175	val_175
 234176	val_176
 235177	val_177
 236178	val_178
 237179	val_179
 23818	val_18
 239180	val_180
 240181	val_181
 241183	val_183
 242186	val_186
 243187	val_187
 244189	val_189
 24519	val_19
 246190	val_190
 247191	val_191
 248192	val_192
 249193	val_193
 250194	val_194
 251195	val_195
 252196	val_196
 253197	val_197
 254199	val_199
 2552	val_2
 25620	val_20
 257200	val_200
 258201	val_201
 259202	val_202
 260203	val_203
 261205	val_205
 262207	val_207
 263208	val_208
 264209	val_209
 265213	val_213
 266214	val_214
 267216	val_216
 268217	val_217
 269218	val_218
 270219	val_219
 271221	val_221
 272222	val_222
 273223	val_223
 274224	val_224
 275226	val_226
 276228	val_228
 277229	val_229
 278230	val_230
 279233	val_233
 280235	val_235
 281237	val_237
 282238	val_238
 283239	val_239
 28424	val_24
 285241	val_241
 286242	val_242
 287244	val_244
 288247	val_247
 289248	val_248
 290249	val_249
 291252	val_252
 292255	val_255
 293256	val_256
 294257	val_257
 295258	val_258
 29626	val_26
 297260	val_260
 298262	val_262
 299263	val_263
 300265	val_265
 301266	val_266
 30227	val_27
 303272	val_272
 304273	val_273
 305274	val_274
 306275	val_275
 307277	val_277
 308278	val_278
 30928	val_28
 310280	val_280
 311281	val_281
 312282	val_282
 313283	val_283
 314284	val_284
 315285	val_285
 316286	val_286
 317287	val_287
 318288	val_288
 319289	val_289
 320291	val_291
 321292	val_292
 322296	val_296
 323298	val_298
 32430	val_30
 325305	val_305
 326306	val_306
 327307	val_307
 328308	val_308
 329309	val_309
 330310	val_310
 331311	val_311
 332315	val_315
 333316	val_316
 334317	val_317
 335318	val_318
 336321	val_321
 337322	val_322
 338323	val_323
 339325	val_325
 340327	val_327
 34133	val_33
 342331	val_331
 343332	val_332
 344333	val_333
 345335	val_335
 346336	val_336
 347338	val_338
 348339	val_339
 34934	val_34
 350341	val_341
 351342	val_342
 352344	val_344
 353345	val_345
 354348	val_348
 35535	val_35
 356351	val_351
 357353	val_353
 358356	val_356
 359360	val_360
 360362	val_362
 361364	val_364
 362365	val_365
 363366	val_366
 364367	val_367
 365368	val_368
 366369	val_369
 36737	val_37
 368373	val_373
 369374	val_374
 370375	val_375
 371377	val_377
 372378	val_378
 373379	val_379
 374382	val_382
 375384	val_384
 376386	val_386
 377389	val_389
 378392	val_392
 379393	val_393
 380394	val_394
 381395	val_395
 382396	val_396
 383397	val_397
 384399	val_399
 3854	val_4
 386400	val_400
 387401	val_401
 388402	val_402
 389403	val_403
 390404	val_404
 391406	val_406
 392407	val_407
 393409	val_409
 39441	val_41
 395411	val_411
 396413	val_413
 397414	val_414
 398417	val_417
 399418	val_418
 400419	val_419
 40142	val_42
 402421	val_421
 403424	val_424
 404427	val_427
 405429	val_429
 40643	val_43
 407430	val_430
 408431	val_431
 409432	val_432
 410435	val_435
 411436	val_436
 412437	val_437
 413438	val_438
 414439	val_439
 41544	val_44
 416443	val_443
 417444	val_444
 418446	val_446
 419448	val_448
 420449	val_449
 421452	val_452
 422453	val_453
 423454	val_454
 424455	val_455
 425457	val_457
 426458	val_458
 427459	val_459
 428460	val_460
 429462	val_462
 430463	val_463
 431466	val_466
 432467	val_467
 433468	val_468
 434469	val_469
 43547	val_47
 436470	val_470
 437472	val_472
 438475	val_475
 439477	val_477
 440478	val_478
 441479	val_479
 442480	val_480
 443481	val_481
 444482	val_482
 445483	val_483
 446484	val_484
 447485	val_485
 448487	val_487
 449489	val_489
 450490	val_490
 451491	val_491
 452492	val_492
 453493	val_493
 454494	val_494
 455495	val_495
 456496	val_496
 457497	val_497
 458498	val_498
 4595	val_5
 46051	val_51
 46153	val_53
 46254	val_54
 46357	val_57
 46458	val_58
 46564	val_64
 46665	val_65
 46766	val_66
 46867	val_67
 46969	val_69
 47070	val_70
 47172	val_72
 47274	val_74
 47376	val_76
 47477	val_77
 47578	val_78
 4768	val_8
 47780	val_80
 47882	val_82
 47983	val_83
 48084	val_84
 48185	val_85
 48286	val_86
 48387	val_87
 4849	val_9
 48590	val_90
 48692	val_92
 48795	val_95
 48896	val_96
 48997	val_97
 49098	val_98
 491PREHOOK: query: EXPLAIN SELECT key FROM src GROUP BY key HAVING max(value) > "val_255"
 492PREHOOK: type: QUERY
 493POSTHOOK: query: EXPLAIN SELECT key FROM src GROUP BY key HAVING max(value) > "val_255"
 494POSTHOOK: type: QUERY
 495ABSTRACT SYNTAX TREE:
 496  (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 key))) (TOK_GROUPBY (TOK_TABLE_OR_COL key)) (TOK_HAVING (> (TOK_FUNCTION max (TOK_TABLE_OR_COL value)) "val_255"))))
 497
 498STAGE DEPENDENCIES:
 499  Stage-1 is a root stage
 500  Stage-0 is a root stage
 501
 502STAGE PLANS:
 503  Stage: Stage-1
 504    Map Reduce
 505      Alias -> Map Operator Tree:
 506        src 
 507          TableScan
 508            alias: src
 509            Select Operator
 510              expressions:
 511                    expr: key
 512                    type: string
 513                    expr: value
 514                    type: string
 515              outputColumnNames: key, value
 516              Group By Operator
 517                aggregations:
 518                      expr: max(value)
 519                bucketGroup: false
 520                keys:
 521                      expr: key
 522                      type: string
 523                mode: hash
 524                outputColumnNames: _col0, _col1
 525                Reduce Output Operator
 526                  key expressions:
 527                        expr: _col0
 528                        type: string
 529                  sort order: +
 530                  Map-reduce partition columns:
 531                        expr: _col0
 532                        type: string
 533                  tag: -1
 534                  value expressions:
 535                        expr: _col1
 536                        type: string
 537      Reduce Operator Tree:
 538        Group By Operator
 539          aggregations:
 540                expr: max(VALUE._col0)
 541          bucketGroup: false
 542          keys:
 543                expr: KEY._col0
 544                type: string
 545          mode: mergepartial
 546          outputColumnNames: _col0, _col1
 547          Filter Operator
 548            predicate:
 549                expr: (_col1 > 'val_255')
 550                type: boolean
 551            Select Operator
 552              expressions:
 553                    expr: _col0
 554                    type: string
 555              outputColumnNames: _col0
 556              File Output Operator
 557                compressed: false
 558                GlobalTableId: 0
 559                table:
 560                    input format: org.apache.hadoop.mapred.TextInputFormat
 561                    output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
 562
 563  Stage: Stage-0
 564    Fetch Operator
 565      limit: -1
 566
 567
 568PREHOOK: query: SELECT key FROM src GROUP BY key HAVING max(value) > "val_255"
 569PREHOOK: type: QUERY
 570PREHOOK: Input: default@src
 571PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_01-55-32_510_2871147486749455087/-mr-10000
 572POSTHOOK: query: SELECT key FROM src GROUP BY key HAVING max(value) > "val_255"
 573POSTHOOK: type: QUERY
 574POSTHOOK: Input: default@src
 575POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_01-55-32_510_2871147486749455087/-mr-10000
 576256
 577257
 578258
 57926
 580260
 581262
 582263
 583265
 584266
 58527
 586272
 587273
 588274
 589275
 590277
 591278
 59228
 593280
 594281
 595282
 596283
 597284
 598285
 599286
 600287
 601288
 602289
 603291
 604292
 605296
 606298
 60730
 608302
 609305
 610306
 611307
 612308
 613309
 614310
 615311
 616315
 617316
 618317
 619318
 620321
 621322
 622323
 623325
 624327
 62533
 626331
 627332
 628333
 629335
 630336
 631338
 632339
 63334
 634341
 635342
 636344
 637345
 638348
 63935
 640351
 641353
 642356
 643360
 644362
 645364
 646365
 647366
 648367
 649368
 650369
 65137
 652373
 653374
 654375
 655377
 656378
 657379
 658382
 659384
 660386
 661389
 662392
 663393
 664394
 665395
 666396
 667397
 668399
 6694
 670400
 671401
 672402
 673403
 674404
 675406
 676407
 677409
 67841
 679411
 680413
 681414
 682417
 683418
 684419
 68542
 686421
 687424
 688427
 689429
 69043
 691430
 692431
 693432
 694435
 695436
 696437
 697438
 698439
 69944
 700443
 701444
 702446
 703448
 704449
 705452
 706453
 707454
 708455
 709457
 710458
 711459
 712460
 713462
 714463
 715466
 716467
 717468
 718469
 71947
 720470
 721472
 722475
 723477
 724478
 725479
 726480
 727481
 728482
 729483
 730484
 731485
 732487
 733489
 734490
 735491
 736492
 737493
 738494
 739495
 740496
 741497
 742498
 7435
 74451
 74553
 74654
 74757
 74858
 74964
 75065
 75166
 75267
 75369
 75470
 75572
 75674
 75776
 75877
 75978
 7608
 76180
 76282
 76383
 76484
 76585
 76686
 76787
 7689
 76990
 77092
 77195
 77296
 77397
 77498
 775PREHOOK: query: EXPLAIN SELECT key FROM src where key > 300 GROUP BY key HAVING max(value) > "val_255"
 776PREHOOK: type: QUERY
 777POSTHOOK: query: EXPLAIN SELECT key FROM src where key > 300 GROUP BY key HAVING max(value) > "val_255"
 778POSTHOOK: type: QUERY
 779ABSTRACT SYNTAX TREE:
 780  (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 key))) (TOK_WHERE (> (TOK_TABLE_OR_COL key) 300)) (TOK_GROUPBY (TOK_TABLE_OR_COL key)) (TOK_HAVING (> (TOK_FUNCTION max (TOK_TABLE_OR_COL value)) "val_255"))))
 781
 782STAGE DEPENDENCIES:
 783  Stage-1 is a root stage
 784  Stage-0 is a root stage
 785
 786STAGE PLANS:
 787  Stage: Stage-1
 788    Map Reduce
 789      Alias -> Map Operator Tree:
 790        src 
 791          TableScan
 792            alias: src
 793            Filter Operator
 794              predicate:
 795                  expr: (key > 300)
 796                  type: boolean
 797              Select Operator
 798                expressions:
 799                      expr: key
 800                      type: string
 801                      expr: value
 802                      type: string
 803                outputColumnNames: key, value
 804                Group By Operator
 805                  aggregations:
 806                        expr: max(value)
 807                  bucketGroup: false
 808                  keys:
 809                        expr: key
 810                        type: string
 811                  mode: hash
 812                  outputColumnNames: _col0, _col1
 813                  Reduce Output Operator
 814                    key expressions:
 815                          expr: _col0
 816                          type: string
 817                    sort order: +
 818                    Map-reduce partition columns:
 819                          expr: _col0
 820                          type: string
 821                    tag: -1
 822                    value expressions:
 823                          expr: _col1
 824                          type: string
 825      Reduce Operator Tree:
 826        Group By Operator
 827          aggregations:
 828                expr: max(VALUE._col0)
 829          bucketGroup: false
 830          keys:
 831                expr: KEY._col0
 832                type: string
 833          mode: mergepartial
 834          outputColumnNames: _col0, _col1
 835          Filter Operator
 836            predicate:
 837                expr: (_col1 > 'val_255')
 838                type: boolean
 839            Select Operator
 840              expressions:
 841                    expr: _col0
 842                    type: string
 843              outputColumnNames: _col0
 844              File Output Operator
 845                compressed: false
 846                GlobalTableId: 0
 847                table:
 848                    input format: org.apache.hadoop.mapred.TextInputFormat
 849                    output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
 850
 851  Stage: Stage-0
 852    Fetch Operator
 853      limit: -1
 854
 855
 856PREHOOK: query: SELECT key FROM src where key > 300 GROUP BY key HAVING max(value) > "val_255"
 857PREHOOK: type: QUERY
 858PREHOOK: Input: default@src
 859PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_01-55-36_115_3214302557613052494/-mr-10000
 860POSTHOOK: query: SELECT key FROM src where key > 300 GROUP BY key HAVING max(value) > "val_255"
 861POSTHOOK: type: QUERY
 862POSTHOOK: Input: default@src
 863POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_01-55-36_115_3214302557613052494/-mr-10000
 864302
 865305
 866306
 867307
 868308
 869309
 870310
 871311
 872315
 873316
 874317
 875318
 876321
 877322
 878323
 879325
 880327
 881331
 882332
 883333
 884335
 885336
 886338
 887339
 888341
 889342
 890344
 891345
 892348
 893351
 894353
 895356
 896360
 897362
 898364
 899365
 900366
 901367
 902368
 903369
 904373
 905374
 906375
 907377
 908378
 909379
 910382
 911384
 912386
 913389
 914392
 915393
 916394
 917395
 918396
 919397
 920399
 921400
 922401
 923402
 924403
 925404
 926406
 927407
 928409
 929411
 930413
 931414
 932417
 933418
 934419
 935421
 936424
 937427
 938429
 939430
 940431
 941432
 942435
 943436
 944437
 945438
 946439
 947443
 948444
 949446
 950448
 951449
 952452
 953453
 954454
 955455
 956457
 957458
 958459
 959460
 960462
 961463
 962466
 963467
 964468
 965469
 966470
 967472
 968475
 969477
 970478
 971479
 972480
 973481
 974482
 975483
 976484
 977485
 978487
 979489
 980490
 981491
 982492
 983493
 984494
 985495
 986496
 987497
 988498
 989PREHOOK: query: EXPLAIN SELECT key, max(value) FROM src GROUP BY key HAVING max(value) > "val_255"
 990PREHOOK: type: QUERY
 991POSTHOOK: query: EXPLAIN SELECT key, max(value) FROM src GROUP BY key HAVING max(value) > "val_255"
 992POSTHOOK: type: QUERY
 993ABSTRACT SYNTAX TREE:
 994  (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 key)) (TOK_SELEXPR (TOK_FUNCTION max (TOK_TABLE_OR_COL value)))) (TOK_GROUPBY (TOK_TABLE_OR_COL key)) (TOK_HAVING (> (TOK_FUNCTION max (TOK_TABLE_OR_COL value)) "val_255"))))
 995
 996STAGE DEPENDENCIES:
 997  Stage-1 is a root stage
 998  Stage-0 is a root stage
 999
1000STAGE PLANS:
1001  Stage: Stage-1
1002    Map Reduce
1003      Alias -> Map Operator Tree:
1004        src 
1005          TableScan
1006            alias: src
1007            Select Operator
1008              expressions:
1009                    expr: key
1010                    type: string
1011                    expr: value
1012                    type: string
1013              outputColumnNames: key, value
1014              Group By Operator
1015                aggregations:
1016                      expr: max(value)
1017                bucketGroup: false
1018                keys:
1019                      expr: key
1020                      type: string
1021                mode: hash
1022                outputColumnNames: _col0, _col1
1023                Reduce Output Operator
1024                  key expressions:
1025                        expr: _col0
1026                        type: string
1027                  sort order: +
1028                  Map-reduce partition columns:
1029                        expr: _col0
1030                        type: string
1031                  tag: -1
1032                  value expressions:
1033                        expr: _col1
1034                        type: string
1035      Reduce Operator Tree:
1036        Group By Operator
1037          aggregations:
1038                expr: max(VALUE._col0)
1039          bucketGroup: false
1040          keys:
1041                expr: KEY._col0
1042                type: string
1043          mode: mergepartial
1044          outputColumnNames: _col0, _col1
1045          Filter Operator
1046            predicate:
1047                expr: (_col1 > 'val_255')
1048                type: boolean
1049            Select Operator
1050              expressions:
1051                    expr: _col0
1052                    type: string
1053                    expr: _col1
1054                    type: string
1055              outputColumnNames: _col0, _col1
1056              File Output Operator
1057                compressed: false
1058                GlobalTableId: 0
1059                table:
1060                    input format: org.apache.hadoop.mapred.TextInputFormat
1061                    output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
1062
1063  Stage: Stage-0
1064    Fetch Operator
1065      limit: -1
1066
1067
1068PREHOOK: query: SELECT key, max(value) FROM src GROUP BY key HAVING max(value) > "val_255"
1069PREHOOK: type: QUERY
1070PREHOOK: Input: default@src
1071PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_01-55-39_727_9028145327249190888/-mr-10000
1072POSTHOOK: query: SELECT key, max(value) FROM src GROUP BY key HAVING max(value) > "val_255"
1073POSTHOOK: type: QUERY
1074POSTHOOK: Input: default@src
1075POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_01-55-39_727_9028145327249190888/-mr-10000
1076256	val_256
1077257	val_257
1078258	val_258
107926	val_26
1080260	val_260
1081262	val_262
1082263	val_263
1083265	val_265
1084266	val_266
108527	val_27
1086272	val_272
1087273	val_273
1088274	val_274
1089275	val_275
1090277	val_277
1091278	val_278
109228	val_28
1093280	val_280
1094281	val_281
1095282	val_282
1096283	val_283
1097284	val_284
1098285	val_285
1099286	val_286
1100287	val_287
1101288	val_288
1102289	val_289
1103291	val_291
1104292	val_292
1105296	val_296
1106298	val_298
110730	val_30
1108302	val_302
1109305	val_305
1110306	val_306
1111307	val_307
1112308	val_308
1113309	val_309
1114310	val_310
1115311	val_311
1116315	val_315
1117316	val_316
1118317	val_317
1119318	val_318
1120321	val_321
1121322	val_322
1122323	val_323
1123325	val_325
1124327	val_327
112533	val_33
1126331	val_331
1127332	val_332
1128333	val_333
1129335	val_335
1130336	val_336
1131338	val_338
1132339	val_339
113334	val_34
1134341	val_341
1135342	val_342
1136344	val_344
1137345	val_345
1138348	val_348
113935	val_35
1140351	val_351
1141353	val_353
1142356	val_356
1143360	val_360
1144362	val_362
1145364	val_364
1146365	val_365
1147366	val_366
1148367	val_367
1149368	val_368
1150369	val_369
115137	val_37
1152373	val_373
1153374	val_374
1154375	val_375
1155377	val_377
1156378	val_378
1157379	val_379
1158382	val_382
1159384	val_384
1160386	val_386
1161389	val_389
1162392	val_392
1163393	val_393
1164394	val_394
1165395	val_395
1166396	val_396
1167397	val_397
1168399	val_399
11694	val_4
1170400	val_400
1171401	val_401
1172402	val_402
1173403	val_403
1174404	val_404
1175406	val_406
1176407	val_407
1177409	val_409
117841	val_41
1179411	val_411
1180413	val_413
1181414	val_414
1182417	val_417
1183418	val_418
1184419	val_419
118542	val_42
1186421	val_421
1187424	val_424
1188427	val_427
1189429	val_429
119043	val_43
1191430	val_430
1192431	val_431
1193432	val_432
1194435	val_435
1195436	val_436
1196437	val_437
1197438	val_438
1198439	val_439
119944	val_44
1200443	val_443
1201444	val_444
1202446	val_446
1203448	val_448
1204449	val_449
1205452	val_452
1206453	val_453
1207454	val_454
1208455	val_455
1209457	val_457
1210458	val_458
1211459	val_459
1212460	val_460
1213462	val_462
1214463	val_463
1215466	val_466
1216467	val_467
1217468	val_468
1218469	val_469
121947	val_47
1220470	val_470
1221472	val_472
1222475	val_475
1223477	val_477
1224478	val_478
1225479	val_479
1226480	val_480
1227481	val_481
1228482	val_482
1229483	val_483
1230484	val_484
1231485	val_485
1232487	val_487
1233489	val_489
1234490	val_490
1235491	val_491
1236492	val_492
1237493	val_493
1238494	val_494
1239495	val_495
1240496	val_496
1241497	val_497
1242498	val_498
12435	val_5
124451	val_51
124553	val_53
124654	val_54
124757	val_57
124858	val_58
124964	val_64
125065	val_65
125166	val_66
125267	val_67
125369	val_69
125470	val_70
125572	val_72
125674	val_74
125776	val_76
125877	val_77
125978	val_78
12608	val_8
126180	val_80
126282	val_82
126383	val_83
126484	val_84
126585	val_85
126686	val_86
126787	val_87
12689	val_9
126990	val_90
127092	val_92
127195	val_95
127296	val_96
127397	val_97
127498	val_98