PageRenderTime 24ms CodeModel.GetById 13ms app.highlight 5ms RepoModel.GetById 1ms app.codeStats 0ms

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

#
text | 1087 lines | 1080 code | 7 blank | 0 comment | 0 complexity | d6c1fc8fd3ad80029bfcf8b719b6e6ef MD5 | raw file
   1PREHOOK: query: -- union case: both subqueries are a map-only jobs, same input, followed by filesink
   2
   3explain 
   4  select unionsrc.key, unionsrc.value FROM (select s1.key as key, s1.value as value from src s1 UNION  ALL  
   5                                            select s2.key as key, s2.value as value from src s2) unionsrc
   6PREHOOK: type: QUERY
   7POSTHOOK: query: -- union case: both subqueries are a map-only jobs, same input, followed by filesink
   8
   9explain 
  10  select unionsrc.key, unionsrc.value FROM (select s1.key as key, s1.value as value from src s1 UNION  ALL  
  11                                            select s2.key as key, s2.value as value from src s2) unionsrc
  12POSTHOOK: type: QUERY
  13ABSTRACT SYNTAX TREE:
  14  (TOK_QUERY (TOK_FROM (TOK_SUBQUERY (TOK_UNION (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME src) s1)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (. (TOK_TABLE_OR_COL s1) key) key) (TOK_SELEXPR (. (TOK_TABLE_OR_COL s1) value) value)))) (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME src) s2)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (. (TOK_TABLE_OR_COL s2) key) key) (TOK_SELEXPR (. (TOK_TABLE_OR_COL s2) value) value))))) unionsrc)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (. (TOK_TABLE_OR_COL unionsrc) key)) (TOK_SELEXPR (. (TOK_TABLE_OR_COL unionsrc) value)))))
  15
  16STAGE DEPENDENCIES:
  17  Stage-1 is a root stage
  18  Stage-0 is a root stage
  19
  20STAGE PLANS:
  21  Stage: Stage-1
  22    Map Reduce
  23      Alias -> Map Operator Tree:
  24        null-subquery1:unionsrc-subquery1:s1 
  25          TableScan
  26            alias: s1
  27            Select Operator
  28              expressions:
  29                    expr: key
  30                    type: string
  31                    expr: value
  32                    type: string
  33              outputColumnNames: _col0, _col1
  34              Union
  35                Select Operator
  36                  expressions:
  37                        expr: _col0
  38                        type: string
  39                        expr: _col1
  40                        type: string
  41                  outputColumnNames: _col0, _col1
  42                  File Output Operator
  43                    compressed: false
  44                    GlobalTableId: 0
  45                    table:
  46                        input format: org.apache.hadoop.mapred.TextInputFormat
  47                        output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
  48        null-subquery2:unionsrc-subquery2:s2 
  49          TableScan
  50            alias: s2
  51            Select Operator
  52              expressions:
  53                    expr: key
  54                    type: string
  55                    expr: value
  56                    type: string
  57              outputColumnNames: _col0, _col1
  58              Union
  59                Select Operator
  60                  expressions:
  61                        expr: _col0
  62                        type: string
  63                        expr: _col1
  64                        type: string
  65                  outputColumnNames: _col0, _col1
  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 unionsrc.key, unionsrc.value FROM (select s1.key as key, s1.value as value from src s1 UNION  ALL  
  79                                          select s2.key as key, s2.value as value from src s2) unionsrc
  80PREHOOK: type: QUERY
  81PREHOOK: Input: default@src
  82PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-49-19_847_4478691560795813147/-mr-10000
  83POSTHOOK: query: select unionsrc.key, unionsrc.value FROM (select s1.key as key, s1.value as value from src s1 UNION  ALL  
  84                                          select s2.key as key, s2.value as value from src s2) unionsrc
  85POSTHOOK: type: QUERY
  86POSTHOOK: Input: default@src
  87POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-49-19_847_4478691560795813147/-mr-10000
  88238	val_238
  89238	val_238
  9086	val_86
  9186	val_86
  92311	val_311
  93311	val_311
  9427	val_27
  9527	val_27
  96165	val_165
  97165	val_165
  98409	val_409
  99409	val_409
 100255	val_255
 101255	val_255
 102278	val_278
 103278	val_278
 10498	val_98
 10598	val_98
 106484	val_484
 107484	val_484
 108265	val_265
 109265	val_265
 110193	val_193
 111193	val_193
 112401	val_401
 113401	val_401
 114150	val_150
 115150	val_150
 116273	val_273
 117273	val_273
 118224	val_224
 119224	val_224
 120369	val_369
 121369	val_369
 12266	val_66
 12366	val_66
 124128	val_128
 125128	val_128
 126213	val_213
 127213	val_213
 128146	val_146
 129146	val_146
 130406	val_406
 131406	val_406
 132429	val_429
 133429	val_429
 134374	val_374
 135374	val_374
 136152	val_152
 137152	val_152
 138469	val_469
 139469	val_469
 140145	val_145
 141145	val_145
 142495	val_495
 143495	val_495
 14437	val_37
 14537	val_37
 146327	val_327
 147327	val_327
 148281	val_281
 149281	val_281
 150277	val_277
 151277	val_277
 152209	val_209
 153209	val_209
 15415	val_15
 15515	val_15
 15682	val_82
 15782	val_82
 158403	val_403
 159403	val_403
 160166	val_166
 161166	val_166
 162417	val_417
 163417	val_417
 164430	val_430
 165430	val_430
 166252	val_252
 167252	val_252
 168292	val_292
 169292	val_292
 170219	val_219
 171219	val_219
 172287	val_287
 173287	val_287
 174153	val_153
 175153	val_153
 176193	val_193
 177193	val_193
 178338	val_338
 179338	val_338
 180446	val_446
 181446	val_446
 182459	val_459
 183459	val_459
 184394	val_394
 185394	val_394
 186237	val_237
 187237	val_237
 188482	val_482
 189482	val_482
 190174	val_174
 191174	val_174
 192413	val_413
 193413	val_413
 194494	val_494
 195494	val_494
 196207	val_207
 197207	val_207
 198199	val_199
 199199	val_199
 200466	val_466
 201466	val_466
 202208	val_208
 203208	val_208
 204174	val_174
 205174	val_174
 206399	val_399
 207399	val_399
 208396	val_396
 209396	val_396
 210247	val_247
 211247	val_247
 212417	val_417
 213417	val_417
 214489	val_489
 215489	val_489
 216162	val_162
 217162	val_162
 218377	val_377
 219377	val_377
 220397	val_397
 221397	val_397
 222309	val_309
 223309	val_309
 224365	val_365
 225365	val_365
 226266	val_266
 227266	val_266
 228439	val_439
 229439	val_439
 230342	val_342
 231342	val_342
 232367	val_367
 233367	val_367
 234325	val_325
 235325	val_325
 236167	val_167
 237167	val_167
 238195	val_195
 239195	val_195
 240475	val_475
 241475	val_475
 24217	val_17
 24317	val_17
 244113	val_113
 245113	val_113
 246155	val_155
 247155	val_155
 248203	val_203
 249203	val_203
 250339	val_339
 251339	val_339
 2520	val_0
 2530	val_0
 254455	val_455
 255455	val_455
 256128	val_128
 257128	val_128
 258311	val_311
 259311	val_311
 260316	val_316
 261316	val_316
 26257	val_57
 26357	val_57
 264302	val_302
 265302	val_302
 266205	val_205
 267205	val_205
 268149	val_149
 269149	val_149
 270438	val_438
 271438	val_438
 272345	val_345
 273345	val_345
 274129	val_129
 275129	val_129
 276170	val_170
 277170	val_170
 27820	val_20
 27920	val_20
 280489	val_489
 281489	val_489
 282157	val_157
 283157	val_157
 284378	val_378
 285378	val_378
 286221	val_221
 287221	val_221
 28892	val_92
 28992	val_92
 290111	val_111
 291111	val_111
 29247	val_47
 29347	val_47
 29472	val_72
 29572	val_72
 2964	val_4
 2974	val_4
 298280	val_280
 299280	val_280
 30035	val_35
 30135	val_35
 302427	val_427
 303427	val_427
 304277	val_277
 305277	val_277
 306208	val_208
 307208	val_208
 308356	val_356
 309356	val_356
 310399	val_399
 311399	val_399
 312169	val_169
 313169	val_169
 314382	val_382
 315382	val_382
 316498	val_498
 317498	val_498
 318125	val_125
 319125	val_125
 320386	val_386
 321386	val_386
 322437	val_437
 323437	val_437
 324469	val_469
 325469	val_469
 326192	val_192
 327192	val_192
 328286	val_286
 329286	val_286
 330187	val_187
 331187	val_187
 332176	val_176
 333176	val_176
 33454	val_54
 33554	val_54
 336459	val_459
 337459	val_459
 33851	val_51
 33951	val_51
 340138	val_138
 341138	val_138
 342103	val_103
 343103	val_103
 344239	val_239
 345239	val_239
 346213	val_213
 347213	val_213
 348216	val_216
 349216	val_216
 350430	val_430
 351430	val_430
 352278	val_278
 353278	val_278
 354176	val_176
 355176	val_176
 356289	val_289
 357289	val_289
 358221	val_221
 359221	val_221
 36065	val_65
 36165	val_65
 362318	val_318
 363318	val_318
 364332	val_332
 365332	val_332
 366311	val_311
 367311	val_311
 368275	val_275
 369275	val_275
 370137	val_137
 371137	val_137
 372241	val_241
 373241	val_241
 37483	val_83
 37583	val_83
 376333	val_333
 377333	val_333
 378180	val_180
 379180	val_180
 380284	val_284
 381284	val_284
 38212	val_12
 38312	val_12
 384230	val_230
 385230	val_230
 386181	val_181
 387181	val_181
 38867	val_67
 38967	val_67
 390260	val_260
 391260	val_260
 392404	val_404
 393404	val_404
 394384	val_384
 395384	val_384
 396489	val_489
 397489	val_489
 398353	val_353
 399353	val_353
 400373	val_373
 401373	val_373
 402272	val_272
 403272	val_272
 404138	val_138
 405138	val_138
 406217	val_217
 407217	val_217
 40884	val_84
 40984	val_84
 410348	val_348
 411348	val_348
 412466	val_466
 413466	val_466
 41458	val_58
 41558	val_58
 4168	val_8
 4178	val_8
 418411	val_411
 419411	val_411
 420230	val_230
 421230	val_230
 422208	val_208
 423208	val_208
 424348	val_348
 425348	val_348
 42624	val_24
 42724	val_24
 428463	val_463
 429463	val_463
 430431	val_431
 431431	val_431
 432179	val_179
 433179	val_179
 434172	val_172
 435172	val_172
 43642	val_42
 43742	val_42
 438129	val_129
 439129	val_129
 440158	val_158
 441158	val_158
 442119	val_119
 443119	val_119
 444496	val_496
 445496	val_496
 4460	val_0
 4470	val_0
 448322	val_322
 449322	val_322
 450197	val_197
 451197	val_197
 452468	val_468
 453468	val_468
 454393	val_393
 455393	val_393
 456454	val_454
 457454	val_454
 458100	val_100
 459100	val_100
 460298	val_298
 461298	val_298
 462199	val_199
 463199	val_199
 464191	val_191
 465191	val_191
 466418	val_418
 467418	val_418
 46896	val_96
 46996	val_96
 47026	val_26
 47126	val_26
 472165	val_165
 473165	val_165
 474327	val_327
 475327	val_327
 476230	val_230
 477230	val_230
 478205	val_205
 479205	val_205
 480120	val_120
 481120	val_120
 482131	val_131
 483131	val_131
 48451	val_51
 48551	val_51
 486404	val_404
 487404	val_404
 48843	val_43
 48943	val_43
 490436	val_436
 491436	val_436
 492156	val_156
 493156	val_156
 494469	val_469
 495469	val_469
 496468	val_468
 497468	val_468
 498308	val_308
 499308	val_308
 50095	val_95
 50195	val_95
 502196	val_196
 503196	val_196
 504288	val_288
 505288	val_288
 506481	val_481
 507481	val_481
 508457	val_457
 509457	val_457
 51098	val_98
 51198	val_98
 512282	val_282
 513282	val_282
 514197	val_197
 515197	val_197
 516187	val_187
 517187	val_187
 518318	val_318
 519318	val_318
 520318	val_318
 521318	val_318
 522409	val_409
 523409	val_409
 524470	val_470
 525470	val_470
 526137	val_137
 527137	val_137
 528369	val_369
 529369	val_369
 530316	val_316
 531316	val_316
 532169	val_169
 533169	val_169
 534413	val_413
 535413	val_413
 53685	val_85
 53785	val_85
 53877	val_77
 53977	val_77
 5400	val_0
 5410	val_0
 542490	val_490
 543490	val_490
 54487	val_87
 54587	val_87
 546364	val_364
 547364	val_364
 548179	val_179
 549179	val_179
 550118	val_118
 551118	val_118
 552134	val_134
 553134	val_134
 554395	val_395
 555395	val_395
 556282	val_282
 557282	val_282
 558138	val_138
 559138	val_138
 560238	val_238
 561238	val_238
 562419	val_419
 563419	val_419
 56415	val_15
 56515	val_15
 566118	val_118
 567118	val_118
 56872	val_72
 56972	val_72
 57090	val_90
 57190	val_90
 572307	val_307
 573307	val_307
 57419	val_19
 57519	val_19
 576435	val_435
 577435	val_435
 57810	val_10
 57910	val_10
 580277	val_277
 581277	val_277
 582273	val_273
 583273	val_273
 584306	val_306
 585306	val_306
 586224	val_224
 587224	val_224
 588309	val_309
 589309	val_309
 590389	val_389
 591389	val_389
 592327	val_327
 593327	val_327
 594242	val_242
 595242	val_242
 596369	val_369
 597369	val_369
 598392	val_392
 599392	val_392
 600272	val_272
 601272	val_272
 602331	val_331
 603331	val_331
 604401	val_401
 605401	val_401
 606242	val_242
 607242	val_242
 608452	val_452
 609452	val_452
 610177	val_177
 611177	val_177
 612226	val_226
 613226	val_226
 6145	val_5
 6155	val_5
 616497	val_497
 617497	val_497
 618402	val_402
 619402	val_402
 620396	val_396
 621396	val_396
 622317	val_317
 623317	val_317
 624395	val_395
 625395	val_395
 62658	val_58
 62758	val_58
 62835	val_35
 62935	val_35
 630336	val_336
 631336	val_336
 63295	val_95
 63395	val_95
 63411	val_11
 63511	val_11
 636168	val_168
 637168	val_168
 63834	val_34
 63934	val_34
 640229	val_229
 641229	val_229
 642233	val_233
 643233	val_233
 644143	val_143
 645143	val_143
 646472	val_472
 647472	val_472
 648322	val_322
 649322	val_322
 650498	val_498
 651498	val_498
 652160	val_160
 653160	val_160
 654195	val_195
 655195	val_195
 65642	val_42
 65742	val_42
 658321	val_321
 659321	val_321
 660430	val_430
 661430	val_430
 662119	val_119
 663119	val_119
 664489	val_489
 665489	val_489
 666458	val_458
 667458	val_458
 66878	val_78
 66978	val_78
 67076	val_76
 67176	val_76
 67241	val_41
 67341	val_41
 674223	val_223
 675223	val_223
 676492	val_492
 677492	val_492
 678149	val_149
 679149	val_149
 680449	val_449
 681449	val_449
 682218	val_218
 683218	val_218
 684228	val_228
 685228	val_228
 686138	val_138
 687138	val_138
 688453	val_453
 689453	val_453
 69030	val_30
 69130	val_30
 692209	val_209
 693209	val_209
 69464	val_64
 69564	val_64
 696468	val_468
 697468	val_468
 69876	val_76
 69976	val_76
 70074	val_74
 70174	val_74
 702342	val_342
 703342	val_342
 70469	val_69
 70569	val_69
 706230	val_230
 707230	val_230
 70833	val_33
 70933	val_33
 710368	val_368
 711368	val_368
 712103	val_103
 713103	val_103
 714296	val_296
 715296	val_296
 716113	val_113
 717113	val_113
 718216	val_216
 719216	val_216
 720367	val_367
 721367	val_367
 722344	val_344
 723344	val_344
 724167	val_167
 725167	val_167
 726274	val_274
 727274	val_274
 728219	val_219
 729219	val_219
 730239	val_239
 731239	val_239
 732485	val_485
 733485	val_485
 734116	val_116
 735116	val_116
 736223	val_223
 737223	val_223
 738256	val_256
 739256	val_256
 740263	val_263
 741263	val_263
 74270	val_70
 74370	val_70
 744487	val_487
 745487	val_487
 746480	val_480
 747480	val_480
 748401	val_401
 749401	val_401
 750288	val_288
 751288	val_288
 752191	val_191
 753191	val_191
 7545	val_5
 7555	val_5
 756244	val_244
 757244	val_244
 758438	val_438
 759438	val_438
 760128	val_128
 761128	val_128
 762467	val_467
 763467	val_467
 764432	val_432
 765432	val_432
 766202	val_202
 767202	val_202
 768316	val_316
 769316	val_316
 770229	val_229
 771229	val_229
 772469	val_469
 773469	val_469
 774463	val_463
 775463	val_463
 776280	val_280
 777280	val_280
 7782	val_2
 7792	val_2
 78035	val_35
 78135	val_35
 782283	val_283
 783283	val_283
 784331	val_331
 785331	val_331
 786235	val_235
 787235	val_235
 78880	val_80
 78980	val_80
 79044	val_44
 79144	val_44
 792193	val_193
 793193	val_193
 794321	val_321
 795321	val_321
 796335	val_335
 797335	val_335
 798104	val_104
 799104	val_104
 800466	val_466
 801466	val_466
 802366	val_366
 803366	val_366
 804175	val_175
 805175	val_175
 806403	val_403
 807403	val_403
 808483	val_483
 809483	val_483
 81053	val_53
 81153	val_53
 812105	val_105
 813105	val_105
 814257	val_257
 815257	val_257
 816406	val_406
 817406	val_406
 818409	val_409
 819409	val_409
 820190	val_190
 821190	val_190
 822406	val_406
 823406	val_406
 824401	val_401
 825401	val_401
 826114	val_114
 827114	val_114
 828258	val_258
 829258	val_258
 83090	val_90
 83190	val_90
 832203	val_203
 833203	val_203
 834262	val_262
 835262	val_262
 836348	val_348
 837348	val_348
 838424	val_424
 839424	val_424
 84012	val_12
 84112	val_12
 842396	val_396
 843396	val_396
 844201	val_201
 845201	val_201
 846217	val_217
 847217	val_217
 848164	val_164
 849164	val_164
 850431	val_431
 851431	val_431
 852454	val_454
 853454	val_454
 854478	val_478
 855478	val_478
 856298	val_298
 857298	val_298
 858125	val_125
 859125	val_125
 860431	val_431
 861431	val_431
 862164	val_164
 863164	val_164
 864424	val_424
 865424	val_424
 866187	val_187
 867187	val_187
 868382	val_382
 869382	val_382
 8705	val_5
 8715	val_5
 87270	val_70
 87370	val_70
 874397	val_397
 875397	val_397
 876480	val_480
 877480	val_480
 878291	val_291
 879291	val_291
 88024	val_24
 88124	val_24
 882351	val_351
 883351	val_351
 884255	val_255
 885255	val_255
 886104	val_104
 887104	val_104
 88870	val_70
 88970	val_70
 890163	val_163
 891163	val_163
 892438	val_438
 893438	val_438
 894119	val_119
 895119	val_119
 896414	val_414
 897414	val_414
 898200	val_200
 899200	val_200
 900491	val_491
 901491	val_491
 902237	val_237
 903237	val_237
 904439	val_439
 905439	val_439
 906360	val_360
 907360	val_360
 908248	val_248
 909248	val_248
 910479	val_479
 911479	val_479
 912305	val_305
 913305	val_305
 914417	val_417
 915417	val_417
 916199	val_199
 917199	val_199
 918444	val_444
 919444	val_444
 920120	val_120
 921120	val_120
 922429	val_429
 923429	val_429
 924169	val_169
 925169	val_169
 926443	val_443
 927443	val_443
 928323	val_323
 929323	val_323
 930325	val_325
 931325	val_325
 932277	val_277
 933277	val_277
 934230	val_230
 935230	val_230
 936478	val_478
 937478	val_478
 938178	val_178
 939178	val_178
 940468	val_468
 941468	val_468
 942310	val_310
 943310	val_310
 944317	val_317
 945317	val_317
 946333	val_333
 947333	val_333
 948493	val_493
 949493	val_493
 950460	val_460
 951460	val_460
 952207	val_207
 953207	val_207
 954249	val_249
 955249	val_249
 956265	val_265
 957265	val_265
 958480	val_480
 959480	val_480
 96083	val_83
 96183	val_83
 962136	val_136
 963136	val_136
 964353	val_353
 965353	val_353
 966172	val_172
 967172	val_172
 968214	val_214
 969214	val_214
 970462	val_462
 971462	val_462
 972233	val_233
 973233	val_233
 974406	val_406
 975406	val_406
 976133	val_133
 977133	val_133
 978175	val_175
 979175	val_175
 980189	val_189
 981189	val_189
 982454	val_454
 983454	val_454
 984375	val_375
 985375	val_375
 986401	val_401
 987401	val_401
 988421	val_421
 989421	val_421
 990407	val_407
 991407	val_407
 992384	val_384
 993384	val_384
 994256	val_256
 995256	val_256
 99626	val_26
 99726	val_26
 998134	val_134
 999134	val_134
100067	val_67
100167	val_67
1002384	val_384
1003384	val_384
1004379	val_379
1005379	val_379
100618	val_18
100718	val_18
1008462	val_462
1009462	val_462
1010492	val_492
1011492	val_492
1012100	val_100
1013100	val_100
1014298	val_298
1015298	val_298
10169	val_9
10179	val_9
1018341	val_341
1019341	val_341
1020498	val_498
1021498	val_498
1022146	val_146
1023146	val_146
1024458	val_458
1025458	val_458
1026362	val_362
1027362	val_362
1028186	val_186
1029186	val_186
1030285	val_285
1031285	val_285
1032348	val_348
1033348	val_348
1034167	val_167
1035167	val_167
103618	val_18
103718	val_18
1038273	val_273
1039273	val_273
1040183	val_183
1041183	val_183
1042281	val_281
1043281	val_281
1044344	val_344
1045344	val_344
104697	val_97
104797	val_97
1048469	val_469
1049469	val_469
1050315	val_315
1051315	val_315
105284	val_84
105384	val_84
105428	val_28
105528	val_28
105637	val_37
105737	val_37
1058448	val_448
1059448	val_448
1060152	val_152
1061152	val_152
1062348	val_348
1063348	val_348
1064307	val_307
1065307	val_307
1066194	val_194
1067194	val_194
1068414	val_414
1069414	val_414
1070477	val_477
1071477	val_477
1072222	val_222
1073222	val_222
1074126	val_126
1075126	val_126
107690	val_90
107790	val_90
1078169	val_169
1079169	val_169
1080403	val_403
1081403	val_403
1082400	val_400
1083400	val_400
1084200	val_200
1085200	val_200
108697	val_97
108797	val_97