You are viewing a plain text version of this content. The canonical link for it is here.
Posted to common-commits@hadoop.apache.org by zs...@apache.org on 2008/09/20 01:56:35 UTC
svn commit: r697291 [21/31] - in /hadoop/core/trunk: ./
src/contrib/hive/cli/src/java/org/apache/hadoop/hive/cli/
src/contrib/hive/metastore/if/
src/contrib/hive/metastore/src/gen-javabean/org/apache/hadoop/hive/metastore/api/
src/contrib/hive/metastor...
Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/sample2.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/sample2.q.out?rev=697291&r1=697290&r2=697291&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/sample2.q.out (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/sample2.q.out Fri Sep 19 16:56:30 2008
@@ -1,581 +1,585 @@
-ABSTRACT SYNTAX TREE:
- (TOK_QUERY (TOK_FROM (TOK_TABREF srcbucket (TOK_TABLESAMPLE 1 2) s)) (TOK_INSERT (TOK_DESTINATION (TOK_TAB dest1)) (TOK_SELECT (TOK_SELEXPR (TOK_ALLCOLREF s)))))
-
-STAGE DEPENDENCIES:
- Stage-1 is a root stage
- Stage-0 depends on stages: Stage-1
-
-STAGE PLANS:
- Stage: Stage-1
- Map Reduce
- Path -> Alias:
- file:/home/athusoo/projects/hadoop/trunk/VENDOR/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/srcbucket/kv1.txt
- Path -> Partition:
- file:/home/athusoo/projects/hadoop/trunk/VENDOR/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/srcbucket/kv1.txt
- Partition
-
- properties:
- name srcbucket
- bucket_field_name
- serialization.format 1
- columns key,value
- field_to_dimension
- bucket_count 2
- serialization.lib simple_meta
- file.inputformat org.apache.hadoop.mapred.TextInputFormat
- file.outputformat org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
- location file:/home/athusoo/projects/hadoop/trunk/VENDOR/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/srcbucket
- name: srcbucket
- serde: simple_meta
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
- Alias -> Map Operator Tree:
- s
- Select Operator
- expressions:
- expr: key
- type: class java.lang.String
- expr: value
- type: class java.lang.String
- File Output Operator
- table:
- properties:
- name dest1
- bucket_field_name
- serialization.format 1
- columns key,value
- field_to_dimension
- bucket_count -1
- serialization.lib org.apache.hadoop.hive.serde.simple_meta.MetadataTypedColumnsetSerDe
- file.inputformat org.apache.hadoop.mapred.TextInputFormat
- file.outputformat org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
- location file:/home/athusoo/projects/hadoop/trunk/VENDOR/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/dest1
- name: dest1
- serde: org.apache.hadoop.hive.serde.simple_meta.MetadataTypedColumnsetSerDe
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
- directory: /tmp/hive-athusoo/447439878.10000.insclause-0
- Needs Tagging:
-
- Stage: Stage-0
- Move Operator
- tables:
- table:
- properties:
- name dest1
- bucket_field_name
- serialization.format 1
- columns key,value
- field_to_dimension
- bucket_count -1
- serialization.lib org.apache.hadoop.hive.serde.simple_meta.MetadataTypedColumnsetSerDe
- file.inputformat org.apache.hadoop.mapred.TextInputFormat
- file.outputformat org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
- location file:/home/athusoo/projects/hadoop/trunk/VENDOR/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/dest1
- name: dest1
- serde: org.apache.hadoop.hive.serde.simple_meta.MetadataTypedColumnsetSerDe
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
- replace:
- source: /tmp/hive-athusoo/447439878.10000.insclause-0
-
-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
+ABSTRACT SYNTAX TREE:
+ (TOK_QUERY (TOK_FROM (TOK_TABREF srcbucket (TOK_TABLESAMPLE 1 2) s)) (TOK_INSERT (TOK_DESTINATION (TOK_TAB dest1)) (TOK_SELECT (TOK_SELEXPR (TOK_ALLCOLREF s)))))
+
+STAGE DEPENDENCIES:
+ Stage-1 is a root stage
+ Stage-0 depends on stages: Stage-1
+
+STAGE PLANS:
+ Stage: Stage-1
+ Map Reduce
+ Path -> Alias:
+ file:/data/zshao/trunk/VENDOR/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/srcbucket/kv1.txt
+ Path -> Partition:
+ file:/data/zshao/trunk/VENDOR/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/srcbucket/kv1.txt
+ Partition
+
+ properties:
+ name srcbucket
+ bucket_field_name
+ serialization.format 1
+ columns key,value
+ field_to_dimension
+ bucket_count 2
+ serialization.lib simple_meta
+ file.inputformat org.apache.hadoop.mapred.TextInputFormat
+ file.outputformat org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ location file:/data/zshao/trunk/VENDOR/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/srcbucket
+ name: srcbucket
+ serde: simple_meta
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ Alias -> Map Operator Tree:
+ s
+ Select Operator
+ expressions:
+ expr: key
+ type: string
+ expr: value
+ type: string
+ File Output Operator
+ table:
+ properties:
+ name dest1
+ bucket_field_name
+ serialization.format 1
+ columns key,value
+ SORTBUCKETCOLSPREFIX TRUE
+ field_to_dimension
+ bucket_count -1
+ serialization.lib simple_meta
+ file.inputformat org.apache.hadoop.mapred.TextInputFormat
+ file.outputformat org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ location file:/data/zshao/trunk/VENDOR/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/dest1
+ name: dest1
+ serde: simple_meta
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ directory: /tmp/hive-zshao/83464218.10000.insclause-0
+ Needs Tagging:
+
+ Stage: Stage-0
+ Move Operator
+ tables:
+ table:
+ properties:
+ name dest1
+ bucket_field_name
+ serialization.format 1
+ columns key,value
+ SORTBUCKETCOLSPREFIX TRUE
+ field_to_dimension
+ bucket_count -1
+ serialization.lib simple_meta
+ file.inputformat org.apache.hadoop.mapred.TextInputFormat
+ file.outputformat org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ location file:/data/zshao/trunk/VENDOR/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/dest1
+ name: dest1
+ serde: simple_meta
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ replace:
+ source: /tmp/hive-zshao/83464218.10000.insclause-0
+
+
+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
+
Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/sample4.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/sample4.q.out?rev=697291&r1=697290&r2=697291&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/sample4.q.out (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/sample4.q.out Fri Sep 19 16:56:30 2008
@@ -1,587 +1,592 @@
-ABSTRACT SYNTAX TREE:
- (TOK_QUERY (TOK_FROM (TOK_TABREF srcbucket (TOK_TABLESAMPLE 1 2 key) s)) (TOK_INSERT (TOK_DESTINATION (TOK_TAB dest1)) (TOK_SELECT (TOK_SELEXPR (TOK_ALLCOLREF s)))))
-
-STAGE DEPENDENCIES:
- Stage-1 is a root stage
- Stage-0 depends on stages: Stage-1
-
-STAGE PLANS:
- Stage: Stage-1
- Map Reduce
- Path -> Alias:
- file:/home/athusoo/projects/hadoop/trunk/VENDOR/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/srcbucket
- Path -> Partition:
- file:/home/athusoo/projects/hadoop/trunk/VENDOR/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/srcbucket
- Partition
-
- properties:
- name srcbucket
- bucket_field_name
- serialization.format 1
- columns key,value
- field_to_dimension
- bucket_count 2
- serialization.lib simple_meta
- file.inputformat org.apache.hadoop.mapred.TextInputFormat
- file.outputformat org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
- location file:/home/athusoo/projects/hadoop/trunk/VENDOR/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/srcbucket
- name: srcbucket
- serde: simple_meta
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
- Alias -> Map Operator Tree:
- s
- Filter Operator
- predicate:
- expr: (((default_sample_hashfn(key) & 2147483647) % 2) = 1)
- type: class java.lang.Boolean
- Select Operator
- expressions:
- expr: key
- type: class java.lang.String
- expr: value
- type: class java.lang.String
- File Output Operator
- table:
- properties:
- name dest1
- bucket_field_name
- serialization.format 1
- columns key,value
- field_to_dimension
- bucket_count -1
- serialization.lib org.apache.hadoop.hive.serde.simple_meta.MetadataTypedColumnsetSerDe
- file.inputformat org.apache.hadoop.mapred.TextInputFormat
- file.outputformat org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
- location file:/home/athusoo/projects/hadoop/trunk/VENDOR/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/dest1
- name: dest1
- serde: org.apache.hadoop.hive.serde.simple_meta.MetadataTypedColumnsetSerDe
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
- directory: /tmp/hive-athusoo/24880210.10000.insclause-0
- Needs Tagging:
-
- Stage: Stage-0
- Move Operator
- tables:
- table:
- properties:
- name dest1
- bucket_field_name
- serialization.format 1
- columns key,value
- field_to_dimension
- bucket_count -1
- serialization.lib org.apache.hadoop.hive.serde.simple_meta.MetadataTypedColumnsetSerDe
- file.inputformat org.apache.hadoop.mapred.TextInputFormat
- file.outputformat org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
- location file:/home/athusoo/projects/hadoop/trunk/VENDOR/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/dest1
- name: dest1
- serde: org.apache.hadoop.hive.serde.simple_meta.MetadataTypedColumnsetSerDe
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
- replace:
- source: /tmp/hive-athusoo/24880210.10000.insclause-0
-
-238 val_238
-311 val_311
-27 val_27
-409 val_409
-278 val_278
-98 val_98
-265 val_265
-193 val_193
-401 val_401
-128 val_128
-146 val_146
-429 val_429
-469 val_469
-281 val_281
-209 val_209
-403 val_403
-166 val_166
-430 val_430
-252 val_252
-292 val_292
-287 val_287
-153 val_153
-193 val_193
-494 val_494
-207 val_207
-199 val_199
-399 val_399
-247 val_247
-489 val_489
-162 val_162
-377 val_377
-397 val_397
-342 val_342
-195 val_195
-113 val_113
-155 val_155
-203 val_203
-339 val_339
-128 val_128
-311 val_311
-302 val_302
-205 val_205
-438 val_438
-489 val_489
-157 val_157
-221 val_221
-92 val_92
-111 val_111
-47 val_47
-72 val_72
-427 val_427
-399 val_399
-382 val_382
-498 val_498
-386 val_386
-469 val_469
-54 val_54
-216 val_216
-430 val_430
-278 val_278
-289 val_289
-221 val_221
-65 val_65
-311 val_311
-137 val_137
-241 val_241
-83 val_83
-333 val_333
-180 val_180
-12 val_12
-230 val_230
-67 val_67
-384 val_384
-489 val_489
-353 val_353
-373 val_373
-272 val_272
-348 val_348
-58 val_58
-230 val_230
-348 val_348
-463 val_463
-179 val_179
-119 val_119
-496 val_496
-322 val_322
-197 val_197
-393 val_393
-454 val_454
-100 val_100
-298 val_298
-199 val_199
-191 val_191
-418 val_418
-96 val_96
-230 val_230
-205 val_205
-120 val_120
-131 val_131
-43 val_43
-436 val_436
-469 val_469
-308 val_308
-481 val_481
-98 val_98
-197 val_197
-409 val_409
-470 val_470
-137 val_137
-85 val_85
-490 val_490
-87 val_87
-364 val_364
-179 val_179
-395 val_395
-238 val_238
-72 val_72
-90 val_90
-10 val_10
-306 val_306
-272 val_272
-331 val_331
-401 val_401
-452 val_452
-177 val_177
-5 val_5
-317 val_317
-395 val_395
-58 val_58
-168 val_168
-34 val_34
-229 val_229
-472 val_472
-322 val_322
-498 val_498
-160 val_160
-195 val_195
-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
-449 val_449
-218 val_218
-30 val_30
-209 val_209
-76 val_76
-74 val_74
-342 val_342
-69 val_69
-230 val_230
-368 val_368
-296 val_296
-113 val_113
-216 val_216
-344 val_344
-274 val_274
-485 val_485
-223 val_223
-256 val_256
-263 val_263
-70 val_70
-487 val_487
-401 val_401
-191 val_191
-5 val_5
-438 val_438
-128 val_128
-467 val_467
-432 val_432
-229 val_229
-469 val_469
-463 val_463
-283 val_283
-331 val_331
-193 val_193
-335 val_335
-104 val_104
-366 val_366
-175 val_175
-403 val_403
-483 val_483
-409 val_409
-401 val_401
-258 val_258
-90 val_90
-203 val_203
-348 val_348
-12 val_12
-201 val_201
-164 val_164
-454 val_454
-478 val_478
-298 val_298
-164 val_164
-382 val_382
-5 val_5
-70 val_70
-397 val_397
-351 val_351
-104 val_104
-70 val_70
-438 val_438
-119 val_119
-414 val_414
-360 val_360
-199 val_199
-120 val_120
-429 val_429
-443 val_443
-230 val_230
-478 val_478
-317 val_317
-333 val_333
-207 val_207
-249 val_249
-265 val_265
-83 val_83
-353 val_353
-214 val_214
-133 val_133
-175 val_175
-454 val_454
-375 val_375
-401 val_401
-421 val_421
-407 val_407
-384 val_384
-256 val_256
-67 val_67
-384 val_384
-379 val_379
-18 val_18
-492 val_492
-100 val_100
-298 val_298
-9 val_9
-498 val_498
-146 val_146
-458 val_458
-362 val_362
-186 val_186
-285 val_285
-348 val_348
-18 val_18
-281 val_281
-344 val_344
-469 val_469
-315 val_315
-348 val_348
-414 val_414
-126 val_126
-90 val_90
-403 val_403
-474 val_475
-281 val_282
-179 val_180
-135 val_136
-423 val_424
-245 val_246
-425 val_426
-241 val_242
-177 val_178
-272 val_273
-287 val_288
-373 val_374
-447 val_448
-443 val_444
-175 val_176
-278 val_279
-296 val_297
-126 val_127
-249 val_250
-21 val_22
-441 val_442
-106 val_107
-371 val_372
-153 val_154
-490 val_491
-421 val_422
-243 val_244
-128 val_129
-10 val_11
-133 val_134
-333 val_334
-391 val_392
-485 val_486
-241 val_242
-85 val_86
-335 val_336
-476 val_477
-494 val_495
-94 val_95
-485 val_486
-393 val_394
-409 val_410
-50 val_51
-265 val_266
-128 val_129
-63 val_64
-344 val_345
-135 val_136
-3 val_4
-331 val_332
-209 val_210
-281 val_282
-56 val_57
-254 val_255
-304 val_305
-238 val_239
-492 val_493
-289 val_290
-421 val_422
-58 val_59
-5 val_6
-249 val_250
-438 val_439
-360 val_361
-467 val_468
-175 val_176
-429 val_430
-281 val_282
-16 val_17
-119 val_120
-492 val_493
-120 val_121
-306 val_307
-393 val_394
-427 val_428
-386 val_387
-65 val_66
-388 val_389
-184 val_185
-375 val_376
-191 val_192
-197 val_198
-122 val_123
-438 val_439
-351 val_352
-23 val_24
-328 val_329
-382 val_383
-342 val_343
-102 val_103
-487 val_488
-331 val_332
-409 val_410
-463 val_464
-177 val_178
-399 val_400
-476 val_477
-258 val_259
-252 val_253
-87 val_88
-340 val_341
-443 val_444
-407 val_408
-355 val_356
-164 val_165
-104 val_105
-117 val_118
-326 val_327
-47 val_48
-241 val_242
-450 val_451
-140 val_141
-212 val_213
-308 val_309
-30 val_31
-405 val_406
-119 val_120
-49 val_50
-153 val_154
-21 val_22
-157 val_158
-416 val_417
-199 val_200
-375 val_376
-89 val_90
-395 val_396
-386 val_387
-454 val_455
-364 val_365
-89 val_90
-461 val_462
-52 val_53
-168 val_169
-384 val_385
-313 val_314
-324 val_325
-69 val_70
-245 val_246
-328 val_329
-322 val_323
-122 val_123
-241 val_242
-469 val_470
-384 val_385
-76 val_77
-104 val_105
-481 val_482
-32 val_33
-58 val_59
-351 val_352
-70 val_71
-443 val_444
-399 val_400
-205 val_206
-52 val_53
-21 val_22
-317 val_318
-209 val_210
-429 val_430
-160 val_161
-267 val_268
-454 val_455
-76 val_77
-412 val_413
-16 val_17
-375 val_376
-489 val_490
-126 val_127
-274 val_275
-494 val_495
-216 val_217
-470 val_471
-302 val_303
-119 val_120
-375 val_376
-391 val_392
-287 val_288
-450 val_451
-375 val_376
-12 val_13
-384 val_385
-29 val_30
-151 val_152
-52 val_53
-300 val_301
-21 val_22
-104 val_105
-436 val_437
-61 val_62
-407 val_408
-335 val_336
-164 val_165
-371 val_372
-432 val_433
-496 val_497
-355 val_356
-144 val_145
-87 val_88
-382 val_383
-348 val_349
-122 val_123
-427 val_428
-292 val_293
-182 val_183
-474 val_475
-353 val_354
-52 val_53
-414 val_415
-261 val_262
-65 val_66
-371 val_372
-256 val_257
-292 val_293
-412 val_413
-49 val_50
-478 val_479
-243 val_244
-151 val_152
-100 val_101
-401 val_402
-117 val_118
-137 val_138
-162 val_163
-276 val_277
-78 val_79
-379 val_380
-410 val_411
-157 val_158
-100 val_101
-407 val_408
-371 val_372
-308 val_309
-430 val_431
-135 val_136
-76 val_77
-300 val_301
-337 val_338
-478 val_479
-1 val_2
-89 val_90
-29 val_30
-285 val_286
-227 val_228
-395 val_396
+ABSTRACT SYNTAX TREE:
+ (TOK_QUERY (TOK_FROM (TOK_TABREF srcbucket (TOK_TABLESAMPLE 1 2 key) s)) (TOK_INSERT (TOK_DESTINATION (TOK_TAB dest1)) (TOK_SELECT (TOK_SELEXPR (TOK_ALLCOLREF s)))))
+
+STAGE DEPENDENCIES:
+ Stage-1 is a root stage
+ Stage-0 depends on stages: Stage-1
+
+STAGE PLANS:
+ Stage: Stage-1
+ Map Reduce
+ Path -> Alias:
+ file:/data/zshao/trunk/VENDOR/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/srcbucket
+ Path -> Partition:
+ file:/data/zshao/trunk/VENDOR/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/srcbucket
+ Partition
+
+ properties:
+ name srcbucket
+ bucket_field_name
+ serialization.format 1
+ columns key,value
+ field_to_dimension
+ bucket_count 2
+ serialization.lib simple_meta
+ file.inputformat org.apache.hadoop.mapred.TextInputFormat
+ file.outputformat org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ location file:/data/zshao/trunk/VENDOR/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/srcbucket
+ name: srcbucket
+ serde: simple_meta
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ Alias -> Map Operator Tree:
+ s
+ Filter Operator
+ predicate:
+ expr: (((default_sample_hashfn(key) & 2147483647) % 2) = 1)
+ type: Boolean
+ Select Operator
+ expressions:
+ expr: key
+ type: string
+ expr: value
+ type: string
+ File Output Operator
+ table:
+ properties:
+ name dest1
+ bucket_field_name
+ serialization.format 1
+ columns key,value
+ SORTBUCKETCOLSPREFIX TRUE
+ field_to_dimension
+ bucket_count -1
+ serialization.lib simple_meta
+ file.inputformat org.apache.hadoop.mapred.TextInputFormat
+ file.outputformat org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ location file:/data/zshao/trunk/VENDOR/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/dest1
+ name: dest1
+ serde: simple_meta
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ directory: /tmp/hive-zshao/4031240.10000.insclause-0
+ Needs Tagging:
+
+ Stage: Stage-0
+ Move Operator
+ tables:
+ table:
+ properties:
+ name dest1
+ bucket_field_name
+ serialization.format 1
+ columns key,value
+ SORTBUCKETCOLSPREFIX TRUE
+ field_to_dimension
+ bucket_count -1
+ serialization.lib simple_meta
+ file.inputformat org.apache.hadoop.mapred.TextInputFormat
+ file.outputformat org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ location file:/data/zshao/trunk/VENDOR/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/dest1
+ name: dest1
+ serde: simple_meta
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ replace:
+ source: /tmp/hive-zshao/4031240.10000.insclause-0
+
+
+238 val_238
+311 val_311
+27 val_27
+409 val_409
+278 val_278
+98 val_98
+265 val_265
+193 val_193
+401 val_401
+128 val_128
+146 val_146
+429 val_429
+469 val_469
+281 val_281
+209 val_209
+403 val_403
+166 val_166
+430 val_430
+252 val_252
+292 val_292
+287 val_287
+153 val_153
+193 val_193
+494 val_494
+207 val_207
+199 val_199
+399 val_399
+247 val_247
+489 val_489
+162 val_162
+377 val_377
+397 val_397
+342 val_342
+195 val_195
+113 val_113
+155 val_155
+203 val_203
+339 val_339
+128 val_128
+311 val_311
+302 val_302
+205 val_205
+438 val_438
+489 val_489
+157 val_157
+221 val_221
+92 val_92
+111 val_111
+47 val_47
+72 val_72
+427 val_427
+399 val_399
+382 val_382
+498 val_498
+386 val_386
+469 val_469
+54 val_54
+216 val_216
+430 val_430
+278 val_278
+289 val_289
+221 val_221
+65 val_65
+311 val_311
+137 val_137
+241 val_241
+83 val_83
+333 val_333
+180 val_180
+12 val_12
+230 val_230
+67 val_67
+384 val_384
+489 val_489
+353 val_353
+373 val_373
+272 val_272
+348 val_348
+58 val_58
+230 val_230
+348 val_348
+463 val_463
+179 val_179
+119 val_119
+496 val_496
+322 val_322
+197 val_197
+393 val_393
+454 val_454
+100 val_100
+298 val_298
+199 val_199
+191 val_191
+418 val_418
+96 val_96
+230 val_230
+205 val_205
+120 val_120
+131 val_131
+43 val_43
+436 val_436
+469 val_469
+308 val_308
+481 val_481
+98 val_98
+197 val_197
+409 val_409
+470 val_470
+137 val_137
+85 val_85
+490 val_490
+87 val_87
+364 val_364
+179 val_179
+395 val_395
+238 val_238
+72 val_72
+90 val_90
+10 val_10
+306 val_306
+272 val_272
+331 val_331
+401 val_401
+452 val_452
+177 val_177
+5 val_5
+317 val_317
+395 val_395
+58 val_58
+168 val_168
+34 val_34
+229 val_229
+472 val_472
+322 val_322
+498 val_498
+160 val_160
+195 val_195
+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
+449 val_449
+218 val_218
+30 val_30
+209 val_209
+76 val_76
+74 val_74
+342 val_342
+69 val_69
+230 val_230
+368 val_368
+296 val_296
+113 val_113
+216 val_216
+344 val_344
+274 val_274
+485 val_485
+223 val_223
+256 val_256
+263 val_263
+70 val_70
+487 val_487
+401 val_401
+191 val_191
+5 val_5
+438 val_438
+128 val_128
+467 val_467
+432 val_432
+229 val_229
+469 val_469
+463 val_463
+283 val_283
+331 val_331
+193 val_193
+335 val_335
+104 val_104
+366 val_366
+175 val_175
+403 val_403
+483 val_483
+409 val_409
+401 val_401
+258 val_258
+90 val_90
+203 val_203
+348 val_348
+12 val_12
+201 val_201
+164 val_164
+454 val_454
+478 val_478
+298 val_298
+164 val_164
+382 val_382
+5 val_5
+70 val_70
+397 val_397
+351 val_351
+104 val_104
+70 val_70
+438 val_438
+119 val_119
+414 val_414
+360 val_360
+199 val_199
+120 val_120
+429 val_429
+443 val_443
+230 val_230
+478 val_478
+317 val_317
+333 val_333
+207 val_207
+249 val_249
+265 val_265
+83 val_83
+353 val_353
+214 val_214
+133 val_133
+175 val_175
+454 val_454
+375 val_375
+401 val_401
+421 val_421
+407 val_407
+384 val_384
+256 val_256
+67 val_67
+384 val_384
+379 val_379
+18 val_18
+492 val_492
+100 val_100
+298 val_298
+9 val_9
+498 val_498
+146 val_146
+458 val_458
+362 val_362
+186 val_186
+285 val_285
+348 val_348
+18 val_18
+281 val_281
+344 val_344
+469 val_469
+315 val_315
+348 val_348
+414 val_414
+126 val_126
+90 val_90
+403 val_403
+
+474 val_475
+281 val_282
+179 val_180
+135 val_136
+423 val_424
+245 val_246
+425 val_426
+241 val_242
+177 val_178
+272 val_273
+287 val_288
+373 val_374
+447 val_448
+443 val_444
+175 val_176
+278 val_279
+296 val_297
+126 val_127
+249 val_250
+21 val_22
+441 val_442
+106 val_107
+371 val_372
+153 val_154
+490 val_491
+421 val_422
+243 val_244
+128 val_129
+10 val_11
+133 val_134
+333 val_334
+391 val_392
+485 val_486
+241 val_242
+85 val_86
+335 val_336
+476 val_477
+494 val_495
+94 val_95
+485 val_486
+393 val_394
+409 val_410
+50 val_51
+265 val_266
+128 val_129
+63 val_64
+344 val_345
+135 val_136
+3 val_4
+331 val_332
+209 val_210
+281 val_282
+56 val_57
+254 val_255
+304 val_305
+238 val_239
+492 val_493
+289 val_290
+421 val_422
+58 val_59
+5 val_6
+249 val_250
+438 val_439
+360 val_361
+467 val_468
+175 val_176
+429 val_430
+281 val_282
+16 val_17
+119 val_120
+492 val_493
+120 val_121
+306 val_307
+393 val_394
+427 val_428
+386 val_387
+65 val_66
+388 val_389
+184 val_185
+375 val_376
+191 val_192
+197 val_198
+122 val_123
+438 val_439
+351 val_352
+23 val_24
+328 val_329
+382 val_383
+342 val_343
+102 val_103
+487 val_488
+331 val_332
+409 val_410
+463 val_464
+177 val_178
+399 val_400
+476 val_477
+258 val_259
+252 val_253
+87 val_88
+340 val_341
+443 val_444
+407 val_408
+355 val_356
+164 val_165
+104 val_105
+117 val_118
+326 val_327
+47 val_48
+241 val_242
+450 val_451
+140 val_141
+212 val_213
+308 val_309
+30 val_31
+405 val_406
+119 val_120
+49 val_50
+153 val_154
+21 val_22
+157 val_158
+416 val_417
+199 val_200
+375 val_376
+89 val_90
+395 val_396
+386 val_387
+454 val_455
+364 val_365
+89 val_90
+461 val_462
+52 val_53
+168 val_169
+384 val_385
+313 val_314
+324 val_325
+69 val_70
+245 val_246
+328 val_329
+322 val_323
+122 val_123
+241 val_242
+469 val_470
+384 val_385
+76 val_77
+104 val_105
+481 val_482
+32 val_33
+58 val_59
+351 val_352
+70 val_71
+443 val_444
+399 val_400
+205 val_206
+52 val_53
+21 val_22
+317 val_318
+209 val_210
+429 val_430
+160 val_161
+267 val_268
+454 val_455
+76 val_77
+412 val_413
+16 val_17
+375 val_376
+489 val_490
+126 val_127
+274 val_275
+494 val_495
+216 val_217
+470 val_471
+302 val_303
+119 val_120
+375 val_376
+391 val_392
+287 val_288
+450 val_451
+375 val_376
+12 val_13
+384 val_385
+29 val_30
+151 val_152
+52 val_53
+300 val_301
+21 val_22
+104 val_105
+436 val_437
+61 val_62
+407 val_408
+335 val_336
+164 val_165
+371 val_372
+432 val_433
+496 val_497
+355 val_356
+144 val_145
+87 val_88
+382 val_383
+348 val_349
+122 val_123
+427 val_428
+292 val_293
+182 val_183
+474 val_475
+353 val_354
+52 val_53
+414 val_415
+261 val_262
+65 val_66
+371 val_372
+256 val_257
+292 val_293
+412 val_413
+49 val_50
+478 val_479
+243 val_244
+151 val_152
+100 val_101
+401 val_402
+117 val_118
+137 val_138
+162 val_163
+276 val_277
+78 val_79
+379 val_380
+410 val_411
+157 val_158
+100 val_101
+407 val_408
+371 val_372
+308 val_309
+430 val_431
+135 val_136
+76 val_77
+300 val_301
+337 val_338
+478 val_479
+1 val_2
+89 val_90
+29 val_30
+285 val_286
+227 val_228
+395 val_396
+
Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/sample5.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/sample5.q.out?rev=697291&r1=697290&r2=697291&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/sample5.q.out (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/sample5.q.out Fri Sep 19 16:56:30 2008
@@ -1,277 +1,282 @@
-ABSTRACT SYNTAX TREE:
- (TOK_QUERY (TOK_FROM (TOK_TABREF srcbucket (TOK_TABLESAMPLE 1 5 key) s)) (TOK_INSERT (TOK_DESTINATION (TOK_TAB dest1)) (TOK_SELECT (TOK_SELEXPR (TOK_ALLCOLREF s)))))
-
-STAGE DEPENDENCIES:
- Stage-1 is a root stage
- Stage-0 depends on stages: Stage-1
-
-STAGE PLANS:
- Stage: Stage-1
- Map Reduce
- Path -> Alias:
- file:/home/athusoo/projects/hadoop/trunk/VENDOR/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/srcbucket
- Path -> Partition:
- file:/home/athusoo/projects/hadoop/trunk/VENDOR/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/srcbucket
- Partition
-
- properties:
- name srcbucket
- bucket_field_name
- serialization.format 1
- columns key,value
- field_to_dimension
- bucket_count 2
- serialization.lib simple_meta
- file.inputformat org.apache.hadoop.mapred.TextInputFormat
- file.outputformat org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
- location file:/home/athusoo/projects/hadoop/trunk/VENDOR/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/srcbucket
- name: srcbucket
- serde: simple_meta
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
- Alias -> Map Operator Tree:
- s
- Filter Operator
- predicate:
- expr: (((default_sample_hashfn(key) & 2147483647) % 5) = 1)
- type: class java.lang.Boolean
- Select Operator
- expressions:
- expr: key
- type: class java.lang.String
- expr: value
- type: class java.lang.String
- File Output Operator
- table:
- properties:
- name dest1
- bucket_field_name
- serialization.format 1
- columns key,value
- field_to_dimension
- bucket_count -1
- serialization.lib org.apache.hadoop.hive.serde.simple_meta.MetadataTypedColumnsetSerDe
- file.inputformat org.apache.hadoop.mapred.TextInputFormat
- file.outputformat org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
- location file:/home/athusoo/projects/hadoop/trunk/VENDOR/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/dest1
- name: dest1
- serde: org.apache.hadoop.hive.serde.simple_meta.MetadataTypedColumnsetSerDe
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
- directory: /tmp/hive-athusoo/238899095.10000.insclause-0
- Needs Tagging:
-
- Stage: Stage-0
- Move Operator
- tables:
- table:
- properties:
- name dest1
- bucket_field_name
- serialization.format 1
- columns key,value
- field_to_dimension
- bucket_count -1
- serialization.lib org.apache.hadoop.hive.serde.simple_meta.MetadataTypedColumnsetSerDe
- file.inputformat org.apache.hadoop.mapred.TextInputFormat
- file.outputformat org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
- location file:/home/athusoo/projects/hadoop/trunk/VENDOR/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/dest1
- name: dest1
- serde: org.apache.hadoop.hive.serde.simple_meta.MetadataTypedColumnsetSerDe
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
- replace:
- source: /tmp/hive-athusoo/238899095.10000.insclause-0
-
-165 val_165
-255 val_255
-278 val_278
-273 val_273
-37 val_37
-327 val_327
-82 val_82
-403 val_403
-417 val_417
-430 val_430
-219 val_219
-287 val_287
-237 val_237
-174 val_174
-494 val_494
-174 val_174
-417 val_417
-377 val_377
-309 val_309
-205 val_205
-345 val_345
-129 val_129
-386 val_386
-192 val_192
-138 val_138
-430 val_430
-278 val_278
-318 val_318
-241 val_241
-138 val_138
-8 val_8
-179 val_179
-129 val_129
-322 val_322
-197 val_197
-96 val_96
-165 val_165
-327 val_327
-205 val_205
-156 val_156
-282 val_282
-197 val_197
-318 val_318
-318 val_318
-87 val_87
-179 val_179
-395 val_395
-282 val_282
-138 val_138
-19 val_19
-435 val_435
-273 val_273
-309 val_309
-327 val_327
-331 val_331
-395 val_395
-336 val_336
-322 val_322
-160 val_160
-430 val_430
-458 val_458
-78 val_78
-41 val_41
-223 val_223
-449 val_449
-228 val_228
-138 val_138
-453 val_453
-64 val_64
-69 val_69
-368 val_368
-296 val_296
-219 val_219
-485 val_485
-223 val_223
-480 val_480
-467 val_467
-331 val_331
-403 val_403
-480 val_480
-291 val_291
-255 val_255
-200 val_200
-237 val_237
-417 val_417
-444 val_444
-480 val_480
-214 val_214
-462 val_462
-133 val_133
-421 val_421
-462 val_462
-458 val_458
-273 val_273
-183 val_183
-28 val_28
-37 val_37
-403 val_403
-200 val_200
-179 val_180
-291 val_292
-241 val_242
-287 val_288
-246 val_247
-278 val_279
-296 val_297
-147 val_148
-273 val_274
-106 val_107
-421 val_422
-133 val_134
-110 val_111
-485 val_486
-241 val_242
-408 val_409
-476 val_477
-494 val_495
-485 val_486
-50 val_51
-3 val_4
-101 val_102
-331 val_332
-390 val_391
-165 val_166
-304 val_305
-264 val_265
-129 val_130
-453 val_454
-421 val_422
-82 val_83
-467 val_468
-147 val_148
-291 val_292
-426 val_427
-386 val_387
-129 val_130
-246 val_247
-197 val_198
-390 val_391
-23 val_24
-480 val_481
-480 val_481
-331 val_332
-183 val_184
-318 val_319
-476 val_477
-174 val_175
-87 val_88
-264 val_265
-336 val_337
-340 val_341
-390 val_391
-363 val_364
-19 val_20
-241 val_242
-363 val_364
-395 val_396
-386 val_387
-8 val_9
-313 val_314
-381 val_382
-69 val_70
-322 val_323
-241 val_242
-32 val_33
-192 val_193
-205 val_206
-138 val_139
-160 val_161
-174 val_175
-412 val_413
-494 val_495
-287 val_288
-435 val_436
-151 val_152
-156 val_157
-462 val_463
-87 val_88
-408 val_409
-412 val_413
-151 val_152
-156 val_157
-228 val_229
-363 val_364
-46 val_47
-78 val_79
-82 val_83
-430 val_431
-309 val_310
-138 val_139
-91 val_92
-395 val_396
+ABSTRACT SYNTAX TREE:
+ (TOK_QUERY (TOK_FROM (TOK_TABREF srcbucket (TOK_TABLESAMPLE 1 5 key) s)) (TOK_INSERT (TOK_DESTINATION (TOK_TAB dest1)) (TOK_SELECT (TOK_SELEXPR (TOK_ALLCOLREF s)))))
+
+STAGE DEPENDENCIES:
+ Stage-1 is a root stage
+ Stage-0 depends on stages: Stage-1
+
+STAGE PLANS:
+ Stage: Stage-1
+ Map Reduce
+ Path -> Alias:
+ file:/data/zshao/trunk/VENDOR/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/srcbucket
+ Path -> Partition:
+ file:/data/zshao/trunk/VENDOR/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/srcbucket
+ Partition
+
+ properties:
+ name srcbucket
+ bucket_field_name
+ serialization.format 1
+ columns key,value
+ field_to_dimension
+ bucket_count 2
+ serialization.lib simple_meta
+ file.inputformat org.apache.hadoop.mapred.TextInputFormat
+ file.outputformat org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ location file:/data/zshao/trunk/VENDOR/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/srcbucket
+ name: srcbucket
+ serde: simple_meta
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ Alias -> Map Operator Tree:
+ s
+ Filter Operator
+ predicate:
+ expr: (((default_sample_hashfn(key) & 2147483647) % 5) = 1)
+ type: Boolean
+ Select Operator
+ expressions:
+ expr: key
+ type: string
+ expr: value
+ type: string
+ File Output Operator
+ table:
+ properties:
+ name dest1
+ bucket_field_name
+ serialization.format 1
+ columns key,value
+ SORTBUCKETCOLSPREFIX TRUE
+ field_to_dimension
+ bucket_count -1
+ serialization.lib simple_meta
+ file.inputformat org.apache.hadoop.mapred.TextInputFormat
+ file.outputformat org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ location file:/data/zshao/trunk/VENDOR/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/dest1
+ name: dest1
+ serde: simple_meta
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ directory: /tmp/hive-zshao/824052972.10000.insclause-0
+ Needs Tagging:
+
+ Stage: Stage-0
+ Move Operator
+ tables:
+ table:
+ properties:
+ name dest1
+ bucket_field_name
+ serialization.format 1
+ columns key,value
+ SORTBUCKETCOLSPREFIX TRUE
+ field_to_dimension
+ bucket_count -1
+ serialization.lib simple_meta
+ file.inputformat org.apache.hadoop.mapred.TextInputFormat
+ file.outputformat org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ location file:/data/zshao/trunk/VENDOR/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/dest1
+ name: dest1
+ serde: simple_meta
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ replace:
+ source: /tmp/hive-zshao/824052972.10000.insclause-0
+
+
+165 val_165
+255 val_255
+278 val_278
+273 val_273
+37 val_37
+327 val_327
+82 val_82
+403 val_403
+417 val_417
+430 val_430
+219 val_219
+287 val_287
+237 val_237
+174 val_174
+494 val_494
+174 val_174
+417 val_417
+377 val_377
+309 val_309
+205 val_205
+345 val_345
+129 val_129
+386 val_386
+192 val_192
+138 val_138
+430 val_430
+278 val_278
+318 val_318
+241 val_241
+138 val_138
+8 val_8
+179 val_179
+129 val_129
+322 val_322
+197 val_197
+96 val_96
+165 val_165
+327 val_327
+205 val_205
+156 val_156
+282 val_282
+197 val_197
+318 val_318
+318 val_318
+87 val_87
+179 val_179
+395 val_395
+282 val_282
+138 val_138
+19 val_19
+435 val_435
+273 val_273
+309 val_309
+327 val_327
+331 val_331
+395 val_395
+336 val_336
+322 val_322
+160 val_160
+430 val_430
+458 val_458
+78 val_78
+41 val_41
+223 val_223
+449 val_449
+228 val_228
+138 val_138
+453 val_453
+64 val_64
+69 val_69
+368 val_368
+296 val_296
+219 val_219
+485 val_485
+223 val_223
+480 val_480
+467 val_467
+331 val_331
+403 val_403
+480 val_480
+291 val_291
+255 val_255
+200 val_200
+237 val_237
+417 val_417
+444 val_444
+480 val_480
+214 val_214
+462 val_462
+133 val_133
+421 val_421
+462 val_462
+458 val_458
+273 val_273
+183 val_183
+28 val_28
+37 val_37
+403 val_403
+200 val_200
+
+179 val_180
+291 val_292
+241 val_242
+287 val_288
+246 val_247
+278 val_279
+296 val_297
+147 val_148
+273 val_274
+106 val_107
+421 val_422
+133 val_134
+110 val_111
+485 val_486
+241 val_242
+408 val_409
+476 val_477
+494 val_495
+485 val_486
+50 val_51
+3 val_4
+101 val_102
+331 val_332
+390 val_391
+165 val_166
+304 val_305
+264 val_265
+129 val_130
+453 val_454
+421 val_422
+82 val_83
+467 val_468
+147 val_148
+291 val_292
+426 val_427
+386 val_387
+129 val_130
+246 val_247
+197 val_198
+390 val_391
+23 val_24
+480 val_481
+480 val_481
+331 val_332
+183 val_184
+318 val_319
+476 val_477
+174 val_175
+87 val_88
+264 val_265
+336 val_337
+340 val_341
+390 val_391
+363 val_364
+19 val_20
+241 val_242
+363 val_364
+395 val_396
+386 val_387
+8 val_9
+313 val_314
+381 val_382
+69 val_70
+322 val_323
+241 val_242
+32 val_33
+192 val_193
+205 val_206
+138 val_139
+160 val_161
+174 val_175
+412 val_413
+494 val_495
+287 val_288
+435 val_436
+151 val_152
+156 val_157
+462 val_463
+87 val_88
+408 val_409
+412 val_413
+151 val_152
+156 val_157
+228 val_229
+363 val_364
+46 val_47
+78 val_79
+82 val_83
+430 val_431
+309 val_310
+138 val_139
+91 val_92
+395 val_396
+
Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/sample6.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/sample6.q.out?rev=697291&r1=697290&r2=697291&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/sample6.q.out (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/sample6.q.out Fri Sep 19 16:56:30 2008
@@ -1,320 +1,325 @@
-ABSTRACT SYNTAX TREE:
- (TOK_QUERY (TOK_FROM (TOK_TABREF srcbucket (TOK_TABLESAMPLE 1 4 key) s)) (TOK_INSERT (TOK_DESTINATION (TOK_TAB dest1)) (TOK_SELECT (TOK_SELEXPR (TOK_ALLCOLREF s)))))
-
-STAGE DEPENDENCIES:
- Stage-1 is a root stage
- Stage-0 depends on stages: Stage-1
-
-STAGE PLANS:
- Stage: Stage-1
- Map Reduce
- Path -> Alias:
- file:/home/athusoo/projects/hadoop/trunk/VENDOR/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/srcbucket
- Path -> Partition:
- file:/home/athusoo/projects/hadoop/trunk/VENDOR/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/srcbucket
- Partition
-
- properties:
- name srcbucket
- bucket_field_name
- serialization.format 1
- columns key,value
- field_to_dimension
- bucket_count 2
- serialization.lib simple_meta
- file.inputformat org.apache.hadoop.mapred.TextInputFormat
- file.outputformat org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
- location file:/home/athusoo/projects/hadoop/trunk/VENDOR/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/srcbucket
- name: srcbucket
- serde: simple_meta
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
- Alias -> Map Operator Tree:
- s
- Filter Operator
- predicate:
- expr: (((default_sample_hashfn(key) & 2147483647) % 4) = 1)
- type: class java.lang.Boolean
- Select Operator
- expressions:
- expr: key
- type: class java.lang.String
- expr: value
- type: class java.lang.String
- File Output Operator
- table:
- properties:
- name dest1
- bucket_field_name
- serialization.format 1
- columns key,value
- field_to_dimension
- bucket_count -1
- serialization.lib org.apache.hadoop.hive.serde.simple_meta.MetadataTypedColumnsetSerDe
- file.inputformat org.apache.hadoop.mapred.TextInputFormat
- file.outputformat org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
- location file:/home/athusoo/projects/hadoop/trunk/VENDOR/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/dest1
- name: dest1
- serde: org.apache.hadoop.hive.serde.simple_meta.MetadataTypedColumnsetSerDe
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
- directory: /tmp/hive-athusoo/288432544.10000.insclause-0
- Needs Tagging:
-
- Stage: Stage-0
- Move Operator
- tables:
- table:
- properties:
- name dest1
- bucket_field_name
- serialization.format 1
- columns key,value
- field_to_dimension
- bucket_count -1
- serialization.lib org.apache.hadoop.hive.serde.simple_meta.MetadataTypedColumnsetSerDe
- file.inputformat org.apache.hadoop.mapred.TextInputFormat
- file.outputformat org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
- location file:/home/athusoo/projects/hadoop/trunk/VENDOR/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/dest1
- name: dest1
- serde: org.apache.hadoop.hive.serde.simple_meta.MetadataTypedColumnsetSerDe
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
- replace:
- source: /tmp/hive-athusoo/288432544.10000.insclause-0
-
-27 val_27
-409 val_409
-265 val_265
-401 val_401
-166 val_166
-430 val_430
-287 val_287
-207 val_207
-199 val_199
-247 val_247
-489 val_489
-162 val_162
-397 val_397
-342 val_342
-195 val_195
-155 val_155
-203 val_203
-339 val_339
-302 val_302
-438 val_438
-489 val_489
-221 val_221
-92 val_92
-111 val_111
-427 val_427
-382 val_382
-386 val_386
-430 val_430
-221 val_221
-137 val_137
-180 val_180
-12 val_12
-67 val_67
-489 val_489
-353 val_353
-272 val_272
-463 val_463
-119 val_119
-496 val_496
-393 val_393
-100 val_100
-298 val_298
-199 val_199
-191 val_191
-96 val_96
-481 val_481
-409 val_409
-470 val_470
-137 val_137
-85 val_85
-364 val_364
-306 val_306
-272 val_272
-331 val_331
-401 val_401
-452 val_452
-177 val_177
-5 val_5
-317 val_317
-34 val_34
-229 val_229
-195 val_195
-430 val_430
-119 val_119
-489 val_489
-78 val_78
-41 val_41
-492 val_492
-449 val_449
-218 val_218
-30 val_30
-74 val_74
-342 val_342
-368 val_368
-485 val_485
-70 val_70
-401 val_401
-191 val_191
-5 val_5
-438 val_438
-467 val_467
-229 val_229
-463 val_463
-283 val_283
-331 val_331
-335 val_335
-104 val_104
-409 val_409
-401 val_401
-258 val_258
-203 val_203
-12 val_12
-478 val_478
-298 val_298
-382 val_382
-5 val_5
-70 val_70
-397 val_397
-104 val_104
-70 val_70
-438 val_438
-119 val_119
-360 val_360
-199 val_199
-478 val_478
-317 val_317
-207 val_207
-265 val_265
-353 val_353
-214 val_214
-133 val_133
-375 val_375
-401 val_401
-67 val_67
-379 val_379
-492 val_492
-100 val_100
-298 val_298
-9 val_9
-126 val_126
-474 val_475
-423 val_424
-177 val_178
-272 val_273
-287 val_288
-126 val_127
-441 val_442
-371 val_372
-243 val_244
-133 val_134
-485 val_486
-85 val_86
-335 val_336
-485 val_486
-393 val_394
-409 val_410
-265 val_266
-63 val_64
-331 val_332
-56 val_57
-254 val_255
-492 val_493
-5 val_6
-438 val_439
-360 val_361
-467 val_468
-16 val_17
-119 val_120
-492 val_493
-306 val_307
-393 val_394
-427 val_428
-386 val_387
-184 val_185
-375 val_376
-191 val_192
-122 val_123
-438 val_439
-23 val_24
-328 val_329
-382 val_383
-342 val_343
-331 val_332
-409 val_410
-463 val_464
-177 val_178
-258 val_259
-104 val_105
-140 val_141
-30 val_31
-405 val_406
-119 val_120
-49 val_50
-416 val_417
-199 val_200
-375 val_376
-89 val_90
-386 val_387
-364 val_365
-89 val_90
-52 val_53
-313 val_314
-324 val_325
-328 val_329
-122 val_123
-104 val_105
-481 val_482
-70 val_71
-52 val_53
-317 val_318
-412 val_413
-16 val_17
-375 val_376
-489 val_490
-126 val_127
-470 val_471
-302 val_303
-119 val_120
-375 val_376
-287 val_288
-375 val_376
-12 val_13
-151 val_152
-52 val_53
-104 val_105
-335 val_336
-371 val_372
-496 val_497
-144 val_145
-382 val_383
-122 val_123
-427 val_428
-474 val_475
-353 val_354
-52 val_53
-261 val_262
-371 val_372
-412 val_413
-49 val_50
-478 val_479
-243 val_244
-151 val_152
-100 val_101
-401 val_402
-137 val_138
-162 val_163
-276 val_277
-78 val_79
-379 val_380
-100 val_101
-371 val_372
-430 val_431
-478 val_479
-1 val_2
-89 val_90
+ABSTRACT SYNTAX TREE:
+ (TOK_QUERY (TOK_FROM (TOK_TABREF srcbucket (TOK_TABLESAMPLE 1 4 key) s)) (TOK_INSERT (TOK_DESTINATION (TOK_TAB dest1)) (TOK_SELECT (TOK_SELEXPR (TOK_ALLCOLREF s)))))
+
+STAGE DEPENDENCIES:
+ Stage-1 is a root stage
+ Stage-0 depends on stages: Stage-1
+
+STAGE PLANS:
+ Stage: Stage-1
+ Map Reduce
+ Path -> Alias:
+ file:/data/zshao/trunk/VENDOR/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/srcbucket
+ Path -> Partition:
+ file:/data/zshao/trunk/VENDOR/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/srcbucket
+ Partition
+
+ properties:
+ name srcbucket
+ bucket_field_name
+ serialization.format 1
+ columns key,value
+ field_to_dimension
+ bucket_count 2
+ serialization.lib simple_meta
+ file.inputformat org.apache.hadoop.mapred.TextInputFormat
+ file.outputformat org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ location file:/data/zshao/trunk/VENDOR/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/srcbucket
+ name: srcbucket
+ serde: simple_meta
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ Alias -> Map Operator Tree:
+ s
+ Filter Operator
+ predicate:
+ expr: (((default_sample_hashfn(key) & 2147483647) % 4) = 1)
+ type: Boolean
+ Select Operator
+ expressions:
+ expr: key
+ type: string
+ expr: value
+ type: string
+ File Output Operator
+ table:
+ properties:
+ name dest1
+ bucket_field_name
+ serialization.format 1
+ columns key,value
+ SORTBUCKETCOLSPREFIX TRUE
+ field_to_dimension
+ bucket_count -1
+ serialization.lib simple_meta
+ file.inputformat org.apache.hadoop.mapred.TextInputFormat
+ file.outputformat org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ location file:/data/zshao/trunk/VENDOR/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/dest1
+ name: dest1
+ serde: simple_meta
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ directory: /tmp/hive-zshao/6950986.10000.insclause-0
+ Needs Tagging:
+
+ Stage: Stage-0
+ Move Operator
+ tables:
+ table:
+ properties:
+ name dest1
+ bucket_field_name
+ serialization.format 1
+ columns key,value
+ SORTBUCKETCOLSPREFIX TRUE
+ field_to_dimension
+ bucket_count -1
+ serialization.lib simple_meta
+ file.inputformat org.apache.hadoop.mapred.TextInputFormat
+ file.outputformat org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ location file:/data/zshao/trunk/VENDOR/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/dest1
+ name: dest1
+ serde: simple_meta
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ replace:
+ source: /tmp/hive-zshao/6950986.10000.insclause-0
+
+
+27 val_27
+409 val_409
+265 val_265
+401 val_401
+166 val_166
+430 val_430
+287 val_287
+207 val_207
+199 val_199
+247 val_247
+489 val_489
+162 val_162
+397 val_397
+342 val_342
+195 val_195
+155 val_155
+203 val_203
+339 val_339
+302 val_302
+438 val_438
+489 val_489
+221 val_221
+92 val_92
+111 val_111
+427 val_427
+382 val_382
+386 val_386
+430 val_430
+221 val_221
+137 val_137
+180 val_180
+12 val_12
+67 val_67
+489 val_489
+353 val_353
+272 val_272
+463 val_463
+119 val_119
+496 val_496
+393 val_393
+100 val_100
+298 val_298
+199 val_199
+191 val_191
+96 val_96
+481 val_481
+409 val_409
+470 val_470
+137 val_137
+85 val_85
+364 val_364
+306 val_306
+272 val_272
+331 val_331
+401 val_401
+452 val_452
+177 val_177
+5 val_5
+317 val_317
+34 val_34
+229 val_229
+195 val_195
+430 val_430
+119 val_119
+489 val_489
+78 val_78
+41 val_41
+492 val_492
+449 val_449
+218 val_218
+30 val_30
+74 val_74
+342 val_342
+368 val_368
+485 val_485
+70 val_70
+401 val_401
+191 val_191
+5 val_5
+438 val_438
+467 val_467
+229 val_229
+463 val_463
+283 val_283
+331 val_331
+335 val_335
+104 val_104
+409 val_409
+401 val_401
+258 val_258
+203 val_203
+12 val_12
+478 val_478
+298 val_298
+382 val_382
+5 val_5
+70 val_70
+397 val_397
+104 val_104
+70 val_70
+438 val_438
+119 val_119
+360 val_360
+199 val_199
+478 val_478
+317 val_317
+207 val_207
+265 val_265
+353 val_353
+214 val_214
+133 val_133
+375 val_375
+401 val_401
+67 val_67
+379 val_379
+492 val_492
+100 val_100
+298 val_298
+9 val_9
+126 val_126
+
+474 val_475
+423 val_424
+177 val_178
+272 val_273
+287 val_288
+126 val_127
+441 val_442
+371 val_372
+243 val_244
+133 val_134
+485 val_486
+85 val_86
+335 val_336
+485 val_486
+393 val_394
+409 val_410
+265 val_266
+63 val_64
+331 val_332
+56 val_57
+254 val_255
+492 val_493
+5 val_6
+438 val_439
+360 val_361
+467 val_468
+16 val_17
+119 val_120
+492 val_493
+306 val_307
+393 val_394
+427 val_428
+386 val_387
+184 val_185
+375 val_376
+191 val_192
+122 val_123
+438 val_439
+23 val_24
+328 val_329
+382 val_383
+342 val_343
+331 val_332
+409 val_410
+463 val_464
+177 val_178
+258 val_259
+104 val_105
+140 val_141
+30 val_31
+405 val_406
+119 val_120
+49 val_50
+416 val_417
+199 val_200
+375 val_376
+89 val_90
+386 val_387
+364 val_365
+89 val_90
+52 val_53
+313 val_314
+324 val_325
+328 val_329
+122 val_123
+104 val_105
+481 val_482
+70 val_71
+52 val_53
+317 val_318
+412 val_413
+16 val_17
+375 val_376
+489 val_490
+126 val_127
+470 val_471
+302 val_303
+119 val_120
+375 val_376
+287 val_288
+375 val_376
+12 val_13
+151 val_152
+52 val_53
+104 val_105
+335 val_336
+371 val_372
+496 val_497
+144 val_145
+382 val_383
+122 val_123
+427 val_428
+474 val_475
+353 val_354
+52 val_53
+261 val_262
+371 val_372
+412 val_413
+49 val_50
+478 val_479
+243 val_244
+151 val_152
+100 val_101
+401 val_402
+137 val_138
+162 val_163
+276 val_277
+78 val_79
+379 val_380
+100 val_101
+371 val_372
+430 val_431
+478 val_479
+1 val_2
+89 val_90
+
Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/sample7.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/sample7.q.out?rev=697291&r1=697290&r2=697291&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/sample7.q.out (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/sample7.q.out Fri Sep 19 16:56:30 2008
@@ -1,279 +1,284 @@
-ABSTRACT SYNTAX TREE:
- (TOK_QUERY (TOK_FROM (TOK_TABREF srcbucket (TOK_TABLESAMPLE 1 4 key) s)) (TOK_INSERT (TOK_DESTINATION (TOK_TAB dest1)) (TOK_SELECT (TOK_SELEXPR (TOK_ALLCOLREF s))) (TOK_WHERE (> (TOK_COLREF s key) 100))))
-
-STAGE DEPENDENCIES:
- Stage-1 is a root stage
- Stage-0 depends on stages: Stage-1
-
-STAGE PLANS:
- Stage: Stage-1
- Map Reduce
- Path -> Alias:
- file:/home/athusoo/projects/hadoop/trunk/VENDOR/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/srcbucket
- Path -> Partition:
- file:/home/athusoo/projects/hadoop/trunk/VENDOR/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/srcbucket
- Partition
-
- properties:
- name srcbucket
- bucket_field_name
- serialization.format 1
- columns key,value
- field_to_dimension
- bucket_count 2
- serialization.lib simple_meta
- file.inputformat org.apache.hadoop.mapred.TextInputFormat
- file.outputformat org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
- location file:/home/athusoo/projects/hadoop/trunk/VENDOR/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/srcbucket
- name: srcbucket
- serde: simple_meta
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
- Alias -> Map Operator Tree:
- s
- Filter Operator
- predicate:
- expr: (((default_sample_hashfn(key) & 2147483647) % 4) = 1)
- type: class java.lang.Boolean
- Filter Operator
- predicate:
- expr: (key > 100)
- type: class java.lang.Boolean
- Select Operator
- expressions:
- expr: key
- type: class java.lang.String
- expr: value
- type: class java.lang.String
- File Output Operator
- table:
- properties:
- name dest1
- bucket_field_name
- serialization.format 1
- columns key,value
- field_to_dimension
- bucket_count -1
- serialization.lib org.apache.hadoop.hive.serde.simple_meta.MetadataTypedColumnsetSerDe
- file.inputformat org.apache.hadoop.mapred.TextInputFormat
- file.outputformat org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
- location file:/home/athusoo/projects/hadoop/trunk/VENDOR/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/dest1
- name: dest1
- serde: org.apache.hadoop.hive.serde.simple_meta.MetadataTypedColumnsetSerDe
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
- directory: /tmp/hive-athusoo/631893552.10000.insclause-0
- Needs Tagging:
-
- Stage: Stage-0
- Move Operator
- tables:
- table:
- properties:
- name dest1
- bucket_field_name
- serialization.format 1
- columns key,value
- field_to_dimension
- bucket_count -1
- serialization.lib org.apache.hadoop.hive.serde.simple_meta.MetadataTypedColumnsetSerDe
- file.inputformat org.apache.hadoop.mapred.TextInputFormat
- file.outputformat org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
- location file:/home/athusoo/projects/hadoop/trunk/VENDOR/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/dest1
- name: dest1
- serde: org.apache.hadoop.hive.serde.simple_meta.MetadataTypedColumnsetSerDe
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
- replace:
- source: /tmp/hive-athusoo/631893552.10000.insclause-0
-
-409 val_409
-265 val_265
-401 val_401
-166 val_166
-430 val_430
-287 val_287
-207 val_207
-199 val_199
-247 val_247
-489 val_489
-162 val_162
-397 val_397
-342 val_342
-195 val_195
-155 val_155
-203 val_203
-339 val_339
-302 val_302
-438 val_438
-489 val_489
-221 val_221
-111 val_111
-427 val_427
-382 val_382
-386 val_386
-430 val_430
-221 val_221
-137 val_137
-180 val_180
-489 val_489
-353 val_353
-272 val_272
-463 val_463
-119 val_119
-496 val_496
-393 val_393
-298 val_298
-199 val_199
-191 val_191
-481 val_481
-409 val_409
-470 val_470
-137 val_137
-364 val_364
-306 val_306
-272 val_272
-331 val_331
-401 val_401
-452 val_452
-177 val_177
-317 val_317
-229 val_229
-195 val_195
-430 val_430
-119 val_119
-489 val_489
-492 val_492
-449 val_449
-218 val_218
-342 val_342
-368 val_368
-485 val_485
-401 val_401
-191 val_191
-438 val_438
-467 val_467
-229 val_229
-463 val_463
-283 val_283
-331 val_331
-335 val_335
-104 val_104
-409 val_409
-401 val_401
-258 val_258
-203 val_203
-478 val_478
-298 val_298
-382 val_382
-397 val_397
-104 val_104
-438 val_438
-119 val_119
-360 val_360
-199 val_199
-478 val_478
-317 val_317
-207 val_207
-265 val_265
-353 val_353
-214 val_214
-133 val_133
-375 val_375
-401 val_401
-379 val_379
-492 val_492
-298 val_298
-126 val_126
-474 val_475
-423 val_424
-177 val_178
-272 val_273
-287 val_288
-126 val_127
-441 val_442
-371 val_372
-243 val_244
-133 val_134
-485 val_486
-335 val_336
-485 val_486
-393 val_394
-409 val_410
-265 val_266
-331 val_332
-254 val_255
-492 val_493
-438 val_439
-360 val_361
-467 val_468
-119 val_120
-492 val_493
-306 val_307
-393 val_394
-427 val_428
-386 val_387
-184 val_185
-375 val_376
-191 val_192
-122 val_123
-438 val_439
-328 val_329
-382 val_383
-342 val_343
-331 val_332
-409 val_410
-463 val_464
-177 val_178
-258 val_259
-104 val_105
-140 val_141
-405 val_406
-119 val_120
-416 val_417
-199 val_200
-375 val_376
-386 val_387
-364 val_365
-313 val_314
-324 val_325
-328 val_329
-122 val_123
-104 val_105
-481 val_482
-317 val_318
-412 val_413
-375 val_376
-489 val_490
-126 val_127
-470 val_471
-302 val_303
-119 val_120
-375 val_376
-287 val_288
-375 val_376
-151 val_152
-104 val_105
-335 val_336
-371 val_372
-496 val_497
-144 val_145
-382 val_383
-122 val_123
-427 val_428
-474 val_475
-353 val_354
-261 val_262
-371 val_372
-412 val_413
-478 val_479
-243 val_244
-151 val_152
-401 val_402
-137 val_138
-162 val_163
-276 val_277
-379 val_380
-371 val_372
-430 val_431
-478 val_479
+ABSTRACT SYNTAX TREE:
+ (TOK_QUERY (TOK_FROM (TOK_TABREF srcbucket (TOK_TABLESAMPLE 1 4 key) s)) (TOK_INSERT (TOK_DESTINATION (TOK_TAB dest1)) (TOK_SELECT (TOK_SELEXPR (TOK_ALLCOLREF s))) (TOK_WHERE (> (TOK_COLREF s key) 100))))
+
+STAGE DEPENDENCIES:
+ Stage-1 is a root stage
+ Stage-0 depends on stages: Stage-1
+
+STAGE PLANS:
+ Stage: Stage-1
+ Map Reduce
+ Path -> Alias:
+ file:/data/zshao/trunk/VENDOR/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/srcbucket
+ Path -> Partition:
+ file:/data/zshao/trunk/VENDOR/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/srcbucket
+ Partition
+
+ properties:
+ name srcbucket
+ bucket_field_name
+ serialization.format 1
+ columns key,value
+ field_to_dimension
+ bucket_count 2
+ serialization.lib simple_meta
+ file.inputformat org.apache.hadoop.mapred.TextInputFormat
+ file.outputformat org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ location file:/data/zshao/trunk/VENDOR/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/srcbucket
+ name: srcbucket
+ serde: simple_meta
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ Alias -> Map Operator Tree:
+ s
+ Filter Operator
+ predicate:
+ expr: (((default_sample_hashfn(key) & 2147483647) % 4) = 1)
+ type: Boolean
+ Filter Operator
+ predicate:
+ expr: (key > 100)
+ type: Boolean
+ Select Operator
+ expressions:
+ expr: key
+ type: string
+ expr: value
+ type: string
+ File Output Operator
+ table:
+ properties:
+ name dest1
+ bucket_field_name
+ serialization.format 1
+ columns key,value
+ SORTBUCKETCOLSPREFIX TRUE
+ field_to_dimension
+ bucket_count -1
+ serialization.lib simple_meta
+ file.inputformat org.apache.hadoop.mapred.TextInputFormat
+ file.outputformat org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ location file:/data/zshao/trunk/VENDOR/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/dest1
+ name: dest1
+ serde: simple_meta
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ directory: /tmp/hive-zshao/484898228.10000.insclause-0
+ Needs Tagging:
+
+ Stage: Stage-0
+ Move Operator
+ tables:
+ table:
+ properties:
+ name dest1
+ bucket_field_name
+ serialization.format 1
+ columns key,value
+ SORTBUCKETCOLSPREFIX TRUE
+ field_to_dimension
+ bucket_count -1
+ serialization.lib simple_meta
+ file.inputformat org.apache.hadoop.mapred.TextInputFormat
+ file.outputformat org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ location file:/data/zshao/trunk/VENDOR/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/dest1
+ name: dest1
+ serde: simple_meta
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ replace:
+ source: /tmp/hive-zshao/484898228.10000.insclause-0
+
+
+409 val_409
+265 val_265
+401 val_401
+166 val_166
+430 val_430
+287 val_287
+207 val_207
+199 val_199
+247 val_247
+489 val_489
+162 val_162
+397 val_397
+342 val_342
+195 val_195
+155 val_155
+203 val_203
+339 val_339
+302 val_302
+438 val_438
+489 val_489
+221 val_221
+111 val_111
+427 val_427
+382 val_382
+386 val_386
+430 val_430
+221 val_221
+137 val_137
+180 val_180
+489 val_489
+353 val_353
+272 val_272
+463 val_463
+119 val_119
+496 val_496
+393 val_393
+298 val_298
+199 val_199
+191 val_191
+481 val_481
+409 val_409
+470 val_470
+137 val_137
+364 val_364
+306 val_306
+272 val_272
+331 val_331
+401 val_401
+452 val_452
+177 val_177
+317 val_317
+229 val_229
+195 val_195
+430 val_430
+119 val_119
+489 val_489
+492 val_492
+449 val_449
+218 val_218
+342 val_342
+368 val_368
+485 val_485
+401 val_401
+191 val_191
+438 val_438
+467 val_467
+229 val_229
+463 val_463
+283 val_283
+331 val_331
+335 val_335
+104 val_104
+409 val_409
+401 val_401
+258 val_258
+203 val_203
+478 val_478
+298 val_298
+382 val_382
+397 val_397
+104 val_104
+438 val_438
+119 val_119
+360 val_360
+199 val_199
+478 val_478
+317 val_317
+207 val_207
+265 val_265
+353 val_353
+214 val_214
+133 val_133
+375 val_375
+401 val_401
+379 val_379
+492 val_492
+298 val_298
+126 val_126
+
+474 val_475
+423 val_424
+177 val_178
+272 val_273
+287 val_288
+126 val_127
+441 val_442
+371 val_372
+243 val_244
+133 val_134
+485 val_486
+335 val_336
+485 val_486
+393 val_394
+409 val_410
+265 val_266
+331 val_332
+254 val_255
+492 val_493
+438 val_439
+360 val_361
+467 val_468
+119 val_120
+492 val_493
+306 val_307
+393 val_394
+427 val_428
+386 val_387
+184 val_185
+375 val_376
+191 val_192
+122 val_123
+438 val_439
+328 val_329
+382 val_383
+342 val_343
+331 val_332
+409 val_410
+463 val_464
+177 val_178
+258 val_259
+104 val_105
+140 val_141
+405 val_406
+119 val_120
+416 val_417
+199 val_200
+375 val_376
+386 val_387
+364 val_365
+313 val_314
+324 val_325
+328 val_329
+122 val_123
+104 val_105
+481 val_482
+317 val_318
+412 val_413
+375 val_376
+489 val_490
+126 val_127
+470 val_471
+302 val_303
+119 val_120
+375 val_376
+287 val_288
+375 val_376
+151 val_152
+104 val_105
+335 val_336
+371 val_372
+496 val_497
+144 val_145
+382 val_383
+122 val_123
+427 val_428
+474 val_475
+353 val_354
+261 val_262
+371 val_372
+412 val_413
+478 val_479
+243 val_244
+151 val_152
+401 val_402
+137 val_138
+162 val_163
+276 val_277
+379 val_380
+371 val_372
+430 val_431
+478 val_479
+