You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by na...@apache.org on 2009/12/31 17:04:46 UTC
svn commit: r894876 [6/9] - in /hadoop/hive/trunk: ./
ql/src/java/org/apache/hadoop/hive/ql/parse/
ql/src/java/org/apache/hadoop/hive/ql/plan/
ql/src/test/queries/clientpositive/ ql/src/test/results/clientpositive/
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/partition_vs_table_metadata.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/partition_vs_table_metadata.q.out?rev=894876&r1=894875&r2=894876&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/partition_vs_table_metadata.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/partition_vs_table_metadata.q.out Thu Dec 31 16:04:45 2009
@@ -30,1015 +30,1017 @@
POSTHOOK: Input: default@src
POSTHOOK: Output: default@partition_vs_table@ds=101
PREHOOK: query: select key, value, newcol from partition_vs_table
+order by key
PREHOOK: type: QUERY
PREHOOK: Input: default@partition_vs_table@ds=100
PREHOOK: Input: default@partition_vs_table@ds=101
-PREHOOK: Output: file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/1354905847/10000
+PREHOOK: Output: file:/data/users/jsichi/open/hive-trunk/build/ql/tmp/1273555868/10000
POSTHOOK: query: select key, value, newcol from partition_vs_table
+order by key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@partition_vs_table@ds=100
POSTHOOK: Input: default@partition_vs_table@ds=101
-POSTHOOK: Output: file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/1354905847/10000
-238 val_238 NULL
-86 val_86 NULL
-311 val_311 NULL
-27 val_27 NULL
-165 val_165 NULL
-409 val_409 NULL
-255 val_255 NULL
-278 val_278 NULL
-98 val_98 NULL
-484 val_484 NULL
-265 val_265 NULL
-193 val_193 NULL
-401 val_401 NULL
-150 val_150 NULL
-273 val_273 NULL
-224 val_224 NULL
-369 val_369 NULL
-66 val_66 NULL
+POSTHOOK: Output: file:/data/users/jsichi/open/hive-trunk/build/ql/tmp/1273555868/10000
+0 val_0 NULL
+0 val_0 NULL
+0 val_0 NULL
+0 val_0 0
+0 val_0 0
+0 val_0 0
+10 val_10 10
+10 val_10 NULL
+100 val_100 NULL
+100 val_100 NULL
+100 val_100 100
+100 val_100 100
+103 val_103 103
+103 val_103 103
+103 val_103 NULL
+103 val_103 NULL
+104 val_104 NULL
+104 val_104 NULL
+104 val_104 104
+104 val_104 104
+105 val_105 105
+105 val_105 NULL
+11 val_11 NULL
+11 val_11 11
+111 val_111 111
+111 val_111 NULL
+113 val_113 NULL
+113 val_113 NULL
+113 val_113 113
+113 val_113 113
+114 val_114 114
+114 val_114 NULL
+116 val_116 NULL
+116 val_116 116
+118 val_118 118
+118 val_118 118
+118 val_118 NULL
+118 val_118 NULL
+119 val_119 NULL
+119 val_119 NULL
+119 val_119 NULL
+119 val_119 119
+119 val_119 119
+119 val_119 119
+12 val_12 12
+12 val_12 12
+12 val_12 NULL
+12 val_12 NULL
+120 val_120 NULL
+120 val_120 NULL
+120 val_120 120
+120 val_120 120
+125 val_125 125
+125 val_125 125
+125 val_125 NULL
+125 val_125 NULL
+126 val_126 NULL
+126 val_126 126
+128 val_128 128
+128 val_128 128
+128 val_128 128
128 val_128 NULL
-213 val_213 NULL
-146 val_146 NULL
-406 val_406 NULL
-429 val_429 NULL
-374 val_374 NULL
-152 val_152 NULL
-469 val_469 NULL
+128 val_128 NULL
+128 val_128 NULL
+129 val_129 NULL
+129 val_129 NULL
+129 val_129 129
+129 val_129 129
+131 val_131 131
+131 val_131 NULL
+133 val_133 NULL
+133 val_133 133
+134 val_134 134
+134 val_134 134
+134 val_134 NULL
+134 val_134 NULL
+136 val_136 NULL
+136 val_136 136
+137 val_137 137
+137 val_137 137
+137 val_137 NULL
+137 val_137 NULL
+138 val_138 NULL
+138 val_138 NULL
+138 val_138 NULL
+138 val_138 NULL
+138 val_138 138
+138 val_138 138
+138 val_138 138
+138 val_138 138
+143 val_143 143
+143 val_143 NULL
145 val_145 NULL
-495 val_495 NULL
-37 val_37 NULL
-327 val_327 NULL
-281 val_281 NULL
-277 val_277 NULL
-209 val_209 NULL
+145 val_145 145
+146 val_146 146
+146 val_146 146
+146 val_146 NULL
+146 val_146 NULL
+149 val_149 NULL
+149 val_149 NULL
+149 val_149 149
+149 val_149 149
+15 val_15 15
+15 val_15 15
15 val_15 NULL
-82 val_82 NULL
-403 val_403 NULL
-166 val_166 NULL
-417 val_417 NULL
-430 val_430 NULL
-252 val_252 NULL
-292 val_292 NULL
-219 val_219 NULL
-287 val_287 NULL
+15 val_15 NULL
+150 val_150 NULL
+150 val_150 150
+152 val_152 152
+152 val_152 152
+152 val_152 NULL
+152 val_152 NULL
153 val_153 NULL
-193 val_193 NULL
-338 val_338 NULL
-446 val_446 NULL
-459 val_459 NULL
-394 val_394 NULL
-237 val_237 NULL
-482 val_482 NULL
-174 val_174 NULL
-413 val_413 NULL
-494 val_494 NULL
-207 val_207 NULL
-199 val_199 NULL
-466 val_466 NULL
-208 val_208 NULL
-174 val_174 NULL
-399 val_399 NULL
-396 val_396 NULL
-247 val_247 NULL
-417 val_417 NULL
-489 val_489 NULL
+153 val_153 153
+155 val_155 155
+155 val_155 NULL
+156 val_156 NULL
+156 val_156 156
+157 val_157 157
+157 val_157 NULL
+158 val_158 NULL
+158 val_158 158
+160 val_160 160
+160 val_160 NULL
162 val_162 NULL
-377 val_377 NULL
-397 val_397 NULL
-309 val_309 NULL
-365 val_365 NULL
-266 val_266 NULL
-439 val_439 NULL
-342 val_342 NULL
-367 val_367 NULL
-325 val_325 NULL
+162 val_162 162
+163 val_163 163
+163 val_163 NULL
+164 val_164 NULL
+164 val_164 NULL
+164 val_164 164
+164 val_164 164
+165 val_165 165
+165 val_165 165
+165 val_165 NULL
+165 val_165 NULL
+166 val_166 NULL
+166 val_166 166
+167 val_167 167
+167 val_167 167
+167 val_167 167
167 val_167 NULL
-195 val_195 NULL
-475 val_475 NULL
+167 val_167 NULL
+167 val_167 NULL
+168 val_168 NULL
+168 val_168 168
+169 val_169 169
+169 val_169 169
+169 val_169 169
+169 val_169 169
+169 val_169 NULL
+169 val_169 NULL
+169 val_169 NULL
+169 val_169 NULL
17 val_17 NULL
-113 val_113 NULL
-155 val_155 NULL
-203 val_203 NULL
-339 val_339 NULL
-0 val_0 NULL
-455 val_455 NULL
-128 val_128 NULL
-311 val_311 NULL
-316 val_316 NULL
-57 val_57 NULL
-302 val_302 NULL
-205 val_205 NULL
-149 val_149 NULL
-438 val_438 NULL
-345 val_345 NULL
-129 val_129 NULL
+17 val_17 17
+170 val_170 170
170 val_170 NULL
-20 val_20 NULL
-489 val_489 NULL
-157 val_157 NULL
-378 val_378 NULL
-221 val_221 NULL
-92 val_92 NULL
-111 val_111 NULL
-47 val_47 NULL
-72 val_72 NULL
-4 val_4 NULL
-280 val_280 NULL
-35 val_35 NULL
-427 val_427 NULL
-277 val_277 NULL
-208 val_208 NULL
-356 val_356 NULL
-399 val_399 NULL
-169 val_169 NULL
-382 val_382 NULL
-498 val_498 NULL
-125 val_125 NULL
-386 val_386 NULL
-437 val_437 NULL
-469 val_469 NULL
-192 val_192 NULL
-286 val_286 NULL
-187 val_187 NULL
+172 val_172 NULL
+172 val_172 NULL
+172 val_172 172
+172 val_172 172
+174 val_174 174
+174 val_174 174
+174 val_174 NULL
+174 val_174 NULL
+175 val_175 NULL
+175 val_175 NULL
+175 val_175 175
+175 val_175 175
+176 val_176 176
+176 val_176 176
176 val_176 NULL
-54 val_54 NULL
-459 val_459 NULL
-51 val_51 NULL
-138 val_138 NULL
-103 val_103 NULL
-239 val_239 NULL
-213 val_213 NULL
-216 val_216 NULL
-430 val_430 NULL
-278 val_278 NULL
176 val_176 NULL
-289 val_289 NULL
-221 val_221 NULL
-65 val_65 NULL
-318 val_318 NULL
-332 val_332 NULL
-311 val_311 NULL
-275 val_275 NULL
-137 val_137 NULL
-241 val_241 NULL
-83 val_83 NULL
-333 val_333 NULL
+177 val_177 NULL
+177 val_177 177
+178 val_178 178
+178 val_178 NULL
+179 val_179 NULL
+179 val_179 NULL
+179 val_179 179
+179 val_179 179
+18 val_18 18
+18 val_18 18
+18 val_18 NULL
+18 val_18 NULL
180 val_180 NULL
-284 val_284 NULL
-12 val_12 NULL
-230 val_230 NULL
+180 val_180 180
+181 val_181 181
181 val_181 NULL
-67 val_67 NULL
-260 val_260 NULL
-404 val_404 NULL
-384 val_384 NULL
-489 val_489 NULL
-353 val_353 NULL
-373 val_373 NULL
-272 val_272 NULL
-138 val_138 NULL
-217 val_217 NULL
-84 val_84 NULL
-348 val_348 NULL
-466 val_466 NULL
-58 val_58 NULL
-8 val_8 NULL
-411 val_411 NULL
-230 val_230 NULL
-208 val_208 NULL
-348 val_348 NULL
-24 val_24 NULL
-463 val_463 NULL
-431 val_431 NULL
-179 val_179 NULL
-172 val_172 NULL
-42 val_42 NULL
-129 val_129 NULL
-158 val_158 NULL
-119 val_119 NULL
-496 val_496 NULL
-0 val_0 NULL
-322 val_322 NULL
-197 val_197 NULL
-468 val_468 NULL
-393 val_393 NULL
-454 val_454 NULL
-100 val_100 NULL
-298 val_298 NULL
-199 val_199 NULL
-191 val_191 NULL
-418 val_418 NULL
-96 val_96 NULL
-26 val_26 NULL
-165 val_165 NULL
-327 val_327 NULL
-230 val_230 NULL
-205 val_205 NULL
-120 val_120 NULL
-131 val_131 NULL
-51 val_51 NULL
-404 val_404 NULL
-43 val_43 NULL
-436 val_436 NULL
-156 val_156 NULL
-469 val_469 NULL
-468 val_468 NULL
-308 val_308 NULL
-95 val_95 NULL
-196 val_196 NULL
-288 val_288 NULL
-481 val_481 NULL
-457 val_457 NULL
-98 val_98 NULL
-282 val_282 NULL
-197 val_197 NULL
+183 val_183 NULL
+183 val_183 183
+186 val_186 186
+186 val_186 NULL
187 val_187 NULL
-318 val_318 NULL
-318 val_318 NULL
-409 val_409 NULL
-470 val_470 NULL
-137 val_137 NULL
-369 val_369 NULL
-316 val_316 NULL
-169 val_169 NULL
-413 val_413 NULL
-85 val_85 NULL
-77 val_77 NULL
-0 val_0 NULL
-490 val_490 NULL
-87 val_87 NULL
-364 val_364 NULL
-179 val_179 NULL
-118 val_118 NULL
-134 val_134 NULL
-395 val_395 NULL
-282 val_282 NULL
-138 val_138 NULL
-238 val_238 NULL
-419 val_419 NULL
-15 val_15 NULL
-118 val_118 NULL
-72 val_72 NULL
-90 val_90 NULL
-307 val_307 NULL
+187 val_187 NULL
+187 val_187 NULL
+187 val_187 187
+187 val_187 187
+187 val_187 187
+189 val_189 189
+189 val_189 NULL
19 val_19 NULL
-435 val_435 NULL
-10 val_10 NULL
-277 val_277 NULL
-273 val_273 NULL
-306 val_306 NULL
-224 val_224 NULL
-309 val_309 NULL
-389 val_389 NULL
-327 val_327 NULL
-242 val_242 NULL
-369 val_369 NULL
-392 val_392 NULL
-272 val_272 NULL
-331 val_331 NULL
-401 val_401 NULL
-242 val_242 NULL
-452 val_452 NULL
-177 val_177 NULL
-226 val_226 NULL
-5 val_5 NULL
-497 val_497 NULL
-402 val_402 NULL
-396 val_396 NULL
-317 val_317 NULL
-395 val_395 NULL
-58 val_58 NULL
-35 val_35 NULL
-336 val_336 NULL
-95 val_95 NULL
-11 val_11 NULL
-168 val_168 NULL
-34 val_34 NULL
-229 val_229 NULL
-233 val_233 NULL
-143 val_143 NULL
-472 val_472 NULL
-322 val_322 NULL
-498 val_498 NULL
-160 val_160 NULL
-195 val_195 NULL
-42 val_42 NULL
-321 val_321 NULL
-430 val_430 NULL
-119 val_119 NULL
-489 val_489 NULL
-458 val_458 NULL
-78 val_78 NULL
-76 val_76 NULL
-41 val_41 NULL
-223 val_223 NULL
-492 val_492 NULL
-149 val_149 NULL
-449 val_449 NULL
-218 val_218 NULL
-228 val_228 NULL
-138 val_138 NULL
-453 val_453 NULL
-30 val_30 NULL
-209 val_209 NULL
-64 val_64 NULL
-468 val_468 NULL
-76 val_76 NULL
-74 val_74 NULL
-342 val_342 NULL
-69 val_69 NULL
-230 val_230 NULL
-33 val_33 NULL
-368 val_368 NULL
-103 val_103 NULL
-296 val_296 NULL
-113 val_113 NULL
-216 val_216 NULL
-367 val_367 NULL
-344 val_344 NULL
-167 val_167 NULL
-274 val_274 NULL
-219 val_219 NULL
-239 val_239 NULL
-485 val_485 NULL
-116 val_116 NULL
-223 val_223 NULL
-256 val_256 NULL
-263 val_263 NULL
-70 val_70 NULL
-487 val_487 NULL
-480 val_480 NULL
-401 val_401 NULL
-288 val_288 NULL
+19 val_19 19
+190 val_190 190
+190 val_190 NULL
191 val_191 NULL
-5 val_5 NULL
-244 val_244 NULL
-438 val_438 NULL
-128 val_128 NULL
-467 val_467 NULL
-432 val_432 NULL
-202 val_202 NULL
-316 val_316 NULL
-229 val_229 NULL
-469 val_469 NULL
-463 val_463 NULL
-280 val_280 NULL
-2 val_2 NULL
-35 val_35 NULL
-283 val_283 NULL
-331 val_331 NULL
-235 val_235 NULL
-80 val_80 NULL
-44 val_44 NULL
+191 val_191 NULL
+191 val_191 191
+191 val_191 191
+192 val_192 192
+192 val_192 NULL
193 val_193 NULL
-321 val_321 NULL
-335 val_335 NULL
-104 val_104 NULL
-466 val_466 NULL
-366 val_366 NULL
-175 val_175 NULL
-403 val_403 NULL
-483 val_483 NULL
-53 val_53 NULL
-105 val_105 NULL
-257 val_257 NULL
-406 val_406 NULL
-409 val_409 NULL
-190 val_190 NULL
-406 val_406 NULL
-401 val_401 NULL
-114 val_114 NULL
-258 val_258 NULL
-90 val_90 NULL
-203 val_203 NULL
-262 val_262 NULL
-348 val_348 NULL
-424 val_424 NULL
-12 val_12 NULL
-396 val_396 NULL
+193 val_193 NULL
+193 val_193 NULL
+193 val_193 193
+193 val_193 193
+193 val_193 193
+194 val_194 194
+194 val_194 NULL
+195 val_195 NULL
+195 val_195 NULL
+195 val_195 195
+195 val_195 195
+196 val_196 196
+196 val_196 NULL
+197 val_197 NULL
+197 val_197 NULL
+197 val_197 197
+197 val_197 197
+199 val_199 199
+199 val_199 199
+199 val_199 199
+199 val_199 NULL
+199 val_199 NULL
+199 val_199 NULL
+2 val_2 NULL
+2 val_2 2
+20 val_20 20
+20 val_20 NULL
+200 val_200 NULL
+200 val_200 NULL
+200 val_200 200
+200 val_200 200
+201 val_201 201
201 val_201 NULL
+202 val_202 NULL
+202 val_202 202
+203 val_203 203
+203 val_203 203
+203 val_203 NULL
+203 val_203 NULL
+205 val_205 NULL
+205 val_205 NULL
+205 val_205 205
+205 val_205 205
+207 val_207 207
+207 val_207 207
+207 val_207 NULL
+207 val_207 NULL
+208 val_208 NULL
+208 val_208 NULL
+208 val_208 NULL
+208 val_208 208
+208 val_208 208
+208 val_208 208
+209 val_209 209
+209 val_209 209
+209 val_209 NULL
+209 val_209 NULL
+213 val_213 NULL
+213 val_213 NULL
+213 val_213 213
+213 val_213 213
+214 val_214 214
+214 val_214 NULL
+216 val_216 NULL
+216 val_216 NULL
+216 val_216 216
+216 val_216 216
+217 val_217 217
+217 val_217 217
217 val_217 NULL
-164 val_164 NULL
-431 val_431 NULL
-454 val_454 NULL
-478 val_478 NULL
-298 val_298 NULL
-125 val_125 NULL
-431 val_431 NULL
-164 val_164 NULL
-424 val_424 NULL
-187 val_187 NULL
-382 val_382 NULL
-5 val_5 NULL
-70 val_70 NULL
-397 val_397 NULL
-480 val_480 NULL
-291 val_291 NULL
-24 val_24 NULL
-351 val_351 NULL
-255 val_255 NULL
-104 val_104 NULL
-70 val_70 NULL
-163 val_163 NULL
-438 val_438 NULL
-119 val_119 NULL
-414 val_414 NULL
-200 val_200 NULL
-491 val_491 NULL
+217 val_217 NULL
+218 val_218 NULL
+218 val_218 218
+219 val_219 219
+219 val_219 219
+219 val_219 NULL
+219 val_219 NULL
+221 val_221 NULL
+221 val_221 NULL
+221 val_221 221
+221 val_221 221
+222 val_222 222
+222 val_222 NULL
+223 val_223 NULL
+223 val_223 NULL
+223 val_223 223
+223 val_223 223
+224 val_224 224
+224 val_224 224
+224 val_224 NULL
+224 val_224 NULL
+226 val_226 NULL
+226 val_226 226
+228 val_228 228
+228 val_228 NULL
+229 val_229 NULL
+229 val_229 NULL
+229 val_229 229
+229 val_229 229
+230 val_230 230
+230 val_230 230
+230 val_230 230
+230 val_230 230
+230 val_230 230
+230 val_230 NULL
+230 val_230 NULL
+230 val_230 NULL
+230 val_230 NULL
+230 val_230 NULL
+233 val_233 NULL
+233 val_233 NULL
+233 val_233 233
+233 val_233 233
+235 val_235 235
+235 val_235 NULL
237 val_237 NULL
-439 val_439 NULL
-360 val_360 NULL
+237 val_237 NULL
+237 val_237 237
+237 val_237 237
+238 val_238 238
+238 val_238 238
+238 val_238 NULL
+238 val_238 NULL
+239 val_239 NULL
+239 val_239 NULL
+239 val_239 239
+239 val_239 239
+24 val_24 24
+24 val_24 24
+24 val_24 NULL
+24 val_24 NULL
+241 val_241 NULL
+241 val_241 241
+242 val_242 242
+242 val_242 242
+242 val_242 NULL
+242 val_242 NULL
+244 val_244 NULL
+244 val_244 244
+247 val_247 247
+247 val_247 NULL
248 val_248 NULL
-479 val_479 NULL
-305 val_305 NULL
-417 val_417 NULL
-199 val_199 NULL
-444 val_444 NULL
-120 val_120 NULL
-429 val_429 NULL
-169 val_169 NULL
-443 val_443 NULL
-323 val_323 NULL
-325 val_325 NULL
-277 val_277 NULL
-230 val_230 NULL
-478 val_478 NULL
-178 val_178 NULL
-468 val_468 NULL
-310 val_310 NULL
-317 val_317 NULL
-333 val_333 NULL
-493 val_493 NULL
-460 val_460 NULL
-207 val_207 NULL
+248 val_248 248
+249 val_249 249
249 val_249 NULL
-265 val_265 NULL
-480 val_480 NULL
-83 val_83 NULL
-136 val_136 NULL
-353 val_353 NULL
-172 val_172 NULL
-214 val_214 NULL
-462 val_462 NULL
-233 val_233 NULL
-406 val_406 NULL
-133 val_133 NULL
-175 val_175 NULL
-189 val_189 NULL
-454 val_454 NULL
-375 val_375 NULL
-401 val_401 NULL
-421 val_421 NULL
-407 val_407 NULL
-384 val_384 NULL
+252 val_252 NULL
+252 val_252 252
+255 val_255 255
+255 val_255 255
+255 val_255 NULL
+255 val_255 NULL
+256 val_256 NULL
256 val_256 NULL
+256 val_256 256
+256 val_256 256
+257 val_257 257
+257 val_257 NULL
+258 val_258 NULL
+258 val_258 258
+26 val_26 26
+26 val_26 26
26 val_26 NULL
-134 val_134 NULL
-67 val_67 NULL
-384 val_384 NULL
-379 val_379 NULL
-18 val_18 NULL
-462 val_462 NULL
-492 val_492 NULL
-100 val_100 NULL
-298 val_298 NULL
-9 val_9 NULL
-341 val_341 NULL
-498 val_498 NULL
-146 val_146 NULL
-458 val_458 NULL
-362 val_362 NULL
-186 val_186 NULL
-285 val_285 NULL
-348 val_348 NULL
-167 val_167 NULL
-18 val_18 NULL
-273 val_273 NULL
-183 val_183 NULL
-281 val_281 NULL
-344 val_344 NULL
-97 val_97 NULL
-469 val_469 NULL
-315 val_315 NULL
-84 val_84 NULL
-28 val_28 NULL
-37 val_37 NULL
-448 val_448 NULL
-152 val_152 NULL
-348 val_348 NULL
-307 val_307 NULL
-194 val_194 NULL
-414 val_414 NULL
-477 val_477 NULL
-222 val_222 NULL
-126 val_126 NULL
-90 val_90 NULL
-169 val_169 NULL
-403 val_403 NULL
-400 val_400 NULL
-200 val_200 NULL
-97 val_97 NULL
-238 val_238 238
-86 val_86 86
-311 val_311 311
-27 val_27 27
-165 val_165 165
-409 val_409 409
-255 val_255 255
-278 val_278 278
-98 val_98 98
-484 val_484 484
+26 val_26 NULL
+260 val_260 NULL
+260 val_260 260
+262 val_262 262
+262 val_262 NULL
+263 val_263 NULL
+263 val_263 263
265 val_265 265
-193 val_193 193
-401 val_401 401
-150 val_150 150
+265 val_265 265
+265 val_265 NULL
+265 val_265 NULL
+266 val_266 NULL
+266 val_266 266
+27 val_27 27
+27 val_27 NULL
+272 val_272 NULL
+272 val_272 NULL
+272 val_272 272
+272 val_272 272
273 val_273 273
-224 val_224 224
-369 val_369 369
-66 val_66 66
-128 val_128 128
-213 val_213 213
-146 val_146 146
-406 val_406 406
-429 val_429 429
-374 val_374 374
-152 val_152 152
-469 val_469 469
-145 val_145 145
-495 val_495 495
-37 val_37 37
-327 val_327 327
-281 val_281 281
+273 val_273 273
+273 val_273 273
+273 val_273 NULL
+273 val_273 NULL
+273 val_273 NULL
+274 val_274 NULL
+274 val_274 274
+275 val_275 275
+275 val_275 NULL
+277 val_277 NULL
+277 val_277 NULL
+277 val_277 NULL
+277 val_277 NULL
277 val_277 277
-209 val_209 209
-15 val_15 15
-82 val_82 82
-403 val_403 403
-166 val_166 166
-417 val_417 417
-430 val_430 430
-252 val_252 252
-292 val_292 292
-219 val_219 219
+277 val_277 277
+277 val_277 277
+277 val_277 277
+278 val_278 278
+278 val_278 278
+278 val_278 NULL
+278 val_278 NULL
+28 val_28 NULL
+28 val_28 28
+280 val_280 280
+280 val_280 280
+280 val_280 NULL
+280 val_280 NULL
+281 val_281 NULL
+281 val_281 NULL
+281 val_281 281
+281 val_281 281
+282 val_282 282
+282 val_282 282
+282 val_282 NULL
+282 val_282 NULL
+283 val_283 NULL
+283 val_283 283
+284 val_284 284
+284 val_284 NULL
+285 val_285 NULL
+285 val_285 285
+286 val_286 286
+286 val_286 NULL
+287 val_287 NULL
287 val_287 287
-153 val_153 153
-193 val_193 193
-338 val_338 338
-446 val_446 446
-459 val_459 459
-394 val_394 394
-237 val_237 237
-482 val_482 482
-174 val_174 174
-413 val_413 413
-494 val_494 494
-207 val_207 207
-199 val_199 199
-466 val_466 466
-208 val_208 208
-174 val_174 174
-399 val_399 399
-396 val_396 396
-247 val_247 247
-417 val_417 417
-489 val_489 489
-162 val_162 162
-377 val_377 377
-397 val_397 397
+288 val_288 288
+288 val_288 288
+288 val_288 NULL
+288 val_288 NULL
+289 val_289 NULL
+289 val_289 289
+291 val_291 291
+291 val_291 NULL
+292 val_292 NULL
+292 val_292 292
+296 val_296 296
+296 val_296 NULL
+298 val_298 NULL
+298 val_298 NULL
+298 val_298 NULL
+298 val_298 298
+298 val_298 298
+298 val_298 298
+30 val_30 30
+30 val_30 NULL
+302 val_302 NULL
+302 val_302 302
+305 val_305 305
+305 val_305 NULL
+306 val_306 NULL
+306 val_306 306
+307 val_307 307
+307 val_307 307
+307 val_307 NULL
+307 val_307 NULL
+308 val_308 NULL
+308 val_308 308
309 val_309 309
-365 val_365 365
-266 val_266 266
-439 val_439 439
-342 val_342 342
-367 val_367 367
-325 val_325 325
-167 val_167 167
-195 val_195 195
-475 val_475 475
-17 val_17 17
-113 val_113 113
-155 val_155 155
-203 val_203 203
-339 val_339 339
-0 val_0 0
-455 val_455 455
-128 val_128 128
+309 val_309 309
+309 val_309 NULL
+309 val_309 NULL
+310 val_310 NULL
+310 val_310 310
+311 val_311 311
311 val_311 311
+311 val_311 311
+311 val_311 NULL
+311 val_311 NULL
+311 val_311 NULL
+315 val_315 NULL
+315 val_315 315
316 val_316 316
-57 val_57 57
-302 val_302 302
-205 val_205 205
-149 val_149 149
-438 val_438 438
-345 val_345 345
-129 val_129 129
-170 val_170 170
-20 val_20 20
-489 val_489 489
-157 val_157 157
-378 val_378 378
-221 val_221 221
-92 val_92 92
-111 val_111 111
-47 val_47 47
-72 val_72 72
-4 val_4 4
-280 val_280 280
-35 val_35 35
-427 val_427 427
-277 val_277 277
-208 val_208 208
-356 val_356 356
-399 val_399 399
-169 val_169 169
-382 val_382 382
-498 val_498 498
-125 val_125 125
-386 val_386 386
-437 val_437 437
-469 val_469 469
-192 val_192 192
-286 val_286 286
-187 val_187 187
-176 val_176 176
-54 val_54 54
-459 val_459 459
-51 val_51 51
-138 val_138 138
-103 val_103 103
-239 val_239 239
-213 val_213 213
-216 val_216 216
-430 val_430 430
-278 val_278 278
-176 val_176 176
-289 val_289 289
-221 val_221 221
-65 val_65 65
+316 val_316 316
+316 val_316 316
+316 val_316 NULL
+316 val_316 NULL
+316 val_316 NULL
+317 val_317 NULL
+317 val_317 NULL
+317 val_317 317
+317 val_317 317
+318 val_318 318
+318 val_318 318
318 val_318 318
+318 val_318 NULL
+318 val_318 NULL
+318 val_318 NULL
+321 val_321 NULL
+321 val_321 NULL
+321 val_321 321
+321 val_321 321
+322 val_322 322
+322 val_322 322
+322 val_322 NULL
+322 val_322 NULL
+323 val_323 NULL
+323 val_323 323
+325 val_325 325
+325 val_325 325
+325 val_325 NULL
+325 val_325 NULL
+327 val_327 NULL
+327 val_327 NULL
+327 val_327 NULL
+327 val_327 327
+327 val_327 327
+327 val_327 327
+33 val_33 33
+33 val_33 NULL
+331 val_331 NULL
+331 val_331 NULL
+331 val_331 331
+331 val_331 331
332 val_332 332
-311 val_311 311
-275 val_275 275
-137 val_137 137
-241 val_241 241
-83 val_83 83
+332 val_332 NULL
+333 val_333 NULL
+333 val_333 NULL
333 val_333 333
-180 val_180 180
-284 val_284 284
-12 val_12 12
-230 val_230 230
-181 val_181 181
-67 val_67 67
-260 val_260 260
-404 val_404 404
-384 val_384 384
-489 val_489 489
+333 val_333 333
+335 val_335 335
+335 val_335 NULL
+336 val_336 NULL
+336 val_336 336
+338 val_338 338
+338 val_338 NULL
+339 val_339 NULL
+339 val_339 339
+34 val_34 34
+34 val_34 NULL
+341 val_341 NULL
+341 val_341 341
+342 val_342 342
+342 val_342 342
+342 val_342 NULL
+342 val_342 NULL
+344 val_344 NULL
+344 val_344 NULL
+344 val_344 344
+344 val_344 344
+345 val_345 345
+345 val_345 NULL
+348 val_348 NULL
+348 val_348 NULL
+348 val_348 NULL
+348 val_348 NULL
+348 val_348 NULL
+348 val_348 348
+348 val_348 348
+348 val_348 348
+348 val_348 348
+348 val_348 348
+35 val_35 35
+35 val_35 35
+35 val_35 35
+35 val_35 NULL
+35 val_35 NULL
+35 val_35 NULL
+351 val_351 NULL
+351 val_351 351
+353 val_353 353
353 val_353 353
+353 val_353 NULL
+353 val_353 NULL
+356 val_356 NULL
+356 val_356 356
+360 val_360 360
+360 val_360 NULL
+362 val_362 NULL
+362 val_362 362
+364 val_364 364
+364 val_364 NULL
+365 val_365 NULL
+365 val_365 365
+366 val_366 366
+366 val_366 NULL
+367 val_367 NULL
+367 val_367 NULL
+367 val_367 367
+367 val_367 367
+368 val_368 368
+368 val_368 NULL
+369 val_369 NULL
+369 val_369 NULL
+369 val_369 NULL
+369 val_369 369
+369 val_369 369
+369 val_369 369
+37 val_37 37
+37 val_37 37
+37 val_37 NULL
+37 val_37 NULL
+373 val_373 NULL
373 val_373 373
-272 val_272 272
-138 val_138 138
-217 val_217 217
-84 val_84 84
-348 val_348 348
-466 val_466 466
-58 val_58 58
-8 val_8 8
+374 val_374 374
+374 val_374 NULL
+375 val_375 NULL
+375 val_375 375
+377 val_377 377
+377 val_377 NULL
+378 val_378 NULL
+378 val_378 378
+379 val_379 379
+379 val_379 NULL
+382 val_382 NULL
+382 val_382 NULL
+382 val_382 382
+382 val_382 382
+384 val_384 384
+384 val_384 384
+384 val_384 384
+384 val_384 NULL
+384 val_384 NULL
+384 val_384 NULL
+386 val_386 NULL
+386 val_386 386
+389 val_389 389
+389 val_389 NULL
+392 val_392 NULL
+392 val_392 392
+393 val_393 393
+393 val_393 NULL
+394 val_394 NULL
+394 val_394 394
+395 val_395 395
+395 val_395 395
+395 val_395 NULL
+395 val_395 NULL
+396 val_396 NULL
+396 val_396 NULL
+396 val_396 NULL
+396 val_396 396
+396 val_396 396
+396 val_396 396
+397 val_397 397
+397 val_397 397
+397 val_397 NULL
+397 val_397 NULL
+399 val_399 NULL
+399 val_399 NULL
+399 val_399 399
+399 val_399 399
+4 val_4 4
+4 val_4 NULL
+400 val_400 NULL
+400 val_400 400
+401 val_401 401
+401 val_401 401
+401 val_401 401
+401 val_401 401
+401 val_401 401
+401 val_401 NULL
+401 val_401 NULL
+401 val_401 NULL
+401 val_401 NULL
+401 val_401 NULL
+402 val_402 NULL
+402 val_402 402
+403 val_403 403
+403 val_403 403
+403 val_403 403
+403 val_403 NULL
+403 val_403 NULL
+403 val_403 NULL
+404 val_404 NULL
+404 val_404 NULL
+404 val_404 404
+404 val_404 404
+406 val_406 406
+406 val_406 406
+406 val_406 406
+406 val_406 406
+406 val_406 NULL
+406 val_406 NULL
+406 val_406 NULL
+406 val_406 NULL
+407 val_407 NULL
+407 val_407 407
+409 val_409 409
+409 val_409 409
+409 val_409 409
+409 val_409 NULL
+409 val_409 NULL
+409 val_409 NULL
+41 val_41 NULL
+41 val_41 41
411 val_411 411
-230 val_230 230
-208 val_208 208
-348 val_348 348
-24 val_24 24
+411 val_411 NULL
+413 val_413 NULL
+413 val_413 NULL
+413 val_413 413
+413 val_413 413
+414 val_414 414
+414 val_414 414
+414 val_414 NULL
+414 val_414 NULL
+417 val_417 NULL
+417 val_417 NULL
+417 val_417 NULL
+417 val_417 417
+417 val_417 417
+417 val_417 417
+418 val_418 418
+418 val_418 NULL
+419 val_419 NULL
+419 val_419 419
+42 val_42 42
+42 val_42 42
+42 val_42 NULL
+42 val_42 NULL
+421 val_421 NULL
+421 val_421 421
+424 val_424 424
+424 val_424 424
+424 val_424 NULL
+424 val_424 NULL
+427 val_427 NULL
+427 val_427 427
+429 val_429 429
+429 val_429 429
+429 val_429 NULL
+429 val_429 NULL
+43 val_43 NULL
+43 val_43 43
+430 val_430 430
+430 val_430 430
+430 val_430 430
+430 val_430 NULL
+430 val_430 NULL
+430 val_430 NULL
+431 val_431 NULL
+431 val_431 NULL
+431 val_431 NULL
+431 val_431 431
+431 val_431 431
+431 val_431 431
+432 val_432 432
+432 val_432 NULL
+435 val_435 NULL
+435 val_435 435
+436 val_436 436
+436 val_436 NULL
+437 val_437 NULL
+437 val_437 437
+438 val_438 438
+438 val_438 438
+438 val_438 438
+438 val_438 NULL
+438 val_438 NULL
+438 val_438 NULL
+439 val_439 NULL
+439 val_439 NULL
+439 val_439 439
+439 val_439 439
+44 val_44 44
+44 val_44 NULL
+443 val_443 NULL
+443 val_443 443
+444 val_444 444
+444 val_444 NULL
+446 val_446 NULL
+446 val_446 446
+448 val_448 448
+448 val_448 NULL
+449 val_449 NULL
+449 val_449 449
+452 val_452 452
+452 val_452 NULL
+453 val_453 NULL
+453 val_453 453
+454 val_454 454
+454 val_454 454
+454 val_454 454
+454 val_454 NULL
+454 val_454 NULL
+454 val_454 NULL
+455 val_455 NULL
+455 val_455 455
+457 val_457 457
+457 val_457 NULL
+458 val_458 NULL
+458 val_458 NULL
+458 val_458 458
+458 val_458 458
+459 val_459 459
+459 val_459 459
+459 val_459 NULL
+459 val_459 NULL
+460 val_460 NULL
+460 val_460 460
+462 val_462 462
+462 val_462 462
+462 val_462 NULL
+462 val_462 NULL
+463 val_463 NULL
+463 val_463 NULL
463 val_463 463
-431 val_431 431
-179 val_179 179
-172 val_172 172
-42 val_42 42
-129 val_129 129
-158 val_158 158
-119 val_119 119
-496 val_496 496
-0 val_0 0
-322 val_322 322
-197 val_197 197
+463 val_463 463
+466 val_466 466
+466 val_466 466
+466 val_466 466
+466 val_466 NULL
+466 val_466 NULL
+466 val_466 NULL
+467 val_467 NULL
+467 val_467 467
468 val_468 468
-393 val_393 393
-454 val_454 454
-100 val_100 100
-298 val_298 298
-199 val_199 199
-191 val_191 191
-418 val_418 418
-96 val_96 96
-26 val_26 26
-165 val_165 165
-327 val_327 327
-230 val_230 230
-205 val_205 205
-120 val_120 120
-131 val_131 131
-51 val_51 51
-404 val_404 404
-43 val_43 43
-436 val_436 436
-156 val_156 156
-469 val_469 469
468 val_468 468
-308 val_308 308
-95 val_95 95
-196 val_196 196
-288 val_288 288
-481 val_481 481
-457 val_457 457
-98 val_98 98
-282 val_282 282
-197 val_197 197
-187 val_187 187
-318 val_318 318
-318 val_318 318
-409 val_409 409
+468 val_468 468
+468 val_468 468
+468 val_468 NULL
+468 val_468 NULL
+468 val_468 NULL
+468 val_468 NULL
+469 val_469 NULL
+469 val_469 NULL
+469 val_469 NULL
+469 val_469 NULL
+469 val_469 NULL
+469 val_469 469
+469 val_469 469
+469 val_469 469
+469 val_469 469
+469 val_469 469
+47 val_47 47
+47 val_47 NULL
+470 val_470 NULL
470 val_470 470
-137 val_137 137
-369 val_369 369
-316 val_316 316
-169 val_169 169
-413 val_413 413
-85 val_85 85
-77 val_77 77
-0 val_0 0
-490 val_490 490
-87 val_87 87
-364 val_364 364
-179 val_179 179
-118 val_118 118
-134 val_134 134
-395 val_395 395
-282 val_282 282
-138 val_138 138
-238 val_238 238
-419 val_419 419
-15 val_15 15
-118 val_118 118
-72 val_72 72
-90 val_90 90
-307 val_307 307
-19 val_19 19
-435 val_435 435
-10 val_10 10
-277 val_277 277
-273 val_273 273
-306 val_306 306
-224 val_224 224
-309 val_309 309
-389 val_389 389
-327 val_327 327
-242 val_242 242
-369 val_369 369
-392 val_392 392
-272 val_272 272
-331 val_331 331
-401 val_401 401
-242 val_242 242
-452 val_452 452
-177 val_177 177
-226 val_226 226
-5 val_5 5
-497 val_497 497
-402 val_402 402
-396 val_396 396
-317 val_317 317
-395 val_395 395
-58 val_58 58
-35 val_35 35
-336 val_336 336
-95 val_95 95
-11 val_11 11
-168 val_168 168
-34 val_34 34
-229 val_229 229
-233 val_233 233
-143 val_143 143
472 val_472 472
-322 val_322 322
-498 val_498 498
-160 val_160 160
-195 val_195 195
-42 val_42 42
-321 val_321 321
-430 val_430 430
-119 val_119 119
+472 val_472 NULL
+475 val_475 NULL
+475 val_475 475
+477 val_477 477
+477 val_477 NULL
+478 val_478 NULL
+478 val_478 NULL
+478 val_478 478
+478 val_478 478
+479 val_479 479
+479 val_479 NULL
+480 val_480 NULL
+480 val_480 NULL
+480 val_480 NULL
+480 val_480 480
+480 val_480 480
+480 val_480 480
+481 val_481 481
+481 val_481 NULL
+482 val_482 NULL
+482 val_482 482
+483 val_483 483
+483 val_483 NULL
+484 val_484 NULL
+484 val_484 484
+485 val_485 485
+485 val_485 NULL
+487 val_487 NULL
+487 val_487 487
489 val_489 489
-458 val_458 458
-78 val_78 78
-76 val_76 76
-41 val_41 41
-223 val_223 223
+489 val_489 489
+489 val_489 489
+489 val_489 489
+489 val_489 NULL
+489 val_489 NULL
+489 val_489 NULL
+489 val_489 NULL
+490 val_490 NULL
+490 val_490 490
+491 val_491 491
+491 val_491 NULL
+492 val_492 NULL
+492 val_492 NULL
492 val_492 492
-149 val_149 149
-449 val_449 449
-218 val_218 218
-228 val_228 228
-138 val_138 138
-453 val_453 453
-30 val_30 30
-209 val_209 209
+492 val_492 492
+493 val_493 493
+493 val_493 NULL
+494 val_494 NULL
+494 val_494 494
+495 val_495 495
+495 val_495 NULL
+496 val_496 NULL
+496 val_496 496
+497 val_497 497
+497 val_497 NULL
+498 val_498 NULL
+498 val_498 NULL
+498 val_498 NULL
+498 val_498 498
+498 val_498 498
+498 val_498 498
+5 val_5 5
+5 val_5 5
+5 val_5 5
+5 val_5 NULL
+5 val_5 NULL
+5 val_5 NULL
+51 val_51 NULL
+51 val_51 NULL
+51 val_51 51
+51 val_51 51
+53 val_53 53
+53 val_53 NULL
+54 val_54 NULL
+54 val_54 54
+57 val_57 57
+57 val_57 NULL
+58 val_58 NULL
+58 val_58 NULL
+58 val_58 58
+58 val_58 58
64 val_64 64
-468 val_468 468
-76 val_76 76
-74 val_74 74
-342 val_342 342
+64 val_64 NULL
+65 val_65 NULL
+65 val_65 65
+66 val_66 66
+66 val_66 NULL
+67 val_67 NULL
+67 val_67 NULL
+67 val_67 67
+67 val_67 67
69 val_69 69
-230 val_230 230
-33 val_33 33
-368 val_368 368
-103 val_103 103
-296 val_296 296
-113 val_113 113
-216 val_216 216
-367 val_367 367
-344 val_344 344
-167 val_167 167
-274 val_274 274
-219 val_219 219
-239 val_239 239
-485 val_485 485
-116 val_116 116
-223 val_223 223
-256 val_256 256
-263 val_263 263
+69 val_69 NULL
+70 val_70 NULL
+70 val_70 NULL
+70 val_70 NULL
70 val_70 70
-487 val_487 487
-480 val_480 480
-401 val_401 401
-288 val_288 288
-191 val_191 191
-5 val_5 5
-244 val_244 244
-438 val_438 438
-128 val_128 128
-467 val_467 467
-432 val_432 432
-202 val_202 202
-316 val_316 316
-229 val_229 229
-469 val_469 469
-463 val_463 463
-280 val_280 280
-2 val_2 2
-35 val_35 35
-283 val_283 283
-331 val_331 331
-235 val_235 235
-80 val_80 80
-44 val_44 44
-193 val_193 193
-321 val_321 321
-335 val_335 335
-104 val_104 104
-466 val_466 466
-366 val_366 366
-175 val_175 175
-403 val_403 403
-483 val_483 483
-53 val_53 53
-105 val_105 105
-257 val_257 257
-406 val_406 406
-409 val_409 409
-190 val_190 190
-406 val_406 406
-401 val_401 401
-114 val_114 114
-258 val_258 258
-90 val_90 90
-203 val_203 203
-262 val_262 262
-348 val_348 348
-424 val_424 424
-12 val_12 12
-396 val_396 396
-201 val_201 201
-217 val_217 217
-164 val_164 164
-431 val_431 431
-454 val_454 454
-478 val_478 478
-298 val_298 298
-125 val_125 125
-431 val_431 431
-164 val_164 164
-424 val_424 424
-187 val_187 187
-382 val_382 382
-5 val_5 5
70 val_70 70
-397 val_397 397
-480 val_480 480
-291 val_291 291
-24 val_24 24
-351 val_351 351
-255 val_255 255
-104 val_104 104
70 val_70 70
-163 val_163 163
-438 val_438 438
-119 val_119 119
-414 val_414 414
-200 val_200 200
-491 val_491 491
-237 val_237 237
-439 val_439 439
-360 val_360 360
-248 val_248 248
-479 val_479 479
-305 val_305 305
-417 val_417 417
-199 val_199 199
-444 val_444 444
-120 val_120 120
-429 val_429 429
-169 val_169 169
-443 val_443 443
-323 val_323 323
-325 val_325 325
-277 val_277 277
-230 val_230 230
-478 val_478 478
-178 val_178 178
-468 val_468 468
-310 val_310 310
-317 val_317 317
-333 val_333 333
-493 val_493 493
-460 val_460 460
-207 val_207 207
-249 val_249 249
-265 val_265 265
-480 val_480 480
+72 val_72 72
+72 val_72 72
+72 val_72 NULL
+72 val_72 NULL
+74 val_74 NULL
+74 val_74 74
+76 val_76 76
+76 val_76 76
+76 val_76 NULL
+76 val_76 NULL
+77 val_77 NULL
+77 val_77 77
+78 val_78 78
+78 val_78 NULL
+8 val_8 NULL
+8 val_8 8
+80 val_80 80
+80 val_80 NULL
+82 val_82 NULL
+82 val_82 82
83 val_83 83
-136 val_136 136
-353 val_353 353
-172 val_172 172
-214 val_214 214
-462 val_462 462
-233 val_233 233
-406 val_406 406
-133 val_133 133
-175 val_175 175
-189 val_189 189
-454 val_454 454
-375 val_375 375
-401 val_401 401
-421 val_421 421
-407 val_407 407
-384 val_384 384
-256 val_256 256
-26 val_26 26
-134 val_134 134
-67 val_67 67
-384 val_384 384
-379 val_379 379
-18 val_18 18
-462 val_462 462
-492 val_492 492
-100 val_100 100
-298 val_298 298
-9 val_9 9
-341 val_341 341
-498 val_498 498
-146 val_146 146
-458 val_458 458
-362 val_362 362
-186 val_186 186
-285 val_285 285
-348 val_348 348
-167 val_167 167
-18 val_18 18
-273 val_273 273
-183 val_183 183
-281 val_281 281
-344 val_344 344
-97 val_97 97
-469 val_469 469
-315 val_315 315
+83 val_83 83
+83 val_83 NULL
+83 val_83 NULL
+84 val_84 NULL
+84 val_84 NULL
84 val_84 84
-28 val_28 28
-37 val_37 37
-448 val_448 448
-152 val_152 152
-348 val_348 348
-307 val_307 307
-194 val_194 194
-414 val_414 414
-477 val_477 477
-222 val_222 222
-126 val_126 126
+84 val_84 84
+85 val_85 85
+85 val_85 NULL
+86 val_86 NULL
+86 val_86 86
+87 val_87 87
+87 val_87 NULL
+9 val_9 NULL
+9 val_9 9
90 val_90 90
-169 val_169 169
-403 val_403 403
-400 val_400 400
-200 val_200 200
+90 val_90 90
+90 val_90 90
+90 val_90 NULL
+90 val_90 NULL
+90 val_90 NULL
+92 val_92 NULL
+92 val_92 92
+95 val_95 95
+95 val_95 95
+95 val_95 NULL
+95 val_95 NULL
+96 val_96 NULL
+96 val_96 96
+97 val_97 97
97 val_97 97
+97 val_97 NULL
+97 val_97 NULL
+98 val_98 NULL
+98 val_98 NULL
+98 val_98 98
+98 val_98 98
PREHOOK: query: drop table partition_vs_table
PREHOOK: type: DROPTABLE
POSTHOOK: query: drop table partition_vs_table
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/rand_partitionpruner1.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/rand_partitionpruner1.q.out?rev=894876&r1=894875&r2=894876&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/rand_partitionpruner1.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/rand_partitionpruner1.q.out Thu Dec 31 16:04:45 2009
@@ -33,7 +33,7 @@
File Output Operator
compressed: false
GlobalTableId: 0
- directory: file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/2004739619/10001
+ directory: file:/data/users/jsichi/open/hive-trunk/build/ql/tmp/1281920331/10001
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -43,10 +43,11 @@
columns.types string:string
Needs Tagging: false
Path -> Alias:
- file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/src [src]
+ file:/data/users/jsichi/open/hive-trunk/build/ql/test/data/warehouse/src [src]
Path -> Partition:
- file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/src
+ file:/data/users/jsichi/open/hive-trunk/build/ql/test/data/warehouse/src
Partition
+ base file name: src
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
@@ -59,7 +60,8 @@
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/src
+ location file:/data/users/jsichi/open/hive-trunk/build/ql/test/data/warehouse/src
+ transient_lastDdlTime 1262137321
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -74,8 +76,8 @@
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/src
- transient_lastDdlTime 1258006469
+ location file:/data/users/jsichi/open/hive-trunk/build/ql/test/data/warehouse/src
+ transient_lastDdlTime 1262137321
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: src
name: src
@@ -88,11 +90,11 @@
PREHOOK: query: select * from src where rand(1) < 0.1
PREHOOK: type: QUERY
PREHOOK: Input: default@src
-PREHOOK: Output: file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/1716777655/10000
+PREHOOK: Output: file:/data/users/jsichi/open/hive-trunk/build/ql/tmp/1343937738/10000
POSTHOOK: query: select * from src where rand(1) < 0.1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/1716777655/10000
+POSTHOOK: Output: file:/data/users/jsichi/open/hive-trunk/build/ql/tmp/1343937738/10000
409 val_409
429 val_429
209 val_209
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/rand_partitionpruner2.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/rand_partitionpruner2.q.out?rev=894876&r1=894875&r2=894876&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/rand_partitionpruner2.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/rand_partitionpruner2.q.out Thu Dec 31 16:04:45 2009
@@ -51,7 +51,7 @@
File Output Operator
compressed: false
GlobalTableId: 1
- directory: file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/651324075/10002
+ directory: file:/data/users/jsichi/open/hive-trunk/build/ql/tmp/708123735/10002
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -65,17 +65,18 @@
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/tmptable
- transient_lastDdlTime 1258006480
+ location file:/data/users/jsichi/open/hive-trunk/build/ql/test/data/warehouse/tmptable
+ transient_lastDdlTime 1262137327
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: tmptable
Needs Tagging: false
Path -> Alias:
- file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11 [a]
- file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12 [a]
+ file:/data/users/jsichi/open/hive-trunk/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11 [a]
+ file:/data/users/jsichi/open/hive-trunk/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12 [a]
Path -> Partition:
- file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11
+ file:/data/users/jsichi/open/hive-trunk/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11
Partition
+ base file name: hr=11
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
partition values:
@@ -92,8 +93,8 @@
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11
- transient_lastDdlTime 1258006477
+ location file:/data/users/jsichi/open/hive-trunk/build/ql/test/data/warehouse/srcpart
+ transient_lastDdlTime 1262137325
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -109,13 +110,14 @@
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/srcpart
- transient_lastDdlTime 1258006477
+ location file:/data/users/jsichi/open/hive-trunk/build/ql/test/data/warehouse/srcpart
+ transient_lastDdlTime 1262137325
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: srcpart
name: srcpart
- file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12
+ file:/data/users/jsichi/open/hive-trunk/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12
Partition
+ base file name: hr=12
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
partition values:
@@ -132,8 +134,8 @@
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12
- transient_lastDdlTime 1258006477
+ location file:/data/users/jsichi/open/hive-trunk/build/ql/test/data/warehouse/srcpart
+ transient_lastDdlTime 1262137325
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -149,8 +151,8 @@
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/srcpart
- transient_lastDdlTime 1258006477
+ location file:/data/users/jsichi/open/hive-trunk/build/ql/test/data/warehouse/srcpart
+ transient_lastDdlTime 1262137325
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: srcpart
name: srcpart
@@ -161,11 +163,11 @@
Move Operator
files:
hdfs directory: true
- source: file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/651324075/10002
- destination: file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/795015032/10000
+ source: file:/data/users/jsichi/open/hive-trunk/build/ql/tmp/708123735/10002
+ destination: file:/data/users/jsichi/open/hive-trunk/build/ql/tmp/1978884338/10000
Map Reduce
Alias -> Map Operator Tree:
- file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/651324075/10002
+ file:/data/users/jsichi/open/hive-trunk/build/ql/tmp/708123735/10002
Reduce Output Operator
sort order:
Map-reduce partition columns:
@@ -183,10 +185,11 @@
type: string
Needs Tagging: false
Path -> Alias:
- file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/651324075/10002 [file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/651324075/10002]
+ file:/data/users/jsichi/open/hive-trunk/build/ql/tmp/708123735/10002 [file:/data/users/jsichi/open/hive-trunk/build/ql/tmp/708123735/10002]
Path -> Partition:
- file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/651324075/10002
+ file:/data/users/jsichi/open/hive-trunk/build/ql/tmp/708123735/10002
Partition
+ base file name: 10002
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
@@ -199,8 +202,8 @@
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/tmptable
- transient_lastDdlTime 1258006480
+ location file:/data/users/jsichi/open/hive-trunk/build/ql/test/data/warehouse/tmptable
+ transient_lastDdlTime 1262137327
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -215,8 +218,8 @@
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/tmptable
- transient_lastDdlTime 1258006480
+ location file:/data/users/jsichi/open/hive-trunk/build/ql/test/data/warehouse/tmptable
+ transient_lastDdlTime 1262137327
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: tmptable
name: tmptable
@@ -225,7 +228,7 @@
File Output Operator
compressed: false
GlobalTableId: 0
- directory: file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/795015032/10000
+ directory: file:/data/users/jsichi/open/hive-trunk/build/ql/tmp/1978884338/10000
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -238,9 +241,9 @@
bucket_count -1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
file.inputformat org.apache.hadoop.mapred.TextInputFormat
- location file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/tmptable
+ location file:/data/users/jsichi/open/hive-trunk/build/ql/test/data/warehouse/tmptable
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- transient_lastDdlTime 1258006480
+ transient_lastDdlTime 1262137327
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: tmptable
@@ -248,7 +251,7 @@
Move Operator
tables:
replace: true
- source: file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/795015032/10000
+ source: file:/data/users/jsichi/open/hive-trunk/build/ql/tmp/1978884338/10000
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -262,11 +265,11 @@
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/tmptable
- transient_lastDdlTime 1258006480
+ location file:/data/users/jsichi/open/hive-trunk/build/ql/test/data/warehouse/tmptable
+ transient_lastDdlTime 1262137327
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: tmptable
- tmp directory: file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/795015032/10001
+ tmp directory: file:/data/users/jsichi/open/hive-trunk/build/ql/tmp/1978884338/10001
PREHOOK: query: insert overwrite table tmptable
@@ -284,11 +287,11 @@
PREHOOK: query: select * from tmptable x sort by x.key,x.value,x.ds,x.hr
PREHOOK: type: QUERY
PREHOOK: Input: default@tmptable
-PREHOOK: Output: file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/1958926056/10000
+PREHOOK: Output: file:/data/users/jsichi/open/hive-trunk/build/ql/tmp/1574792529/10000
POSTHOOK: query: select * from tmptable x sort by x.key,x.value,x.ds,x.hr
POSTHOOK: type: QUERY
POSTHOOK: Input: default@tmptable
-POSTHOOK: Output: file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/1958926056/10000
+POSTHOOK: Output: file:/data/users/jsichi/open/hive-trunk/build/ql/tmp/1574792529/10000
103 val_103 2008-04-08 11
103 val_103 2008-04-08 12
133 val_133 2008-04-08 11
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/rand_partitionpruner3.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/rand_partitionpruner3.q.out?rev=894876&r1=894875&r2=894876&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/rand_partitionpruner3.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/rand_partitionpruner3.q.out Thu Dec 31 16:04:45 2009
@@ -39,7 +39,7 @@
File Output Operator
compressed: false
GlobalTableId: 0
- directory: file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/780091764/10001
+ directory: file:/data/users/jsichi/open/hive-trunk/build/ql/tmp/124088894/10001
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -49,10 +49,11 @@
columns.types string:string:string:string
Needs Tagging: false
Path -> Alias:
- file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12 [a]
+ file:/data/users/jsichi/open/hive-trunk/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12 [a]
Path -> Partition:
- file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12
+ file:/data/users/jsichi/open/hive-trunk/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12
Partition
+ base file name: hr=12
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
partition values:
@@ -69,8 +70,8 @@
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12
- transient_lastDdlTime 1258006498
+ location file:/data/users/jsichi/open/hive-trunk/build/ql/test/data/warehouse/srcpart
+ transient_lastDdlTime 1262137336
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -86,8 +87,8 @@
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/srcpart
- transient_lastDdlTime 1258006497
+ location file:/data/users/jsichi/open/hive-trunk/build/ql/test/data/warehouse/srcpart
+ transient_lastDdlTime 1262137336
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: srcpart
name: srcpart
@@ -100,11 +101,11 @@
PREHOOK: query: select a.* from srcpart a where rand(1) < 0.1 and a.ds = '2008-04-08' and not(key > 50 or key < 10) and a.hr like '%2'
PREHOOK: type: QUERY
PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
-PREHOOK: Output: file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/816468025/10000
+PREHOOK: Output: file:/data/users/jsichi/open/hive-trunk/build/ql/tmp/1944369228/10000
POSTHOOK: query: select a.* from srcpart a where rand(1) < 0.1 and a.ds = '2008-04-08' and not(key > 50 or key < 10) and a.hr like '%2'
POSTHOOK: type: QUERY
POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
-POSTHOOK: Output: file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/816468025/10000
+POSTHOOK: Output: file:/data/users/jsichi/open/hive-trunk/build/ql/tmp/1944369228/10000
42 val_42 2008-04-08 12
44 val_44 2008-04-08 12
26 val_26 2008-04-08 12
@@ -154,7 +155,7 @@
File Output Operator
compressed: false
GlobalTableId: 0
- directory: file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/1939062935/10001
+ directory: file:/data/users/jsichi/open/hive-trunk/build/ql/tmp/1956461194/10001
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -164,10 +165,11 @@
columns.types string:string:string:string
Needs Tagging: false
Path -> Alias:
- file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12 [a]
+ file:/data/users/jsichi/open/hive-trunk/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12 [a]
Path -> Partition:
- file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12
+ file:/data/users/jsichi/open/hive-trunk/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12
Partition
+ base file name: hr=12
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
partition values:
@@ -184,8 +186,8 @@
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12
- transient_lastDdlTime 1258006498
+ location file:/data/users/jsichi/open/hive-trunk/build/ql/test/data/warehouse/srcpart
+ transient_lastDdlTime 1262137336
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -201,8 +203,8 @@
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/srcpart
- transient_lastDdlTime 1258006497
+ location file:/data/users/jsichi/open/hive-trunk/build/ql/test/data/warehouse/srcpart
+ transient_lastDdlTime 1262137336
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: srcpart
name: srcpart
@@ -215,11 +217,11 @@
PREHOOK: query: select a.* from srcpart a where a.ds = '2008-04-08' and not(key > 50 or key < 10) and a.hr like '%2'
PREHOOK: type: QUERY
PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
-PREHOOK: Output: file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/1002353747/10000
+PREHOOK: Output: file:/data/users/jsichi/open/hive-trunk/build/ql/tmp/1681163814/10000
POSTHOOK: query: select a.* from srcpart a where a.ds = '2008-04-08' and not(key > 50 or key < 10) and a.hr like '%2'
POSTHOOK: type: QUERY
POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
-POSTHOOK: Output: file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/1002353747/10000
+POSTHOOK: Output: file:/data/users/jsichi/open/hive-trunk/build/ql/tmp/1681163814/10000
27 val_27 2008-04-08 12
37 val_37 2008-04-08 12
15 val_15 2008-04-08 12
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/regexp_extract.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/regexp_extract.q.out?rev=894876&r1=894875&r2=894876&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/regexp_extract.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/regexp_extract.q.out Thu Dec 31 16:04:45 2009
@@ -68,10 +68,11 @@
type: string
Needs Tagging: false
Path -> Alias:
- file:/data/users/nzhang/work/870/apache-hive/build/ql/test/data/warehouse/src [tmap:src]
+ file:/data/users/jsichi/open/hive-trunk/build/ql/test/data/warehouse/src [tmap:src]
Path -> Partition:
- file:/data/users/nzhang/work/870/apache-hive/build/ql/test/data/warehouse/src
+ file:/data/users/jsichi/open/hive-trunk/build/ql/test/data/warehouse/src
Partition
+ base file name: src
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
@@ -84,8 +85,8 @@
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/data/users/nzhang/work/870/apache-hive/build/ql/test/data/warehouse/src
- transient_lastDdlTime 1261529841
+ location file:/data/users/jsichi/open/hive-trunk/build/ql/test/data/warehouse/src
+ transient_lastDdlTime 1262137436
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -100,8 +101,8 @@
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/data/users/nzhang/work/870/apache-hive/build/ql/test/data/warehouse/src
- transient_lastDdlTime 1261529841
+ location file:/data/users/jsichi/open/hive-trunk/build/ql/test/data/warehouse/src
+ transient_lastDdlTime 1262137436
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: src
name: src
@@ -122,7 +123,7 @@
File Output Operator
compressed: false
GlobalTableId: 0
- directory: file:/data/users/nzhang/work/870/apache-hive/build/ql/tmp/1967522222/10001
+ directory: file:/data/users/jsichi/open/hive-trunk/build/ql/tmp/237484840/10001
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -145,7 +146,7 @@
SELECT tmap.key, regexp_extract(tmap.value, 'val_(\\d+\\t\\d+)',1) WHERE tmap.key < 100
PREHOOK: type: QUERY
PREHOOK: Input: default@src
-PREHOOK: Output: file:/data/users/nzhang/work/870/apache-hive/build/ql/tmp/1689304784/10000
+PREHOOK: Output: file:/data/users/jsichi/open/hive-trunk/build/ql/tmp/687662347/10000
POSTHOOK: query: FROM (
FROM src
SELECT TRANSFORM(src.key, src.value, 1+2, 3+4)
@@ -155,7 +156,7 @@
SELECT tmap.key, regexp_extract(tmap.value, 'val_(\\d+\\t\\d+)',1) WHERE tmap.key < 100
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/data/users/nzhang/work/870/apache-hive/build/ql/tmp/1689304784/10000
+POSTHOOK: Output: file:/data/users/jsichi/open/hive-trunk/build/ql/tmp/687662347/10000
0 0 3
0 0 3
0 0 3
@@ -310,10 +311,11 @@
type: string
Needs Tagging: false
Path -> Alias:
- file:/data/users/nzhang/work/870/apache-hive/build/ql/test/data/warehouse/src [tmap:src]
+ file:/data/users/jsichi/open/hive-trunk/build/ql/test/data/warehouse/src [tmap:src]
Path -> Partition:
- file:/data/users/nzhang/work/870/apache-hive/build/ql/test/data/warehouse/src
+ file:/data/users/jsichi/open/hive-trunk/build/ql/test/data/warehouse/src
Partition
+ base file name: src
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
@@ -326,8 +328,8 @@
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/data/users/nzhang/work/870/apache-hive/build/ql/test/data/warehouse/src
- transient_lastDdlTime 1261529841
+ location file:/data/users/jsichi/open/hive-trunk/build/ql/test/data/warehouse/src
+ transient_lastDdlTime 1262137436
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -342,8 +344,8 @@
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/data/users/nzhang/work/870/apache-hive/build/ql/test/data/warehouse/src
- transient_lastDdlTime 1261529841
+ location file:/data/users/jsichi/open/hive-trunk/build/ql/test/data/warehouse/src
+ transient_lastDdlTime 1262137436
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: src
name: src
@@ -364,7 +366,7 @@
File Output Operator
compressed: false
GlobalTableId: 0
- directory: file:/data/users/nzhang/work/870/apache-hive/build/ql/tmp/837479572/10001
+ directory: file:/data/users/jsichi/open/hive-trunk/build/ql/tmp/1239765305/10001
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -387,7 +389,7 @@
SELECT tmap.key, regexp_extract(tmap.value, 'val_(\\d+\\t\\d+)') WHERE tmap.key < 100
PREHOOK: type: QUERY
PREHOOK: Input: default@src
-PREHOOK: Output: file:/data/users/nzhang/work/870/apache-hive/build/ql/tmp/209947857/10000
+PREHOOK: Output: file:/data/users/jsichi/open/hive-trunk/build/ql/tmp/1514486187/10000
POSTHOOK: query: FROM (
FROM src
SELECT TRANSFORM(src.key, src.value, 1+2, 3+4)
@@ -397,7 +399,7 @@
SELECT tmap.key, regexp_extract(tmap.value, 'val_(\\d+\\t\\d+)') WHERE tmap.key < 100
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/data/users/nzhang/work/870/apache-hive/build/ql/tmp/209947857/10000
+POSTHOOK: Output: file:/data/users/jsichi/open/hive-trunk/build/ql/tmp/1514486187/10000
0 0 3
0 0 3
0 0 3