You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by zs...@apache.org on 2009/04/16 22:41:10 UTC
svn commit: r765753 [2/5] - in /hadoop/hive/branches/branch-0.3: ./
ql/src/java/org/apache/hadoop/hive/ql/optimizer/
ql/src/java/org/apache/hadoop/hive/ql/parse/
ql/src/java/org/apache/hadoop/hive/ql/plan/
ql/src/test/org/apache/hadoop/hive/ql/exec/ ql...
Added: hadoop/hive/branches/branch-0.3/ql/src/test/results/clientpositive/union18.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/branches/branch-0.3/ql/src/test/results/clientpositive/union18.q.out?rev=765753&view=auto
==============================================================================
--- hadoop/hive/branches/branch-0.3/ql/src/test/results/clientpositive/union18.q.out (added)
+++ hadoop/hive/branches/branch-0.3/ql/src/test/results/clientpositive/union18.q.out Thu Apr 16 20:41:08 2009
@@ -0,0 +1,1151 @@
+ABSTRACT SYNTAX TREE:
+ (TOK_QUERY (TOK_FROM (TOK_SUBQUERY (TOK_UNION (TOK_QUERY (TOK_FROM (TOK_TABREF src s1)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR 'tst1' key) (TOK_SELEXPR (TOK_FUNCTION TOK_STRING (TOK_FUNCTION count 1)) value)))) (TOK_QUERY (TOK_FROM (TOK_TABREF src s2)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_COLREF s2 key) key) (TOK_SELEXPR (TOK_COLREF s2 value) value))))) unionsrc)) (TOK_INSERT (TOK_DESTINATION (TOK_TAB DEST1)) (TOK_SELECT (TOK_SELEXPR (TOK_COLREF unionsrc key)) (TOK_SELEXPR (TOK_COLREF unionsrc value)))) (TOK_INSERT (TOK_DESTINATION (TOK_TAB DEST2)) (TOK_SELECT (TOK_SELEXPR (TOK_COLREF unionsrc key)) (TOK_SELEXPR (TOK_COLREF unionsrc value)) (TOK_SELEXPR (TOK_COLREF unionsrc value)))))
+
+STAGE DEPENDENCIES:
+ Stage-1 is a root stage
+ Stage-2 depends on stages: Stage-1, Stage-3
+ Stage-0 depends on stages: Stage-2
+ Stage-3 is a root stage
+ Stage-2 depends on stages: Stage-1, Stage-3
+ Stage-0 depends on stages: Stage-2
+
+STAGE PLANS:
+ Stage: Stage-1
+ Map Reduce
+ Alias -> Map Operator Tree:
+ null-subquery1:unionsrc-subquery1:s1
+ Select Operator
+ Group By Operator
+ aggregations:
+ expr: count(1)
+ mode: hash
+ Reduce Output Operator
+ sort order:
+ tag: -1
+ value expressions:
+ expr: 0
+ type: bigint
+ Reduce Operator Tree:
+ Group By Operator
+ aggregations:
+ expr: count(VALUE.0)
+ mode: mergepartial
+ Select Operator
+ expressions:
+ expr: 'tst1'
+ type: string
+ expr: UDFToString(0)
+ type: string
+ File Output Operator
+ compressed: false
+ GlobalTableId: 0
+ table:
+ input format: org.apache.hadoop.mapred.SequenceFileInputFormat
+ output format: org.apache.hadoop.mapred.SequenceFileOutputFormat
+ name: binary_table
+
+ Stage: Stage-2
+ Map Reduce
+ Alias -> Map Operator Tree:
+ /data/users/njain/hive_branch3/hive_br3/build/ql/tmp/289486505/58468022.10005
+ Union
+ Select Operator
+ expressions:
+ expr: 0
+ type: string
+ expr: 1
+ type: string
+ File Output Operator
+ compressed: false
+ GlobalTableId: 1
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ name: dest1
+ Select Operator
+ expressions:
+ expr: 0
+ type: string
+ expr: 1
+ type: string
+ expr: 1
+ type: string
+ File Output Operator
+ compressed: false
+ GlobalTableId: 2
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ name: dest2
+ /data/users/njain/hive_branch3/hive_br3/build/ql/tmp/289486505/58468022.10004
+ Union
+ Select Operator
+ expressions:
+ expr: 0
+ type: string
+ expr: 1
+ type: string
+ File Output Operator
+ compressed: false
+ GlobalTableId: 1
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ name: dest1
+ Select Operator
+ expressions:
+ expr: 0
+ type: string
+ expr: 1
+ type: string
+ expr: 1
+ type: string
+ File Output Operator
+ compressed: false
+ GlobalTableId: 2
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ name: dest2
+
+ Stage: Stage-0
+ Move Operator
+ tables:
+ replace: true
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ name: dest1
+ replace: true
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ name: dest2
+
+ Stage: Stage-3
+ Map Reduce
+ Alias -> Map Operator Tree:
+ null-subquery2:unionsrc-subquery2:s2
+ Select Operator
+ expressions:
+ expr: key
+ type: string
+ expr: value
+ type: string
+ File Output Operator
+ compressed: false
+ GlobalTableId: 0
+ table:
+ input format: org.apache.hadoop.mapred.SequenceFileInputFormat
+ output format: org.apache.hadoop.mapred.SequenceFileOutputFormat
+ name: binary_table
+
+
+tst1 500
+238 val_238
+86 val_86
+311 val_311
+27 val_27
+165 val_165
+409 val_409
+255 val_255
+278 val_278
+98 val_98
+484 val_484
+265 val_265
+193 val_193
+401 val_401
+150 val_150
+273 val_273
+224 val_224
+369 val_369
+66 val_66
+128 val_128
+213 val_213
+146 val_146
+406 val_406
+429 val_429
+374 val_374
+152 val_152
+469 val_469
+145 val_145
+495 val_495
+37 val_37
+327 val_327
+281 val_281
+277 val_277
+209 val_209
+15 val_15
+82 val_82
+403 val_403
+166 val_166
+417 val_417
+430 val_430
+252 val_252
+292 val_292
+219 val_219
+287 val_287
+153 val_153
+193 val_193
+338 val_338
+446 val_446
+459 val_459
+394 val_394
+237 val_237
+482 val_482
+174 val_174
+413 val_413
+494 val_494
+207 val_207
+199 val_199
+466 val_466
+208 val_208
+174 val_174
+399 val_399
+396 val_396
+247 val_247
+417 val_417
+489 val_489
+162 val_162
+377 val_377
+397 val_397
+309 val_309
+365 val_365
+266 val_266
+439 val_439
+342 val_342
+367 val_367
+325 val_325
+167 val_167
+195 val_195
+475 val_475
+17 val_17
+113 val_113
+155 val_155
+203 val_203
+339 val_339
+0 val_0
+455 val_455
+128 val_128
+311 val_311
+316 val_316
+57 val_57
+302 val_302
+205 val_205
+149 val_149
+438 val_438
+345 val_345
+129 val_129
+170 val_170
+20 val_20
+489 val_489
+157 val_157
+378 val_378
+221 val_221
+92 val_92
+111 val_111
+47 val_47
+72 val_72
+4 val_4
+280 val_280
+35 val_35
+427 val_427
+277 val_277
+208 val_208
+356 val_356
+399 val_399
+169 val_169
+382 val_382
+498 val_498
+125 val_125
+386 val_386
+437 val_437
+469 val_469
+192 val_192
+286 val_286
+187 val_187
+176 val_176
+54 val_54
+459 val_459
+51 val_51
+138 val_138
+103 val_103
+239 val_239
+213 val_213
+216 val_216
+430 val_430
+278 val_278
+176 val_176
+289 val_289
+221 val_221
+65 val_65
+318 val_318
+332 val_332
+311 val_311
+275 val_275
+137 val_137
+241 val_241
+83 val_83
+333 val_333
+180 val_180
+284 val_284
+12 val_12
+230 val_230
+181 val_181
+67 val_67
+260 val_260
+404 val_404
+384 val_384
+489 val_489
+353 val_353
+373 val_373
+272 val_272
+138 val_138
+217 val_217
+84 val_84
+348 val_348
+466 val_466
+58 val_58
+8 val_8
+411 val_411
+230 val_230
+208 val_208
+348 val_348
+24 val_24
+463 val_463
+431 val_431
+179 val_179
+172 val_172
+42 val_42
+129 val_129
+158 val_158
+119 val_119
+496 val_496
+0 val_0
+322 val_322
+197 val_197
+468 val_468
+393 val_393
+454 val_454
+100 val_100
+298 val_298
+199 val_199
+191 val_191
+418 val_418
+96 val_96
+26 val_26
+165 val_165
+327 val_327
+230 val_230
+205 val_205
+120 val_120
+131 val_131
+51 val_51
+404 val_404
+43 val_43
+436 val_436
+156 val_156
+469 val_469
+468 val_468
+308 val_308
+95 val_95
+196 val_196
+288 val_288
+481 val_481
+457 val_457
+98 val_98
+282 val_282
+197 val_197
+187 val_187
+318 val_318
+318 val_318
+409 val_409
+470 val_470
+137 val_137
+369 val_369
+316 val_316
+169 val_169
+413 val_413
+85 val_85
+77 val_77
+0 val_0
+490 val_490
+87 val_87
+364 val_364
+179 val_179
+118 val_118
+134 val_134
+395 val_395
+282 val_282
+138 val_138
+238 val_238
+419 val_419
+15 val_15
+118 val_118
+72 val_72
+90 val_90
+307 val_307
+19 val_19
+435 val_435
+10 val_10
+277 val_277
+273 val_273
+306 val_306
+224 val_224
+309 val_309
+389 val_389
+327 val_327
+242 val_242
+369 val_369
+392 val_392
+272 val_272
+331 val_331
+401 val_401
+242 val_242
+452 val_452
+177 val_177
+226 val_226
+5 val_5
+497 val_497
+402 val_402
+396 val_396
+317 val_317
+395 val_395
+58 val_58
+35 val_35
+336 val_336
+95 val_95
+11 val_11
+168 val_168
+34 val_34
+229 val_229
+233 val_233
+143 val_143
+472 val_472
+322 val_322
+498 val_498
+160 val_160
+195 val_195
+42 val_42
+321 val_321
+430 val_430
+119 val_119
+489 val_489
+458 val_458
+78 val_78
+76 val_76
+41 val_41
+223 val_223
+492 val_492
+149 val_149
+449 val_449
+218 val_218
+228 val_228
+138 val_138
+453 val_453
+30 val_30
+209 val_209
+64 val_64
+468 val_468
+76 val_76
+74 val_74
+342 val_342
+69 val_69
+230 val_230
+33 val_33
+368 val_368
+103 val_103
+296 val_296
+113 val_113
+216 val_216
+367 val_367
+344 val_344
+167 val_167
+274 val_274
+219 val_219
+239 val_239
+485 val_485
+116 val_116
+223 val_223
+256 val_256
+263 val_263
+70 val_70
+487 val_487
+480 val_480
+401 val_401
+288 val_288
+191 val_191
+5 val_5
+244 val_244
+438 val_438
+128 val_128
+467 val_467
+432 val_432
+202 val_202
+316 val_316
+229 val_229
+469 val_469
+463 val_463
+280 val_280
+2 val_2
+35 val_35
+283 val_283
+331 val_331
+235 val_235
+80 val_80
+44 val_44
+193 val_193
+321 val_321
+335 val_335
+104 val_104
+466 val_466
+366 val_366
+175 val_175
+403 val_403
+483 val_483
+53 val_53
+105 val_105
+257 val_257
+406 val_406
+409 val_409
+190 val_190
+406 val_406
+401 val_401
+114 val_114
+258 val_258
+90 val_90
+203 val_203
+262 val_262
+348 val_348
+424 val_424
+12 val_12
+396 val_396
+201 val_201
+217 val_217
+164 val_164
+431 val_431
+454 val_454
+478 val_478
+298 val_298
+125 val_125
+431 val_431
+164 val_164
+424 val_424
+187 val_187
+382 val_382
+5 val_5
+70 val_70
+397 val_397
+480 val_480
+291 val_291
+24 val_24
+351 val_351
+255 val_255
+104 val_104
+70 val_70
+163 val_163
+438 val_438
+119 val_119
+414 val_414
+200 val_200
+491 val_491
+237 val_237
+439 val_439
+360 val_360
+248 val_248
+479 val_479
+305 val_305
+417 val_417
+199 val_199
+444 val_444
+120 val_120
+429 val_429
+169 val_169
+443 val_443
+323 val_323
+325 val_325
+277 val_277
+230 val_230
+478 val_478
+178 val_178
+468 val_468
+310 val_310
+317 val_317
+333 val_333
+493 val_493
+460 val_460
+207 val_207
+249 val_249
+265 val_265
+480 val_480
+83 val_83
+136 val_136
+353 val_353
+172 val_172
+214 val_214
+462 val_462
+233 val_233
+406 val_406
+133 val_133
+175 val_175
+189 val_189
+454 val_454
+375 val_375
+401 val_401
+421 val_421
+407 val_407
+384 val_384
+256 val_256
+26 val_26
+134 val_134
+67 val_67
+384 val_384
+379 val_379
+18 val_18
+462 val_462
+492 val_492
+100 val_100
+298 val_298
+9 val_9
+341 val_341
+498 val_498
+146 val_146
+458 val_458
+362 val_362
+186 val_186
+285 val_285
+348 val_348
+167 val_167
+18 val_18
+273 val_273
+183 val_183
+281 val_281
+344 val_344
+97 val_97
+469 val_469
+315 val_315
+84 val_84
+28 val_28
+37 val_37
+448 val_448
+152 val_152
+348 val_348
+307 val_307
+194 val_194
+414 val_414
+477 val_477
+222 val_222
+126 val_126
+90 val_90
+169 val_169
+403 val_403
+400 val_400
+200 val_200
+97 val_97
+tst1 500 500
+238 val_238 val_238
+86 val_86 val_86
+311 val_311 val_311
+27 val_27 val_27
+165 val_165 val_165
+409 val_409 val_409
+255 val_255 val_255
+278 val_278 val_278
+98 val_98 val_98
+484 val_484 val_484
+265 val_265 val_265
+193 val_193 val_193
+401 val_401 val_401
+150 val_150 val_150
+273 val_273 val_273
+224 val_224 val_224
+369 val_369 val_369
+66 val_66 val_66
+128 val_128 val_128
+213 val_213 val_213
+146 val_146 val_146
+406 val_406 val_406
+429 val_429 val_429
+374 val_374 val_374
+152 val_152 val_152
+469 val_469 val_469
+145 val_145 val_145
+495 val_495 val_495
+37 val_37 val_37
+327 val_327 val_327
+281 val_281 val_281
+277 val_277 val_277
+209 val_209 val_209
+15 val_15 val_15
+82 val_82 val_82
+403 val_403 val_403
+166 val_166 val_166
+417 val_417 val_417
+430 val_430 val_430
+252 val_252 val_252
+292 val_292 val_292
+219 val_219 val_219
+287 val_287 val_287
+153 val_153 val_153
+193 val_193 val_193
+338 val_338 val_338
+446 val_446 val_446
+459 val_459 val_459
+394 val_394 val_394
+237 val_237 val_237
+482 val_482 val_482
+174 val_174 val_174
+413 val_413 val_413
+494 val_494 val_494
+207 val_207 val_207
+199 val_199 val_199
+466 val_466 val_466
+208 val_208 val_208
+174 val_174 val_174
+399 val_399 val_399
+396 val_396 val_396
+247 val_247 val_247
+417 val_417 val_417
+489 val_489 val_489
+162 val_162 val_162
+377 val_377 val_377
+397 val_397 val_397
+309 val_309 val_309
+365 val_365 val_365
+266 val_266 val_266
+439 val_439 val_439
+342 val_342 val_342
+367 val_367 val_367
+325 val_325 val_325
+167 val_167 val_167
+195 val_195 val_195
+475 val_475 val_475
+17 val_17 val_17
+113 val_113 val_113
+155 val_155 val_155
+203 val_203 val_203
+339 val_339 val_339
+0 val_0 val_0
+455 val_455 val_455
+128 val_128 val_128
+311 val_311 val_311
+316 val_316 val_316
+57 val_57 val_57
+302 val_302 val_302
+205 val_205 val_205
+149 val_149 val_149
+438 val_438 val_438
+345 val_345 val_345
+129 val_129 val_129
+170 val_170 val_170
+20 val_20 val_20
+489 val_489 val_489
+157 val_157 val_157
+378 val_378 val_378
+221 val_221 val_221
+92 val_92 val_92
+111 val_111 val_111
+47 val_47 val_47
+72 val_72 val_72
+4 val_4 val_4
+280 val_280 val_280
+35 val_35 val_35
+427 val_427 val_427
+277 val_277 val_277
+208 val_208 val_208
+356 val_356 val_356
+399 val_399 val_399
+169 val_169 val_169
+382 val_382 val_382
+498 val_498 val_498
+125 val_125 val_125
+386 val_386 val_386
+437 val_437 val_437
+469 val_469 val_469
+192 val_192 val_192
+286 val_286 val_286
+187 val_187 val_187
+176 val_176 val_176
+54 val_54 val_54
+459 val_459 val_459
+51 val_51 val_51
+138 val_138 val_138
+103 val_103 val_103
+239 val_239 val_239
+213 val_213 val_213
+216 val_216 val_216
+430 val_430 val_430
+278 val_278 val_278
+176 val_176 val_176
+289 val_289 val_289
+221 val_221 val_221
+65 val_65 val_65
+318 val_318 val_318
+332 val_332 val_332
+311 val_311 val_311
+275 val_275 val_275
+137 val_137 val_137
+241 val_241 val_241
+83 val_83 val_83
+333 val_333 val_333
+180 val_180 val_180
+284 val_284 val_284
+12 val_12 val_12
+230 val_230 val_230
+181 val_181 val_181
+67 val_67 val_67
+260 val_260 val_260
+404 val_404 val_404
+384 val_384 val_384
+489 val_489 val_489
+353 val_353 val_353
+373 val_373 val_373
+272 val_272 val_272
+138 val_138 val_138
+217 val_217 val_217
+84 val_84 val_84
+348 val_348 val_348
+466 val_466 val_466
+58 val_58 val_58
+8 val_8 val_8
+411 val_411 val_411
+230 val_230 val_230
+208 val_208 val_208
+348 val_348 val_348
+24 val_24 val_24
+463 val_463 val_463
+431 val_431 val_431
+179 val_179 val_179
+172 val_172 val_172
+42 val_42 val_42
+129 val_129 val_129
+158 val_158 val_158
+119 val_119 val_119
+496 val_496 val_496
+0 val_0 val_0
+322 val_322 val_322
+197 val_197 val_197
+468 val_468 val_468
+393 val_393 val_393
+454 val_454 val_454
+100 val_100 val_100
+298 val_298 val_298
+199 val_199 val_199
+191 val_191 val_191
+418 val_418 val_418
+96 val_96 val_96
+26 val_26 val_26
+165 val_165 val_165
+327 val_327 val_327
+230 val_230 val_230
+205 val_205 val_205
+120 val_120 val_120
+131 val_131 val_131
+51 val_51 val_51
+404 val_404 val_404
+43 val_43 val_43
+436 val_436 val_436
+156 val_156 val_156
+469 val_469 val_469
+468 val_468 val_468
+308 val_308 val_308
+95 val_95 val_95
+196 val_196 val_196
+288 val_288 val_288
+481 val_481 val_481
+457 val_457 val_457
+98 val_98 val_98
+282 val_282 val_282
+197 val_197 val_197
+187 val_187 val_187
+318 val_318 val_318
+318 val_318 val_318
+409 val_409 val_409
+470 val_470 val_470
+137 val_137 val_137
+369 val_369 val_369
+316 val_316 val_316
+169 val_169 val_169
+413 val_413 val_413
+85 val_85 val_85
+77 val_77 val_77
+0 val_0 val_0
+490 val_490 val_490
+87 val_87 val_87
+364 val_364 val_364
+179 val_179 val_179
+118 val_118 val_118
+134 val_134 val_134
+395 val_395 val_395
+282 val_282 val_282
+138 val_138 val_138
+238 val_238 val_238
+419 val_419 val_419
+15 val_15 val_15
+118 val_118 val_118
+72 val_72 val_72
+90 val_90 val_90
+307 val_307 val_307
+19 val_19 val_19
+435 val_435 val_435
+10 val_10 val_10
+277 val_277 val_277
+273 val_273 val_273
+306 val_306 val_306
+224 val_224 val_224
+309 val_309 val_309
+389 val_389 val_389
+327 val_327 val_327
+242 val_242 val_242
+369 val_369 val_369
+392 val_392 val_392
+272 val_272 val_272
+331 val_331 val_331
+401 val_401 val_401
+242 val_242 val_242
+452 val_452 val_452
+177 val_177 val_177
+226 val_226 val_226
+5 val_5 val_5
+497 val_497 val_497
+402 val_402 val_402
+396 val_396 val_396
+317 val_317 val_317
+395 val_395 val_395
+58 val_58 val_58
+35 val_35 val_35
+336 val_336 val_336
+95 val_95 val_95
+11 val_11 val_11
+168 val_168 val_168
+34 val_34 val_34
+229 val_229 val_229
+233 val_233 val_233
+143 val_143 val_143
+472 val_472 val_472
+322 val_322 val_322
+498 val_498 val_498
+160 val_160 val_160
+195 val_195 val_195
+42 val_42 val_42
+321 val_321 val_321
+430 val_430 val_430
+119 val_119 val_119
+489 val_489 val_489
+458 val_458 val_458
+78 val_78 val_78
+76 val_76 val_76
+41 val_41 val_41
+223 val_223 val_223
+492 val_492 val_492
+149 val_149 val_149
+449 val_449 val_449
+218 val_218 val_218
+228 val_228 val_228
+138 val_138 val_138
+453 val_453 val_453
+30 val_30 val_30
+209 val_209 val_209
+64 val_64 val_64
+468 val_468 val_468
+76 val_76 val_76
+74 val_74 val_74
+342 val_342 val_342
+69 val_69 val_69
+230 val_230 val_230
+33 val_33 val_33
+368 val_368 val_368
+103 val_103 val_103
+296 val_296 val_296
+113 val_113 val_113
+216 val_216 val_216
+367 val_367 val_367
+344 val_344 val_344
+167 val_167 val_167
+274 val_274 val_274
+219 val_219 val_219
+239 val_239 val_239
+485 val_485 val_485
+116 val_116 val_116
+223 val_223 val_223
+256 val_256 val_256
+263 val_263 val_263
+70 val_70 val_70
+487 val_487 val_487
+480 val_480 val_480
+401 val_401 val_401
+288 val_288 val_288
+191 val_191 val_191
+5 val_5 val_5
+244 val_244 val_244
+438 val_438 val_438
+128 val_128 val_128
+467 val_467 val_467
+432 val_432 val_432
+202 val_202 val_202
+316 val_316 val_316
+229 val_229 val_229
+469 val_469 val_469
+463 val_463 val_463
+280 val_280 val_280
+2 val_2 val_2
+35 val_35 val_35
+283 val_283 val_283
+331 val_331 val_331
+235 val_235 val_235
+80 val_80 val_80
+44 val_44 val_44
+193 val_193 val_193
+321 val_321 val_321
+335 val_335 val_335
+104 val_104 val_104
+466 val_466 val_466
+366 val_366 val_366
+175 val_175 val_175
+403 val_403 val_403
+483 val_483 val_483
+53 val_53 val_53
+105 val_105 val_105
+257 val_257 val_257
+406 val_406 val_406
+409 val_409 val_409
+190 val_190 val_190
+406 val_406 val_406
+401 val_401 val_401
+114 val_114 val_114
+258 val_258 val_258
+90 val_90 val_90
+203 val_203 val_203
+262 val_262 val_262
+348 val_348 val_348
+424 val_424 val_424
+12 val_12 val_12
+396 val_396 val_396
+201 val_201 val_201
+217 val_217 val_217
+164 val_164 val_164
+431 val_431 val_431
+454 val_454 val_454
+478 val_478 val_478
+298 val_298 val_298
+125 val_125 val_125
+431 val_431 val_431
+164 val_164 val_164
+424 val_424 val_424
+187 val_187 val_187
+382 val_382 val_382
+5 val_5 val_5
+70 val_70 val_70
+397 val_397 val_397
+480 val_480 val_480
+291 val_291 val_291
+24 val_24 val_24
+351 val_351 val_351
+255 val_255 val_255
+104 val_104 val_104
+70 val_70 val_70
+163 val_163 val_163
+438 val_438 val_438
+119 val_119 val_119
+414 val_414 val_414
+200 val_200 val_200
+491 val_491 val_491
+237 val_237 val_237
+439 val_439 val_439
+360 val_360 val_360
+248 val_248 val_248
+479 val_479 val_479
+305 val_305 val_305
+417 val_417 val_417
+199 val_199 val_199
+444 val_444 val_444
+120 val_120 val_120
+429 val_429 val_429
+169 val_169 val_169
+443 val_443 val_443
+323 val_323 val_323
+325 val_325 val_325
+277 val_277 val_277
+230 val_230 val_230
+478 val_478 val_478
+178 val_178 val_178
+468 val_468 val_468
+310 val_310 val_310
+317 val_317 val_317
+333 val_333 val_333
+493 val_493 val_493
+460 val_460 val_460
+207 val_207 val_207
+249 val_249 val_249
+265 val_265 val_265
+480 val_480 val_480
+83 val_83 val_83
+136 val_136 val_136
+353 val_353 val_353
+172 val_172 val_172
+214 val_214 val_214
+462 val_462 val_462
+233 val_233 val_233
+406 val_406 val_406
+133 val_133 val_133
+175 val_175 val_175
+189 val_189 val_189
+454 val_454 val_454
+375 val_375 val_375
+401 val_401 val_401
+421 val_421 val_421
+407 val_407 val_407
+384 val_384 val_384
+256 val_256 val_256
+26 val_26 val_26
+134 val_134 val_134
+67 val_67 val_67
+384 val_384 val_384
+379 val_379 val_379
+18 val_18 val_18
+462 val_462 val_462
+492 val_492 val_492
+100 val_100 val_100
+298 val_298 val_298
+9 val_9 val_9
+341 val_341 val_341
+498 val_498 val_498
+146 val_146 val_146
+458 val_458 val_458
+362 val_362 val_362
+186 val_186 val_186
+285 val_285 val_285
+348 val_348 val_348
+167 val_167 val_167
+18 val_18 val_18
+273 val_273 val_273
+183 val_183 val_183
+281 val_281 val_281
+344 val_344 val_344
+97 val_97 val_97
+469 val_469 val_469
+315 val_315 val_315
+84 val_84 val_84
+28 val_28 val_28
+37 val_37 val_37
+448 val_448 val_448
+152 val_152 val_152
+348 val_348 val_348
+307 val_307 val_307
+194 val_194 val_194
+414 val_414 val_414
+477 val_477 val_477
+222 val_222 val_222
+126 val_126 val_126
+90 val_90 val_90
+169 val_169 val_169
+403 val_403 val_403
+400 val_400 val_400
+200 val_200 val_200
+97 val_97 val_97
Added: hadoop/hive/branches/branch-0.3/ql/src/test/results/clientpositive/union19.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/branches/branch-0.3/ql/src/test/results/clientpositive/union19.q.out?rev=765753&view=auto
==============================================================================
--- hadoop/hive/branches/branch-0.3/ql/src/test/results/clientpositive/union19.q.out (added)
+++ hadoop/hive/branches/branch-0.3/ql/src/test/results/clientpositive/union19.q.out Thu Apr 16 20:41:08 2009
@@ -0,0 +1,992 @@
+ABSTRACT SYNTAX TREE:
+ (TOK_QUERY (TOK_FROM (TOK_SUBQUERY (TOK_UNION (TOK_QUERY (TOK_FROM (TOK_TABREF src s1)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR 'tst1' key) (TOK_SELEXPR (TOK_FUNCTION TOK_STRING (TOK_FUNCTION count 1)) value)))) (TOK_QUERY (TOK_FROM (TOK_TABREF src s2)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_COLREF s2 key) key) (TOK_SELEXPR (TOK_COLREF s2 value) value))))) unionsrc)) (TOK_INSERT (TOK_DESTINATION (TOK_TAB DEST1)) (TOK_SELECT (TOK_SELEXPR (TOK_COLREF unionsrc key)) (TOK_SELEXPR (TOK_FUNCTION count (TOK_COLREF unionsrc value)))) (TOK_GROUPBY (TOK_COLREF unionsrc key))) (TOK_INSERT (TOK_DESTINATION (TOK_TAB DEST2)) (TOK_SELECT (TOK_SELEXPR (TOK_COLREF unionsrc key)) (TOK_SELEXPR (TOK_COLREF unionsrc value)) (TOK_SELEXPR (TOK_COLREF unionsrc value)))))
+
+STAGE DEPENDENCIES:
+ Stage-1 is a root stage
+ Stage-2 depends on stages: Stage-1, Stage-3
+ Stage-0 depends on stages: Stage-2
+ Stage-3 is a root stage
+ Stage-2 depends on stages: Stage-1, Stage-3
+ Stage-0 depends on stages: Stage-2
+
+STAGE PLANS:
+ Stage: Stage-1
+ Map Reduce
+ Alias -> Map Operator Tree:
+ null-subquery1:unionsrc-subquery1:s1
+ Select Operator
+ Group By Operator
+ aggregations:
+ expr: count(1)
+ mode: hash
+ Reduce Output Operator
+ sort order:
+ tag: -1
+ value expressions:
+ expr: 0
+ type: bigint
+ Reduce Operator Tree:
+ Group By Operator
+ aggregations:
+ expr: count(VALUE.0)
+ mode: mergepartial
+ Select Operator
+ expressions:
+ expr: 'tst1'
+ type: string
+ expr: UDFToString(0)
+ type: string
+ File Output Operator
+ compressed: false
+ GlobalTableId: 0
+ table:
+ input format: org.apache.hadoop.mapred.SequenceFileInputFormat
+ output format: org.apache.hadoop.mapred.SequenceFileOutputFormat
+ name: binary_table
+
+ Stage: Stage-2
+ Map Reduce
+ Alias -> Map Operator Tree:
+ /data/users/njain/hive_branch3/hive_br3/build/ql/tmp/116745759/981364196.10005
+ Union
+ Group By Operator
+ aggregations:
+ expr: count(1)
+ keys:
+ expr: 0
+ type: string
+ mode: hash
+ Reduce Output Operator
+ key expressions:
+ expr: 0
+ type: string
+ sort order: +
+ Map-reduce partition columns:
+ expr: 0
+ type: string
+ tag: -1
+ value expressions:
+ expr: 1
+ type: bigint
+ Select Operator
+ expressions:
+ expr: 0
+ type: string
+ expr: 1
+ type: string
+ expr: 1
+ type: string
+ File Output Operator
+ compressed: false
+ GlobalTableId: 2
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ name: dest2
+ /data/users/njain/hive_branch3/hive_br3/build/ql/tmp/116745759/981364196.10004
+ Union
+ Group By Operator
+ aggregations:
+ expr: count(1)
+ keys:
+ expr: 0
+ type: string
+ mode: hash
+ Reduce Output Operator
+ key expressions:
+ expr: 0
+ type: string
+ sort order: +
+ Map-reduce partition columns:
+ expr: 0
+ type: string
+ tag: -1
+ value expressions:
+ expr: 1
+ type: bigint
+ Select Operator
+ expressions:
+ expr: 0
+ type: string
+ expr: 1
+ type: string
+ expr: 1
+ type: string
+ File Output Operator
+ compressed: false
+ GlobalTableId: 2
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ name: dest2
+ Reduce Operator Tree:
+ Group By Operator
+ aggregations:
+ expr: count(VALUE.0)
+ keys:
+ expr: KEY.0
+ type: string
+ mode: mergepartial
+ Select Operator
+ expressions:
+ expr: 0
+ type: string
+ expr: 1
+ type: bigint
+ File Output Operator
+ compressed: false
+ GlobalTableId: 1
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ name: dest1
+
+ Stage: Stage-0
+ Move Operator
+ tables:
+ replace: true
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ name: dest1
+ replace: true
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ name: dest2
+
+ Stage: Stage-3
+ Map Reduce
+ Alias -> Map Operator Tree:
+ null-subquery2:unionsrc-subquery2:s2
+ Select Operator
+ expressions:
+ expr: key
+ type: string
+ expr: value
+ type: string
+ File Output Operator
+ compressed: false
+ GlobalTableId: 0
+ table:
+ input format: org.apache.hadoop.mapred.SequenceFileInputFormat
+ output format: org.apache.hadoop.mapred.SequenceFileOutputFormat
+ name: binary_table
+
+
+0 3
+10 1
+100 2
+103 2
+104 2
+105 1
+11 1
+111 1
+113 2
+114 1
+116 1
+118 2
+119 3
+12 2
+120 2
+125 2
+126 1
+128 3
+129 2
+131 1
+133 1
+134 2
+136 1
+137 2
+138 4
+143 1
+145 1
+146 2
+149 2
+15 2
+150 1
+152 2
+153 1
+155 1
+156 1
+157 1
+158 1
+160 1
+162 1
+163 1
+164 2
+165 2
+166 1
+167 3
+168 1
+169 4
+17 1
+170 1
+172 2
+174 2
+175 2
+176 2
+177 1
+178 1
+179 2
+18 2
+180 1
+181 1
+183 1
+186 1
+187 3
+189 1
+19 1
+190 1
+191 2
+192 1
+193 3
+194 1
+195 2
+196 1
+197 2
+199 3
+2 1
+20 1
+200 2
+201 1
+202 1
+203 2
+205 2
+207 2
+208 3
+209 2
+213 2
+214 1
+216 2
+217 2
+218 1
+219 2
+221 2
+222 1
+223 2
+224 2
+226 1
+228 1
+229 2
+230 5
+233 2
+235 1
+237 2
+238 2
+239 2
+24 2
+241 1
+242 2
+244 1
+247 1
+248 1
+249 1
+252 1
+255 2
+256 2
+257 1
+258 1
+26 2
+260 1
+262 1
+263 1
+265 2
+266 1
+27 1
+272 2
+273 3
+274 1
+275 1
+277 4
+278 2
+28 1
+280 2
+281 2
+282 2
+283 1
+284 1
+285 1
+286 1
+287 1
+288 2
+289 1
+291 1
+292 1
+296 1
+298 3
+30 1
+302 1
+305 1
+306 1
+307 2
+308 1
+309 2
+310 1
+311 3
+315 1
+316 3
+317 2
+318 3
+321 2
+322 2
+323 1
+325 2
+327 3
+33 1
+331 2
+332 1
+333 2
+335 1
+336 1
+338 1
+339 1
+34 1
+341 1
+342 2
+344 2
+345 1
+348 5
+35 3
+351 1
+353 2
+356 1
+360 1
+362 1
+364 1
+365 1
+366 1
+367 2
+368 1
+369 3
+37 2
+373 1
+374 1
+375 1
+377 1
+378 1
+379 1
+382 2
+384 3
+386 1
+389 1
+392 1
+393 1
+394 1
+395 2
+396 3
+397 2
+399 2
+4 1
+400 1
+401 5
+402 1
+403 3
+404 2
+406 4
+407 1
+409 3
+41 1
+411 1
+413 2
+414 2
+417 3
+418 1
+419 1
+42 2
+421 1
+424 2
+427 1
+429 2
+43 1
+430 3
+431 3
+432 1
+435 1
+436 1
+437 1
+438 3
+439 2
+44 1
+443 1
+444 1
+446 1
+448 1
+449 1
+452 1
+453 1
+454 3
+455 1
+457 1
+458 2
+459 2
+460 1
+462 2
+463 2
+466 3
+467 1
+468 4
+469 5
+47 1
+470 1
+472 1
+475 1
+477 1
+478 2
+479 1
+480 3
+481 1
+482 1
+483 1
+484 1
+485 1
+487 1
+489 4
+490 1
+491 1
+492 2
+493 1
+494 1
+495 1
+496 1
+497 1
+498 3
+5 3
+51 2
+53 1
+54 1
+57 1
+58 2
+64 1
+65 1
+66 1
+67 2
+69 1
+70 3
+72 2
+74 1
+76 2
+77 1
+78 1
+8 1
+80 1
+82 1
+83 2
+84 2
+85 1
+86 1
+87 1
+9 1
+90 3
+92 1
+95 2
+96 1
+97 2
+98 2
+tst1 1
+tst1 500 500
+238 val_238 val_238
+86 val_86 val_86
+311 val_311 val_311
+27 val_27 val_27
+165 val_165 val_165
+409 val_409 val_409
+255 val_255 val_255
+278 val_278 val_278
+98 val_98 val_98
+484 val_484 val_484
+265 val_265 val_265
+193 val_193 val_193
+401 val_401 val_401
+150 val_150 val_150
+273 val_273 val_273
+224 val_224 val_224
+369 val_369 val_369
+66 val_66 val_66
+128 val_128 val_128
+213 val_213 val_213
+146 val_146 val_146
+406 val_406 val_406
+429 val_429 val_429
+374 val_374 val_374
+152 val_152 val_152
+469 val_469 val_469
+145 val_145 val_145
+495 val_495 val_495
+37 val_37 val_37
+327 val_327 val_327
+281 val_281 val_281
+277 val_277 val_277
+209 val_209 val_209
+15 val_15 val_15
+82 val_82 val_82
+403 val_403 val_403
+166 val_166 val_166
+417 val_417 val_417
+430 val_430 val_430
+252 val_252 val_252
+292 val_292 val_292
+219 val_219 val_219
+287 val_287 val_287
+153 val_153 val_153
+193 val_193 val_193
+338 val_338 val_338
+446 val_446 val_446
+459 val_459 val_459
+394 val_394 val_394
+237 val_237 val_237
+482 val_482 val_482
+174 val_174 val_174
+413 val_413 val_413
+494 val_494 val_494
+207 val_207 val_207
+199 val_199 val_199
+466 val_466 val_466
+208 val_208 val_208
+174 val_174 val_174
+399 val_399 val_399
+396 val_396 val_396
+247 val_247 val_247
+417 val_417 val_417
+489 val_489 val_489
+162 val_162 val_162
+377 val_377 val_377
+397 val_397 val_397
+309 val_309 val_309
+365 val_365 val_365
+266 val_266 val_266
+439 val_439 val_439
+342 val_342 val_342
+367 val_367 val_367
+325 val_325 val_325
+167 val_167 val_167
+195 val_195 val_195
+475 val_475 val_475
+17 val_17 val_17
+113 val_113 val_113
+155 val_155 val_155
+203 val_203 val_203
+339 val_339 val_339
+0 val_0 val_0
+455 val_455 val_455
+128 val_128 val_128
+311 val_311 val_311
+316 val_316 val_316
+57 val_57 val_57
+302 val_302 val_302
+205 val_205 val_205
+149 val_149 val_149
+438 val_438 val_438
+345 val_345 val_345
+129 val_129 val_129
+170 val_170 val_170
+20 val_20 val_20
+489 val_489 val_489
+157 val_157 val_157
+378 val_378 val_378
+221 val_221 val_221
+92 val_92 val_92
+111 val_111 val_111
+47 val_47 val_47
+72 val_72 val_72
+4 val_4 val_4
+280 val_280 val_280
+35 val_35 val_35
+427 val_427 val_427
+277 val_277 val_277
+208 val_208 val_208
+356 val_356 val_356
+399 val_399 val_399
+169 val_169 val_169
+382 val_382 val_382
+498 val_498 val_498
+125 val_125 val_125
+386 val_386 val_386
+437 val_437 val_437
+469 val_469 val_469
+192 val_192 val_192
+286 val_286 val_286
+187 val_187 val_187
+176 val_176 val_176
+54 val_54 val_54
+459 val_459 val_459
+51 val_51 val_51
+138 val_138 val_138
+103 val_103 val_103
+239 val_239 val_239
+213 val_213 val_213
+216 val_216 val_216
+430 val_430 val_430
+278 val_278 val_278
+176 val_176 val_176
+289 val_289 val_289
+221 val_221 val_221
+65 val_65 val_65
+318 val_318 val_318
+332 val_332 val_332
+311 val_311 val_311
+275 val_275 val_275
+137 val_137 val_137
+241 val_241 val_241
+83 val_83 val_83
+333 val_333 val_333
+180 val_180 val_180
+284 val_284 val_284
+12 val_12 val_12
+230 val_230 val_230
+181 val_181 val_181
+67 val_67 val_67
+260 val_260 val_260
+404 val_404 val_404
+384 val_384 val_384
+489 val_489 val_489
+353 val_353 val_353
+373 val_373 val_373
+272 val_272 val_272
+138 val_138 val_138
+217 val_217 val_217
+84 val_84 val_84
+348 val_348 val_348
+466 val_466 val_466
+58 val_58 val_58
+8 val_8 val_8
+411 val_411 val_411
+230 val_230 val_230
+208 val_208 val_208
+348 val_348 val_348
+24 val_24 val_24
+463 val_463 val_463
+431 val_431 val_431
+179 val_179 val_179
+172 val_172 val_172
+42 val_42 val_42
+129 val_129 val_129
+158 val_158 val_158
+119 val_119 val_119
+496 val_496 val_496
+0 val_0 val_0
+322 val_322 val_322
+197 val_197 val_197
+468 val_468 val_468
+393 val_393 val_393
+454 val_454 val_454
+100 val_100 val_100
+298 val_298 val_298
+199 val_199 val_199
+191 val_191 val_191
+418 val_418 val_418
+96 val_96 val_96
+26 val_26 val_26
+165 val_165 val_165
+327 val_327 val_327
+230 val_230 val_230
+205 val_205 val_205
+120 val_120 val_120
+131 val_131 val_131
+51 val_51 val_51
+404 val_404 val_404
+43 val_43 val_43
+436 val_436 val_436
+156 val_156 val_156
+469 val_469 val_469
+468 val_468 val_468
+308 val_308 val_308
+95 val_95 val_95
+196 val_196 val_196
+288 val_288 val_288
+481 val_481 val_481
+457 val_457 val_457
+98 val_98 val_98
+282 val_282 val_282
+197 val_197 val_197
+187 val_187 val_187
+318 val_318 val_318
+318 val_318 val_318
+409 val_409 val_409
+470 val_470 val_470
+137 val_137 val_137
+369 val_369 val_369
+316 val_316 val_316
+169 val_169 val_169
+413 val_413 val_413
+85 val_85 val_85
+77 val_77 val_77
+0 val_0 val_0
+490 val_490 val_490
+87 val_87 val_87
+364 val_364 val_364
+179 val_179 val_179
+118 val_118 val_118
+134 val_134 val_134
+395 val_395 val_395
+282 val_282 val_282
+138 val_138 val_138
+238 val_238 val_238
+419 val_419 val_419
+15 val_15 val_15
+118 val_118 val_118
+72 val_72 val_72
+90 val_90 val_90
+307 val_307 val_307
+19 val_19 val_19
+435 val_435 val_435
+10 val_10 val_10
+277 val_277 val_277
+273 val_273 val_273
+306 val_306 val_306
+224 val_224 val_224
+309 val_309 val_309
+389 val_389 val_389
+327 val_327 val_327
+242 val_242 val_242
+369 val_369 val_369
+392 val_392 val_392
+272 val_272 val_272
+331 val_331 val_331
+401 val_401 val_401
+242 val_242 val_242
+452 val_452 val_452
+177 val_177 val_177
+226 val_226 val_226
+5 val_5 val_5
+497 val_497 val_497
+402 val_402 val_402
+396 val_396 val_396
+317 val_317 val_317
+395 val_395 val_395
+58 val_58 val_58
+35 val_35 val_35
+336 val_336 val_336
+95 val_95 val_95
+11 val_11 val_11
+168 val_168 val_168
+34 val_34 val_34
+229 val_229 val_229
+233 val_233 val_233
+143 val_143 val_143
+472 val_472 val_472
+322 val_322 val_322
+498 val_498 val_498
+160 val_160 val_160
+195 val_195 val_195
+42 val_42 val_42
+321 val_321 val_321
+430 val_430 val_430
+119 val_119 val_119
+489 val_489 val_489
+458 val_458 val_458
+78 val_78 val_78
+76 val_76 val_76
+41 val_41 val_41
+223 val_223 val_223
+492 val_492 val_492
+149 val_149 val_149
+449 val_449 val_449
+218 val_218 val_218
+228 val_228 val_228
+138 val_138 val_138
+453 val_453 val_453
+30 val_30 val_30
+209 val_209 val_209
+64 val_64 val_64
+468 val_468 val_468
+76 val_76 val_76
+74 val_74 val_74
+342 val_342 val_342
+69 val_69 val_69
+230 val_230 val_230
+33 val_33 val_33
+368 val_368 val_368
+103 val_103 val_103
+296 val_296 val_296
+113 val_113 val_113
+216 val_216 val_216
+367 val_367 val_367
+344 val_344 val_344
+167 val_167 val_167
+274 val_274 val_274
+219 val_219 val_219
+239 val_239 val_239
+485 val_485 val_485
+116 val_116 val_116
+223 val_223 val_223
+256 val_256 val_256
+263 val_263 val_263
+70 val_70 val_70
+487 val_487 val_487
+480 val_480 val_480
+401 val_401 val_401
+288 val_288 val_288
+191 val_191 val_191
+5 val_5 val_5
+244 val_244 val_244
+438 val_438 val_438
+128 val_128 val_128
+467 val_467 val_467
+432 val_432 val_432
+202 val_202 val_202
+316 val_316 val_316
+229 val_229 val_229
+469 val_469 val_469
+463 val_463 val_463
+280 val_280 val_280
+2 val_2 val_2
+35 val_35 val_35
+283 val_283 val_283
+331 val_331 val_331
+235 val_235 val_235
+80 val_80 val_80
+44 val_44 val_44
+193 val_193 val_193
+321 val_321 val_321
+335 val_335 val_335
+104 val_104 val_104
+466 val_466 val_466
+366 val_366 val_366
+175 val_175 val_175
+403 val_403 val_403
+483 val_483 val_483
+53 val_53 val_53
+105 val_105 val_105
+257 val_257 val_257
+406 val_406 val_406
+409 val_409 val_409
+190 val_190 val_190
+406 val_406 val_406
+401 val_401 val_401
+114 val_114 val_114
+258 val_258 val_258
+90 val_90 val_90
+203 val_203 val_203
+262 val_262 val_262
+348 val_348 val_348
+424 val_424 val_424
+12 val_12 val_12
+396 val_396 val_396
+201 val_201 val_201
+217 val_217 val_217
+164 val_164 val_164
+431 val_431 val_431
+454 val_454 val_454
+478 val_478 val_478
+298 val_298 val_298
+125 val_125 val_125
+431 val_431 val_431
+164 val_164 val_164
+424 val_424 val_424
+187 val_187 val_187
+382 val_382 val_382
+5 val_5 val_5
+70 val_70 val_70
+397 val_397 val_397
+480 val_480 val_480
+291 val_291 val_291
+24 val_24 val_24
+351 val_351 val_351
+255 val_255 val_255
+104 val_104 val_104
+70 val_70 val_70
+163 val_163 val_163
+438 val_438 val_438
+119 val_119 val_119
+414 val_414 val_414
+200 val_200 val_200
+491 val_491 val_491
+237 val_237 val_237
+439 val_439 val_439
+360 val_360 val_360
+248 val_248 val_248
+479 val_479 val_479
+305 val_305 val_305
+417 val_417 val_417
+199 val_199 val_199
+444 val_444 val_444
+120 val_120 val_120
+429 val_429 val_429
+169 val_169 val_169
+443 val_443 val_443
+323 val_323 val_323
+325 val_325 val_325
+277 val_277 val_277
+230 val_230 val_230
+478 val_478 val_478
+178 val_178 val_178
+468 val_468 val_468
+310 val_310 val_310
+317 val_317 val_317
+333 val_333 val_333
+493 val_493 val_493
+460 val_460 val_460
+207 val_207 val_207
+249 val_249 val_249
+265 val_265 val_265
+480 val_480 val_480
+83 val_83 val_83
+136 val_136 val_136
+353 val_353 val_353
+172 val_172 val_172
+214 val_214 val_214
+462 val_462 val_462
+233 val_233 val_233
+406 val_406 val_406
+133 val_133 val_133
+175 val_175 val_175
+189 val_189 val_189
+454 val_454 val_454
+375 val_375 val_375
+401 val_401 val_401
+421 val_421 val_421
+407 val_407 val_407
+384 val_384 val_384
+256 val_256 val_256
+26 val_26 val_26
+134 val_134 val_134
+67 val_67 val_67
+384 val_384 val_384
+379 val_379 val_379
+18 val_18 val_18
+462 val_462 val_462
+492 val_492 val_492
+100 val_100 val_100
+298 val_298 val_298
+9 val_9 val_9
+341 val_341 val_341
+498 val_498 val_498
+146 val_146 val_146
+458 val_458 val_458
+362 val_362 val_362
+186 val_186 val_186
+285 val_285 val_285
+348 val_348 val_348
+167 val_167 val_167
+18 val_18 val_18
+273 val_273 val_273
+183 val_183 val_183
+281 val_281 val_281
+344 val_344 val_344
+97 val_97 val_97
+469 val_469 val_469
+315 val_315 val_315
+84 val_84 val_84
+28 val_28 val_28
+37 val_37 val_37
+448 val_448 val_448
+152 val_152 val_152
+348 val_348 val_348
+307 val_307 val_307
+194 val_194 val_194
+414 val_414 val_414
+477 val_477 val_477
+222 val_222 val_222
+126 val_126 val_126
+90 val_90 val_90
+169 val_169 val_169
+403 val_403 val_403
+400 val_400 val_400
+200 val_200 val_200
+97 val_97 val_97
Added: hadoop/hive/branches/branch-0.3/ql/src/test/results/clientpositive/union20.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/branches/branch-0.3/ql/src/test/results/clientpositive/union20.q.out?rev=765753&view=auto
==============================================================================
--- hadoop/hive/branches/branch-0.3/ql/src/test/results/clientpositive/union20.q.out (added)
+++ hadoop/hive/branches/branch-0.3/ql/src/test/results/clientpositive/union20.q.out Thu Apr 16 20:41:08 2009
@@ -0,0 +1,253 @@
+ABSTRACT SYNTAX TREE:
+ (TOK_QUERY (TOK_FROM (TOK_JOIN (TOK_SUBQUERY (TOK_UNION (TOK_QUERY (TOK_FROM (TOK_TABREF src s1)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR 'tst1' key) (TOK_SELEXPR (TOK_FUNCTION TOK_STRING (TOK_FUNCTION count 1)) value)))) (TOK_QUERY (TOK_FROM (TOK_TABREF src s2)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_COLREF s2 key) key) (TOK_SELEXPR (TOK_COLREF s2 value) value)) (TOK_WHERE (< (TOK_COLREF s2 key) 10))))) unionsrc1) (TOK_SUBQUERY (TOK_UNION (TOK_QUERY (TOK_FROM (TOK_TABREF src s3)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR 'tst1' key) (TOK_SELEXPR (TOK_FUNCTION TOK_STRING (TOK_FUNCTION count 1)) value)))) (TOK_QUERY (TOK_FROM (TOK_TABREF src s4)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_COLREF s4 key) key) (TOK_SELEXPR (TOK_COLREF s4 value) value)) (TOK_WHERE (< (TOK_COLREF s4 key) 10))))) unionsrc2) (= (TOK_COLREF u
nionsrc1 key) (TOK_COLREF unionsrc2 key)))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_COLREF unionsrc1 key)) (TOK_SELEXPR (TOK_COLREF unionsrc1 value)) (TOK_SELEXPR (TOK_COLREF unionsrc2 key)) (TOK_SELEXPR (TOK_COLREF unionsrc2 value)))))
+
+STAGE DEPENDENCIES:
+ Stage-1 is a root stage
+ Stage-2 depends on stages: Stage-1, Stage-3, Stage-5
+ Stage-3 is a root stage
+ Stage-2 depends on stages: Stage-1, Stage-3, Stage-5
+ Stage-4 is a root stage
+ Stage-5 depends on stages: Stage-4, Stage-6
+ Stage-2 depends on stages: Stage-1, Stage-3, Stage-5
+ Stage-6 is a root stage
+ Stage-5 depends on stages: Stage-4, Stage-6
+ Stage-2 depends on stages: Stage-1, Stage-3, Stage-5
+ Stage-0 is a root stage
+
+STAGE PLANS:
+ Stage: Stage-1
+ Map Reduce
+ Alias -> Map Operator Tree:
+ null-subquery1:unionsrc2-subquery1:s3
+ Select Operator
+ Group By Operator
+ aggregations:
+ expr: count(1)
+ mode: hash
+ Reduce Output Operator
+ sort order:
+ tag: -1
+ value expressions:
+ expr: 0
+ type: bigint
+ Reduce Operator Tree:
+ Group By Operator
+ aggregations:
+ expr: count(VALUE.0)
+ mode: mergepartial
+ Select Operator
+ expressions:
+ expr: 'tst1'
+ type: string
+ expr: UDFToString(0)
+ type: string
+ File Output Operator
+ compressed: false
+ GlobalTableId: 0
+ table:
+ input format: org.apache.hadoop.mapred.SequenceFileInputFormat
+ output format: org.apache.hadoop.mapred.SequenceFileOutputFormat
+ name: binary_table
+
+ Stage: Stage-2
+ Map Reduce
+ Alias -> Map Operator Tree:
+ /data/users/njain/hive_branch3/hive_br3/build/ql/tmp/1144866/130613752.10002
+ Union
+ Reduce Output Operator
+ key expressions:
+ expr: 0
+ type: string
+ sort order: +
+ Map-reduce partition columns:
+ expr: 0
+ type: string
+ tag: 1
+ value expressions:
+ expr: 0
+ type: string
+ expr: 1
+ type: string
+ /data/users/njain/hive_branch3/hive_br3/build/ql/tmp/1144866/130613752.10003
+ Union
+ Reduce Output Operator
+ key expressions:
+ expr: 0
+ type: string
+ sort order: +
+ Map-reduce partition columns:
+ expr: 0
+ type: string
+ tag: 1
+ value expressions:
+ expr: 0
+ type: string
+ expr: 1
+ type: string
+ $INTNAME
+ Reduce Output Operator
+ key expressions:
+ expr: 0
+ type: string
+ sort order: +
+ Map-reduce partition columns:
+ expr: 0
+ type: string
+ tag: 0
+ value expressions:
+ expr: 0
+ type: string
+ expr: 1
+ type: string
+ Reduce Operator Tree:
+ Join Operator
+ condition map:
+ Inner Join 0 to 1
+ condition expressions:
+ 0 {VALUE.0} {VALUE.1}
+ 1 {VALUE.0} {VALUE.1}
+ Select Operator
+ expressions:
+ expr: 0
+ type: string
+ expr: 1
+ type: string
+ expr: 2
+ type: string
+ expr: 3
+ type: string
+ File Output Operator
+ compressed: false
+ GlobalTableId: 0
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+
+ Stage: Stage-3
+ Map Reduce
+ Alias -> Map Operator Tree:
+ null-subquery2:unionsrc2-subquery2:s4
+ Filter Operator
+ predicate:
+ expr: (UDFToDouble(key) < UDFToDouble(10))
+ type: boolean
+ Select Operator
+ expressions:
+ expr: key
+ type: string
+ expr: value
+ type: string
+ File Output Operator
+ compressed: false
+ GlobalTableId: 0
+ table:
+ input format: org.apache.hadoop.mapred.SequenceFileInputFormat
+ output format: org.apache.hadoop.mapred.SequenceFileOutputFormat
+ name: binary_table
+
+ Stage: Stage-4
+ Map Reduce
+ Alias -> Map Operator Tree:
+ null-subquery2:unionsrc1-subquery2:s2
+ Filter Operator
+ predicate:
+ expr: (UDFToDouble(key) < UDFToDouble(10))
+ type: boolean
+ Select Operator
+ expressions:
+ expr: key
+ type: string
+ expr: value
+ type: string
+ File Output Operator
+ compressed: false
+ GlobalTableId: 0
+ table:
+ input format: org.apache.hadoop.mapred.SequenceFileInputFormat
+ output format: org.apache.hadoop.mapred.SequenceFileOutputFormat
+ name: binary_table
+
+ Stage: Stage-5
+ Map Reduce
+ Alias -> Map Operator Tree:
+ /data/users/njain/hive_branch3/hive_br3/build/ql/tmp/1144866/130613752.10004
+ Union
+ File Output Operator
+ compressed: false
+ GlobalTableId: 0
+ table:
+ input format: org.apache.hadoop.mapred.SequenceFileInputFormat
+ output format: org.apache.hadoop.mapred.SequenceFileOutputFormat
+ name: binary_table
+ /data/users/njain/hive_branch3/hive_br3/build/ql/tmp/1144866/130613752.10006
+ Union
+ File Output Operator
+ compressed: false
+ GlobalTableId: 0
+ table:
+ input format: org.apache.hadoop.mapred.SequenceFileInputFormat
+ output format: org.apache.hadoop.mapred.SequenceFileOutputFormat
+ name: binary_table
+
+ Stage: Stage-6
+ Map Reduce
+ Alias -> Map Operator Tree:
+ null-subquery1:unionsrc1-subquery1:s1
+ Select Operator
+ Group By Operator
+ aggregations:
+ expr: count(1)
+ mode: hash
+ Reduce Output Operator
+ sort order:
+ tag: -1
+ value expressions:
+ expr: 0
+ type: bigint
+ Reduce Operator Tree:
+ Group By Operator
+ aggregations:
+ expr: count(VALUE.0)
+ mode: mergepartial
+ Select Operator
+ expressions:
+ expr: 'tst1'
+ type: string
+ expr: UDFToString(0)
+ type: string
+ File Output Operator
+ compressed: false
+ GlobalTableId: 0
+ table:
+ input format: org.apache.hadoop.mapred.SequenceFileInputFormat
+ output format: org.apache.hadoop.mapred.SequenceFileOutputFormat
+ name: binary_table
+
+ Stage: Stage-0
+ Fetch Operator
+ limit: -1
+
+
+0 val_0 0 val_0
+0 val_0 0 val_0
+0 val_0 0 val_0
+0 val_0 0 val_0
+0 val_0 0 val_0
+0 val_0 0 val_0
+0 val_0 0 val_0
+0 val_0 0 val_0
+0 val_0 0 val_0
+2 val_2 2 val_2
+4 val_4 4 val_4
+5 val_5 5 val_5
+5 val_5 5 val_5
+5 val_5 5 val_5
+5 val_5 5 val_5
+5 val_5 5 val_5
+5 val_5 5 val_5
+5 val_5 5 val_5
+5 val_5 5 val_5
+5 val_5 5 val_5
+8 val_8 8 val_8
+9 val_9 9 val_9
+tst1 500 tst1 500
Modified: hadoop/hive/branches/branch-0.3/ql/src/test/results/compiler/plan/case_sensitivity.q.xml
URL: http://svn.apache.org/viewvc/hadoop/hive/branches/branch-0.3/ql/src/test/results/compiler/plan/case_sensitivity.q.xml?rev=765753&r1=765752&r2=765753&view=diff
==============================================================================
--- hadoop/hive/branches/branch-0.3/ql/src/test/results/compiler/plan/case_sensitivity.q.xml (original)
+++ hadoop/hive/branches/branch-0.3/ql/src/test/results/compiler/plan/case_sensitivity.q.xml Thu Apr 16 20:41:08 2009
@@ -31,7 +31,7 @@
<boolean>true</boolean>
</void>
<void property="sourceDir">
- <string>/data/users/njain/hive_commit/trunk/ql/../build/ql/tmp/234429576.10000.insclause-0</string>
+ <string>/data/users/njain/hive_branch3/hive_br3/ql/../build/ql/tmp/362092098.10000.insclause-0</string>
</void>
<void property="table">
<object id="tableDesc0" class="org.apache.hadoop.hive.ql.plan.tableDesc">
@@ -84,7 +84,7 @@
</void>
<void method="put">
<string>location</string>
- <string>file:/data/users/njain/hive_commit/trunk/build/ql/test/data/warehouse/dest1</string>
+ <string>file:/data/users/njain/hive_branch3/hive_br3/build/ql/test/data/warehouse/dest1</string>
</void>
</object>
</void>
@@ -94,7 +94,7 @@
</object>
</void>
<void property="tmpDir">
- <string>/data/users/athusoo/commits/hive_trunk_ws9/ql/../build/ql/tmp/823955998.10001</string>
+ <string>/data/users/njain/hive_branch3/hive_br3/ql/../build/ql/tmp/362092098.10001</string>
</void>
</object>
</void>
@@ -112,7 +112,7 @@
<void property="work">
<object class="org.apache.hadoop.hive.ql.plan.mapredWork">
<void property="aliasToWork">
- <object class="java.util.HashMap">
+ <object class="java.util.LinkedHashMap">
<void method="put">
<string>src_thrift</string>
<object id="TableScanOperator0" class="org.apache.hadoop.hive.ql.exec.TableScanOperator">
@@ -138,7 +138,7 @@
<int>1</int>
</void>
<void property="dirName">
- <string>/data/users/njain/hive_commit/trunk/ql/../build/ql/tmp/234429576.10000.insclause-0</string>
+ <string>/data/users/njain/hive_branch3/hive_br3/ql/../build/ql/tmp/362092098.10000.insclause-0</string>
</void>
<void property="tableInfo">
<object idref="tableDesc0"/>
@@ -536,7 +536,7 @@
<void property="pathToAliases">
<object class="java.util.LinkedHashMap">
<void method="put">
- <string>file:/data/users/njain/hive_commit/trunk/build/ql/test/data/warehouse/src_thrift</string>
+ <string>file:/data/users/njain/hive_branch3/hive_br3/build/ql/test/data/warehouse/src_thrift</string>
<object class="java.util.ArrayList">
<void method="add">
<string>src_thrift</string>
@@ -548,7 +548,7 @@
<void property="pathToPartitionInfo">
<object class="java.util.LinkedHashMap">
<void method="put">
- <string>file:/data/users/njain/hive_commit/trunk/build/ql/test/data/warehouse/src_thrift</string>
+ <string>file:/data/users/njain/hive_branch3/hive_br3/build/ql/test/data/warehouse/src_thrift</string>
<object class="org.apache.hadoop.hive.ql.plan.partitionDesc">
<void property="partSpec">
<object class="java.util.LinkedHashMap"/>
@@ -608,7 +608,7 @@
</void>
<void method="put">
<string>location</string>
- <string>file:/data/users/njain/hive_commit/trunk/build/ql/test/data/warehouse/src_thrift</string>
+ <string>file:/data/users/njain/hive_branch3/hive_br3/build/ql/test/data/warehouse/src_thrift</string>
</void>
</object>
</void>
Modified: hadoop/hive/branches/branch-0.3/ql/src/test/results/compiler/plan/cast1.q.xml
URL: http://svn.apache.org/viewvc/hadoop/hive/branches/branch-0.3/ql/src/test/results/compiler/plan/cast1.q.xml?rev=765753&r1=765752&r2=765753&view=diff
==============================================================================
--- hadoop/hive/branches/branch-0.3/ql/src/test/results/compiler/plan/cast1.q.xml (original)
+++ hadoop/hive/branches/branch-0.3/ql/src/test/results/compiler/plan/cast1.q.xml Thu Apr 16 20:41:08 2009
@@ -7,7 +7,7 @@
<void property="work">
<object class="org.apache.hadoop.hive.ql.plan.mapredWork">
<void property="aliasToWork">
- <object class="java.util.HashMap">
+ <object class="java.util.LinkedHashMap">
<void method="put">
<string>src</string>
<object id="TableScanOperator0" class="org.apache.hadoop.hive.ql.exec.TableScanOperator">
@@ -30,7 +30,7 @@
<void property="conf">
<object class="org.apache.hadoop.hive.ql.plan.fileSinkDesc">
<void property="dirName">
- <string>/data/users/njain/hive_commit/trunk/ql/../build/ql/tmp/104464833.10001.insclause-0</string>
+ <string>/data/users/njain/hive_branch3/hive_br3/ql/../build/ql/tmp/105820153.10001.insclause-0</string>
</void>
<void property="tableInfo">
<object class="org.apache.hadoop.hive.ql.plan.tableDesc">
@@ -764,7 +764,7 @@
<void property="pathToAliases">
<object class="java.util.LinkedHashMap">
<void method="put">
- <string>file:/data/users/njain/hive_commit/trunk/build/ql/test/data/warehouse/src</string>
+ <string>file:/data/users/njain/hive_branch3/hive_br3/build/ql/test/data/warehouse/src</string>
<object class="java.util.ArrayList">
<void method="add">
<string>src</string>
@@ -776,7 +776,7 @@
<void property="pathToPartitionInfo">
<object class="java.util.LinkedHashMap">
<void method="put">
- <string>file:/data/users/njain/hive_commit/trunk/build/ql/test/data/warehouse/src</string>
+ <string>file:/data/users/njain/hive_branch3/hive_br3/build/ql/test/data/warehouse/src</string>
<object class="org.apache.hadoop.hive.ql.plan.partitionDesc">
<void property="partSpec">
<object class="java.util.LinkedHashMap"/>
@@ -832,7 +832,7 @@
</void>
<void method="put">
<string>location</string>
- <string>file:/data/users/njain/hive_commit/trunk/build/ql/test/data/warehouse/src</string>
+ <string>file:/data/users/njain/hive_branch3/hive_br3/build/ql/test/data/warehouse/src</string>
</void>
</object>
</void>
Modified: hadoop/hive/branches/branch-0.3/ql/src/test/results/compiler/plan/groupby1.q.xml
URL: http://svn.apache.org/viewvc/hadoop/hive/branches/branch-0.3/ql/src/test/results/compiler/plan/groupby1.q.xml?rev=765753&r1=765752&r2=765753&view=diff
==============================================================================
--- hadoop/hive/branches/branch-0.3/ql/src/test/results/compiler/plan/groupby1.q.xml (original)
+++ hadoop/hive/branches/branch-0.3/ql/src/test/results/compiler/plan/groupby1.q.xml Thu Apr 16 20:41:08 2009
@@ -31,7 +31,7 @@
<boolean>true</boolean>
</void>
<void property="sourceDir">
- <string>/data/users/njain/hive_commit/trunk/ql/../build/ql/tmp/1265433083/1184432129.10000.insclause-0</string>
+ <string>/data/users/njain/hive_branch3/hive_br3/ql/../build/ql/tmp/35238378/568542419.10000.insclause-0</string>
</void>
<void property="table">
<object id="tableDesc0" class="org.apache.hadoop.hive.ql.plan.tableDesc">
@@ -84,7 +84,7 @@
</void>
<void method="put">
<string>location</string>
- <string>file:/data/users/njain/hive_commit/trunk/build/ql/test/data/warehouse/dest1</string>
+ <string>file:/data/users/njain/hive_branch3/hive_br3/build/ql/test/data/warehouse/dest1</string>
</void>
</object>
</void>
@@ -94,7 +94,7 @@
</object>
</void>
<void property="tmpDir">
- <string>/data/users/athusoo/commits/hive_trunk_ws9/ql/../build/ql/tmp/390951103/204238523.10001</string>
+ <string>/data/users/njain/hive_branch3/hive_br3/ql/../build/ql/tmp/35238378/568542419.10001</string>
</void>
</object>
</void>
@@ -112,7 +112,7 @@
<void property="work">
<object class="org.apache.hadoop.hive.ql.plan.mapredWork">
<void property="aliasToWork">
- <object class="java.util.HashMap">
+ <object class="java.util.LinkedHashMap">
<void method="put">
<string>src</string>
<object id="TableScanOperator0" class="org.apache.hadoop.hive.ql.exec.TableScanOperator">
@@ -477,7 +477,7 @@
<void property="pathToAliases">
<object class="java.util.LinkedHashMap">
<void method="put">
- <string>file:/data/users/njain/hive_commit/trunk/build/ql/test/data/warehouse/src</string>
+ <string>file:/data/users/njain/hive_branch3/hive_br3/build/ql/test/data/warehouse/src</string>
<object class="java.util.ArrayList">
<void method="add">
<string>src</string>
@@ -489,7 +489,7 @@
<void property="pathToPartitionInfo">
<object class="java.util.LinkedHashMap">
<void method="put">
- <string>file:/data/users/njain/hive_commit/trunk/build/ql/test/data/warehouse/src</string>
+ <string>file:/data/users/njain/hive_branch3/hive_br3/build/ql/test/data/warehouse/src</string>
<object class="org.apache.hadoop.hive.ql.plan.partitionDesc">
<void property="partSpec">
<object class="java.util.LinkedHashMap"/>
@@ -545,7 +545,7 @@
</void>
<void method="put">
<string>location</string>
- <string>file:/data/users/njain/hive_commit/trunk/build/ql/test/data/warehouse/src</string>
+ <string>file:/data/users/njain/hive_branch3/hive_br3/build/ql/test/data/warehouse/src</string>
</void>
</object>
</void>
@@ -574,7 +574,7 @@
<int>1</int>
</void>
<void property="dirName">
- <string>/data/users/njain/hive_commit/trunk/ql/../build/ql/tmp/1265433083/1184432129.10000.insclause-0</string>
+ <string>/data/users/njain/hive_branch3/hive_br3/ql/../build/ql/tmp/35238378/568542419.10000.insclause-0</string>
</void>
<void property="tableInfo">
<object idref="tableDesc0"/>
Modified: hadoop/hive/branches/branch-0.3/ql/src/test/results/compiler/plan/groupby2.q.xml
URL: http://svn.apache.org/viewvc/hadoop/hive/branches/branch-0.3/ql/src/test/results/compiler/plan/groupby2.q.xml?rev=765753&r1=765752&r2=765753&view=diff
==============================================================================
--- hadoop/hive/branches/branch-0.3/ql/src/test/results/compiler/plan/groupby2.q.xml (original)
+++ hadoop/hive/branches/branch-0.3/ql/src/test/results/compiler/plan/groupby2.q.xml Thu Apr 16 20:41:08 2009
@@ -7,7 +7,7 @@
<void property="work">
<object class="org.apache.hadoop.hive.ql.plan.mapredWork">
<void property="aliasToWork">
- <object class="java.util.HashMap">
+ <object class="java.util.LinkedHashMap">
<void method="put">
<string>src</string>
<object id="TableScanOperator0" class="org.apache.hadoop.hive.ql.exec.TableScanOperator">
@@ -604,7 +604,7 @@
<void property="pathToAliases">
<object class="java.util.LinkedHashMap">
<void method="put">
- <string>file:/data/users/njain/hive_commit/trunk/build/ql/test/data/warehouse/src</string>
+ <string>file:/data/users/njain/hive_branch3/hive_br3/build/ql/test/data/warehouse/src</string>
<object class="java.util.ArrayList">
<void method="add">
<string>src</string>
@@ -616,7 +616,7 @@
<void property="pathToPartitionInfo">
<object class="java.util.LinkedHashMap">
<void method="put">
- <string>file:/data/users/njain/hive_commit/trunk/build/ql/test/data/warehouse/src</string>
+ <string>file:/data/users/njain/hive_branch3/hive_br3/build/ql/test/data/warehouse/src</string>
<object class="org.apache.hadoop.hive.ql.plan.partitionDesc">
<void property="partSpec">
<object class="java.util.LinkedHashMap"/>
@@ -672,7 +672,7 @@
</void>
<void method="put">
<string>location</string>
- <string>file:/data/users/njain/hive_commit/trunk/build/ql/test/data/warehouse/src</string>
+ <string>file:/data/users/njain/hive_branch3/hive_br3/build/ql/test/data/warehouse/src</string>
</void>
</object>
</void>
@@ -698,7 +698,7 @@
<void property="conf">
<object class="org.apache.hadoop.hive.ql.plan.fileSinkDesc">
<void property="dirName">
- <string>/data/users/njain/hive_commit/trunk/ql/../build/ql/tmp/1429866985/222456329.10001.insclause-0</string>
+ <string>/data/users/njain/hive_branch3/hive_br3/ql/../build/ql/tmp/1506439038/147172800.10001.insclause-0</string>
</void>
<void property="tableInfo">
<object class="org.apache.hadoop.hive.ql.plan.tableDesc">
Modified: hadoop/hive/branches/branch-0.3/ql/src/test/results/compiler/plan/groupby3.q.xml
URL: http://svn.apache.org/viewvc/hadoop/hive/branches/branch-0.3/ql/src/test/results/compiler/plan/groupby3.q.xml?rev=765753&r1=765752&r2=765753&view=diff
==============================================================================
--- hadoop/hive/branches/branch-0.3/ql/src/test/results/compiler/plan/groupby3.q.xml (original)
+++ hadoop/hive/branches/branch-0.3/ql/src/test/results/compiler/plan/groupby3.q.xml Thu Apr 16 20:41:08 2009
@@ -7,7 +7,7 @@
<void property="work">
<object class="org.apache.hadoop.hive.ql.plan.mapredWork">
<void property="aliasToWork">
- <object class="java.util.HashMap">
+ <object class="java.util.LinkedHashMap">
<void method="put">
<string>src</string>
<object id="TableScanOperator0" class="org.apache.hadoop.hive.ql.exec.TableScanOperator">
@@ -887,7 +887,7 @@
<void property="pathToAliases">
<object class="java.util.LinkedHashMap">
<void method="put">
- <string>file:/data/users/njain/hive_commit/trunk/build/ql/test/data/warehouse/src</string>
+ <string>file:/data/users/njain/hive_branch3/hive_br3/build/ql/test/data/warehouse/src</string>
<object class="java.util.ArrayList">
<void method="add">
<string>src</string>
@@ -899,7 +899,7 @@
<void property="pathToPartitionInfo">
<object class="java.util.LinkedHashMap">
<void method="put">
- <string>file:/data/users/njain/hive_commit/trunk/build/ql/test/data/warehouse/src</string>
+ <string>file:/data/users/njain/hive_branch3/hive_br3/build/ql/test/data/warehouse/src</string>
<object class="org.apache.hadoop.hive.ql.plan.partitionDesc">
<void property="partSpec">
<object class="java.util.LinkedHashMap"/>
@@ -955,7 +955,7 @@
</void>
<void method="put">
<string>location</string>
- <string>file:/data/users/njain/hive_commit/trunk/build/ql/test/data/warehouse/src</string>
+ <string>file:/data/users/njain/hive_branch3/hive_br3/build/ql/test/data/warehouse/src</string>
</void>
</object>
</void>
@@ -981,7 +981,7 @@
<void property="conf">
<object class="org.apache.hadoop.hive.ql.plan.fileSinkDesc">
<void property="dirName">
- <string>/data/users/njain/hive_commit/trunk/ql/../build/ql/tmp/1026930987.10001.insclause-0</string>
+ <string>/data/users/njain/hive_branch3/hive_br3/ql/../build/ql/tmp/955509098.10001.insclause-0</string>
</void>
<void property="tableInfo">
<object class="org.apache.hadoop.hive.ql.plan.tableDesc">
Modified: hadoop/hive/branches/branch-0.3/ql/src/test/results/compiler/plan/groupby4.q.xml
URL: http://svn.apache.org/viewvc/hadoop/hive/branches/branch-0.3/ql/src/test/results/compiler/plan/groupby4.q.xml?rev=765753&r1=765752&r2=765753&view=diff
==============================================================================
--- hadoop/hive/branches/branch-0.3/ql/src/test/results/compiler/plan/groupby4.q.xml (original)
+++ hadoop/hive/branches/branch-0.3/ql/src/test/results/compiler/plan/groupby4.q.xml Thu Apr 16 20:41:08 2009
@@ -7,7 +7,7 @@
<void property="work">
<object class="org.apache.hadoop.hive.ql.plan.mapredWork">
<void property="aliasToWork">
- <object class="java.util.HashMap">
+ <object class="java.util.LinkedHashMap">
<void method="put">
<string>src</string>
<object id="TableScanOperator0" class="org.apache.hadoop.hive.ql.exec.TableScanOperator">
@@ -347,7 +347,7 @@
<void property="pathToAliases">
<object class="java.util.LinkedHashMap">
<void method="put">
- <string>file:/data/users/njain/hive_commit/trunk/build/ql/test/data/warehouse/src</string>
+ <string>file:/data/users/njain/hive_branch3/hive_br3/build/ql/test/data/warehouse/src</string>
<object class="java.util.ArrayList">
<void method="add">
<string>src</string>
@@ -359,7 +359,7 @@
<void property="pathToPartitionInfo">
<object class="java.util.LinkedHashMap">
<void method="put">
- <string>file:/data/users/njain/hive_commit/trunk/build/ql/test/data/warehouse/src</string>
+ <string>file:/data/users/njain/hive_branch3/hive_br3/build/ql/test/data/warehouse/src</string>
<object class="org.apache.hadoop.hive.ql.plan.partitionDesc">
<void property="partSpec">
<object class="java.util.LinkedHashMap"/>
@@ -415,7 +415,7 @@
</void>
<void method="put">
<string>location</string>
- <string>file:/data/users/njain/hive_commit/trunk/build/ql/test/data/warehouse/src</string>
+ <string>file:/data/users/njain/hive_branch3/hive_br3/build/ql/test/data/warehouse/src</string>
</void>
</object>
</void>
@@ -441,7 +441,7 @@
<void property="conf">
<object class="org.apache.hadoop.hive.ql.plan.fileSinkDesc">
<void property="dirName">
- <string>/data/users/njain/hive_commit/trunk/ql/../build/ql/tmp/439932958.10001.insclause-0</string>
+ <string>/data/users/njain/hive_branch3/hive_br3/ql/../build/ql/tmp/1045503041.10001.insclause-0</string>
</void>
<void property="tableInfo">
<object class="org.apache.hadoop.hive.ql.plan.tableDesc">
Modified: hadoop/hive/branches/branch-0.3/ql/src/test/results/compiler/plan/groupby5.q.xml
URL: http://svn.apache.org/viewvc/hadoop/hive/branches/branch-0.3/ql/src/test/results/compiler/plan/groupby5.q.xml?rev=765753&r1=765752&r2=765753&view=diff
==============================================================================
--- hadoop/hive/branches/branch-0.3/ql/src/test/results/compiler/plan/groupby5.q.xml (original)
+++ hadoop/hive/branches/branch-0.3/ql/src/test/results/compiler/plan/groupby5.q.xml Thu Apr 16 20:41:08 2009
@@ -7,7 +7,7 @@
<void property="work">
<object class="org.apache.hadoop.hive.ql.plan.mapredWork">
<void property="aliasToWork">
- <object class="java.util.HashMap">
+ <object class="java.util.LinkedHashMap">
<void method="put">
<string>src</string>
<object id="TableScanOperator0" class="org.apache.hadoop.hive.ql.exec.TableScanOperator">
@@ -372,7 +372,7 @@
<void property="pathToAliases">
<object class="java.util.LinkedHashMap">
<void method="put">
- <string>file:/data/users/njain/hive_commit/trunk/build/ql/test/data/warehouse/src</string>
+ <string>file:/data/users/njain/hive_branch3/hive_br3/build/ql/test/data/warehouse/src</string>
<object class="java.util.ArrayList">
<void method="add">
<string>src</string>
@@ -384,7 +384,7 @@
<void property="pathToPartitionInfo">
<object class="java.util.LinkedHashMap">
<void method="put">
- <string>file:/data/users/njain/hive_commit/trunk/build/ql/test/data/warehouse/src</string>
+ <string>file:/data/users/njain/hive_branch3/hive_br3/build/ql/test/data/warehouse/src</string>
<object class="org.apache.hadoop.hive.ql.plan.partitionDesc">
<void property="partSpec">
<object class="java.util.LinkedHashMap"/>
@@ -440,7 +440,7 @@
</void>
<void method="put">
<string>location</string>
- <string>file:/data/users/njain/hive_commit/trunk/build/ql/test/data/warehouse/src</string>
+ <string>file:/data/users/njain/hive_branch3/hive_br3/build/ql/test/data/warehouse/src</string>
</void>
</object>
</void>
@@ -466,7 +466,7 @@
<void property="conf">
<object class="org.apache.hadoop.hive.ql.plan.fileSinkDesc">
<void property="dirName">
- <string>/data/users/njain/hive_commit/trunk/ql/../build/ql/tmp/698171871/39134867.10001.insclause-0</string>
+ <string>/data/users/njain/hive_branch3/hive_br3/ql/../build/ql/tmp/94125334/110689960.10001.insclause-0</string>
</void>
<void property="tableInfo">
<object class="org.apache.hadoop.hive.ql.plan.tableDesc">
Modified: hadoop/hive/branches/branch-0.3/ql/src/test/results/compiler/plan/groupby6.q.xml
URL: http://svn.apache.org/viewvc/hadoop/hive/branches/branch-0.3/ql/src/test/results/compiler/plan/groupby6.q.xml?rev=765753&r1=765752&r2=765753&view=diff
==============================================================================
--- hadoop/hive/branches/branch-0.3/ql/src/test/results/compiler/plan/groupby6.q.xml (original)
+++ hadoop/hive/branches/branch-0.3/ql/src/test/results/compiler/plan/groupby6.q.xml Thu Apr 16 20:41:08 2009
@@ -7,7 +7,7 @@
<void property="work">
<object class="org.apache.hadoop.hive.ql.plan.mapredWork">
<void property="aliasToWork">
- <object class="java.util.HashMap">
+ <object class="java.util.LinkedHashMap">
<void method="put">
<string>src</string>
<object id="TableScanOperator0" class="org.apache.hadoop.hive.ql.exec.TableScanOperator">
@@ -347,7 +347,7 @@
<void property="pathToAliases">
<object class="java.util.LinkedHashMap">
<void method="put">
- <string>file:/data/users/njain/hive_commit/trunk/build/ql/test/data/warehouse/src</string>
+ <string>file:/data/users/njain/hive_branch3/hive_br3/build/ql/test/data/warehouse/src</string>
<object class="java.util.ArrayList">
<void method="add">
<string>src</string>
@@ -359,7 +359,7 @@
<void property="pathToPartitionInfo">
<object class="java.util.LinkedHashMap">
<void method="put">
- <string>file:/data/users/njain/hive_commit/trunk/build/ql/test/data/warehouse/src</string>
+ <string>file:/data/users/njain/hive_branch3/hive_br3/build/ql/test/data/warehouse/src</string>
<object class="org.apache.hadoop.hive.ql.plan.partitionDesc">
<void property="partSpec">
<object class="java.util.LinkedHashMap"/>
@@ -415,7 +415,7 @@
</void>
<void method="put">
<string>location</string>
- <string>file:/data/users/njain/hive_commit/trunk/build/ql/test/data/warehouse/src</string>
+ <string>file:/data/users/njain/hive_branch3/hive_br3/build/ql/test/data/warehouse/src</string>
</void>
</object>
</void>
@@ -441,7 +441,7 @@
<void property="conf">
<object class="org.apache.hadoop.hive.ql.plan.fileSinkDesc">
<void property="dirName">
- <string>/data/users/njain/hive_commit/trunk/ql/../build/ql/tmp/523535720.10001.insclause-0</string>
+ <string>/data/users/njain/hive_branch3/hive_br3/ql/../build/ql/tmp/248750275.10001.insclause-0</string>
</void>
<void property="tableInfo">
<object class="org.apache.hadoop.hive.ql.plan.tableDesc">
Modified: hadoop/hive/branches/branch-0.3/ql/src/test/results/compiler/plan/input1.q.xml
URL: http://svn.apache.org/viewvc/hadoop/hive/branches/branch-0.3/ql/src/test/results/compiler/plan/input1.q.xml?rev=765753&r1=765752&r2=765753&view=diff
==============================================================================
--- hadoop/hive/branches/branch-0.3/ql/src/test/results/compiler/plan/input1.q.xml (original)
+++ hadoop/hive/branches/branch-0.3/ql/src/test/results/compiler/plan/input1.q.xml Thu Apr 16 20:41:08 2009
@@ -31,7 +31,7 @@
<boolean>true</boolean>
</void>
<void property="sourceDir">
- <string>/data/users/njain/hive_commit/trunk/ql/../build/ql/tmp/103011181/480124140.10000.insclause-0</string>
+ <string>/data/users/njain/hive_branch3/hive_br3/ql/../build/ql/tmp/306148179/343829179.10000.insclause-0</string>
</void>
<void property="table">
<object id="tableDesc0" class="org.apache.hadoop.hive.ql.plan.tableDesc">
@@ -84,7 +84,7 @@
</void>
<void method="put">
<string>location</string>
- <string>file:/data/users/njain/hive_commit/trunk/build/ql/test/data/warehouse/dest1</string>
+ <string>file:/data/users/njain/hive_branch3/hive_br3/build/ql/test/data/warehouse/dest1</string>
</void>
</object>
</void>
@@ -94,7 +94,7 @@
</object>
</void>
<void property="tmpDir">
- <string>/data/users/athusoo/commits/hive_trunk_ws9/ql/../build/ql/tmp/15406173/10216775.10001</string>
+ <string>/data/users/njain/hive_branch3/hive_br3/ql/../build/ql/tmp/306148179/343829179.10001</string>
</void>
</object>
</void>
@@ -112,7 +112,7 @@
<void property="work">
<object class="org.apache.hadoop.hive.ql.plan.mapredWork">
<void property="aliasToWork">
- <object class="java.util.HashMap">
+ <object class="java.util.LinkedHashMap">
<void method="put">
<string>src</string>
<object id="TableScanOperator0" class="org.apache.hadoop.hive.ql.exec.TableScanOperator">
@@ -134,7 +134,7 @@
<int>1</int>
</void>
<void property="dirName">
- <string>/data/users/njain/hive_commit/trunk/ql/../build/ql/tmp/103011181/480124140.10000.insclause-0</string>
+ <string>/data/users/njain/hive_branch3/hive_br3/ql/../build/ql/tmp/306148179/343829179.10000.insclause-0</string>
</void>
<void property="tableInfo">
<object idref="tableDesc0"/>
@@ -394,7 +394,7 @@
<void property="pathToAliases">
<object class="java.util.LinkedHashMap">
<void method="put">
- <string>file:/data/users/njain/hive_commit/trunk/build/ql/test/data/warehouse/src</string>
+ <string>file:/data/users/njain/hive_branch3/hive_br3/build/ql/test/data/warehouse/src</string>
<object class="java.util.ArrayList">
<void method="add">
<string>src</string>
@@ -406,7 +406,7 @@
<void property="pathToPartitionInfo">
<object class="java.util.LinkedHashMap">
<void method="put">
- <string>file:/data/users/njain/hive_commit/trunk/build/ql/test/data/warehouse/src</string>
+ <string>file:/data/users/njain/hive_branch3/hive_br3/build/ql/test/data/warehouse/src</string>
<object class="org.apache.hadoop.hive.ql.plan.partitionDesc">
<void property="partSpec">
<object class="java.util.LinkedHashMap"/>
@@ -462,7 +462,7 @@
</void>
<void method="put">
<string>location</string>
- <string>file:/data/users/njain/hive_commit/trunk/build/ql/test/data/warehouse/src</string>
+ <string>file:/data/users/njain/hive_branch3/hive_br3/build/ql/test/data/warehouse/src</string>
</void>
</object>
</void>