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 dh...@apache.org on 2008/11/11 02:50:18 UTC
svn commit: r712905 [9/38] - in /hadoop/core/trunk: ./ src/contrib/hive/
src/contrib/hive/cli/src/java/org/apache/hadoop/hive/cli/
src/contrib/hive/common/src/java/org/apache/hadoop/hive/conf/
src/contrib/hive/conf/ src/contrib/hive/data/files/ src/con...
Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input12.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input12.q.out?rev=712905&r1=712904&r2=712905&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input12.q.out (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input12.q.out Mon Nov 10 17:50:06 2008
@@ -13,7 +13,7 @@
Filter Operator
predicate:
expr: (key < 100)
- type: Boolean
+ type: boolean
Select Operator
expressions:
expr: key
@@ -29,7 +29,7 @@
Filter Operator
predicate:
expr: ((key >= 100) and (key < 200))
- type: Boolean
+ type: boolean
Select Operator
expressions:
expr: key
@@ -45,7 +45,7 @@
Filter Operator
predicate:
expr: (key >= 200)
- type: Boolean
+ type: boolean
Select Operator
expressions:
expr: key
@@ -272,314 +272,314 @@
194 val_194
126 val_126
169 val_169
-238 NULL 2008-04-08 12
-311 NULL 2008-04-08 12
-409 NULL 2008-04-08 12
-255 NULL 2008-04-08 12
-278 NULL 2008-04-08 12
-484 NULL 2008-04-08 12
-265 NULL 2008-04-08 12
-401 NULL 2008-04-08 12
-273 NULL 2008-04-08 12
-224 NULL 2008-04-08 12
-369 NULL 2008-04-08 12
-213 NULL 2008-04-08 12
-406 NULL 2008-04-08 12
-429 NULL 2008-04-08 12
-374 NULL 2008-04-08 12
-469 NULL 2008-04-08 12
-495 NULL 2008-04-08 12
-327 NULL 2008-04-08 12
-281 NULL 2008-04-08 12
-277 NULL 2008-04-08 12
-209 NULL 2008-04-08 12
-403 NULL 2008-04-08 12
-417 NULL 2008-04-08 12
-430 NULL 2008-04-08 12
-252 NULL 2008-04-08 12
-292 NULL 2008-04-08 12
-219 NULL 2008-04-08 12
-287 NULL 2008-04-08 12
-338 NULL 2008-04-08 12
-446 NULL 2008-04-08 12
-459 NULL 2008-04-08 12
-394 NULL 2008-04-08 12
-237 NULL 2008-04-08 12
-482 NULL 2008-04-08 12
-413 NULL 2008-04-08 12
-494 NULL 2008-04-08 12
-207 NULL 2008-04-08 12
-466 NULL 2008-04-08 12
-208 NULL 2008-04-08 12
-399 NULL 2008-04-08 12
-396 NULL 2008-04-08 12
-247 NULL 2008-04-08 12
-417 NULL 2008-04-08 12
-489 NULL 2008-04-08 12
-377 NULL 2008-04-08 12
-397 NULL 2008-04-08 12
-309 NULL 2008-04-08 12
-365 NULL 2008-04-08 12
-266 NULL 2008-04-08 12
-439 NULL 2008-04-08 12
-342 NULL 2008-04-08 12
-367 NULL 2008-04-08 12
-325 NULL 2008-04-08 12
-475 NULL 2008-04-08 12
-203 NULL 2008-04-08 12
-339 NULL 2008-04-08 12
-455 NULL 2008-04-08 12
-311 NULL 2008-04-08 12
-316 NULL 2008-04-08 12
-302 NULL 2008-04-08 12
-205 NULL 2008-04-08 12
-438 NULL 2008-04-08 12
-345 NULL 2008-04-08 12
-489 NULL 2008-04-08 12
-378 NULL 2008-04-08 12
-221 NULL 2008-04-08 12
-280 NULL 2008-04-08 12
-427 NULL 2008-04-08 12
-277 NULL 2008-04-08 12
-208 NULL 2008-04-08 12
-356 NULL 2008-04-08 12
-399 NULL 2008-04-08 12
-382 NULL 2008-04-08 12
-498 NULL 2008-04-08 12
-386 NULL 2008-04-08 12
-437 NULL 2008-04-08 12
-469 NULL 2008-04-08 12
-286 NULL 2008-04-08 12
-459 NULL 2008-04-08 12
-239 NULL 2008-04-08 12
-213 NULL 2008-04-08 12
-216 NULL 2008-04-08 12
-430 NULL 2008-04-08 12
-278 NULL 2008-04-08 12
-289 NULL 2008-04-08 12
-221 NULL 2008-04-08 12
-318 NULL 2008-04-08 12
-332 NULL 2008-04-08 12
-311 NULL 2008-04-08 12
-275 NULL 2008-04-08 12
-241 NULL 2008-04-08 12
-333 NULL 2008-04-08 12
-284 NULL 2008-04-08 12
-230 NULL 2008-04-08 12
-260 NULL 2008-04-08 12
-404 NULL 2008-04-08 12
-384 NULL 2008-04-08 12
-489 NULL 2008-04-08 12
-353 NULL 2008-04-08 12
-373 NULL 2008-04-08 12
-272 NULL 2008-04-08 12
-217 NULL 2008-04-08 12
-348 NULL 2008-04-08 12
-466 NULL 2008-04-08 12
-411 NULL 2008-04-08 12
-230 NULL 2008-04-08 12
-208 NULL 2008-04-08 12
-348 NULL 2008-04-08 12
-463 NULL 2008-04-08 12
-431 NULL 2008-04-08 12
-496 NULL 2008-04-08 12
-322 NULL 2008-04-08 12
-468 NULL 2008-04-08 12
-393 NULL 2008-04-08 12
-454 NULL 2008-04-08 12
-298 NULL 2008-04-08 12
-418 NULL 2008-04-08 12
-327 NULL 2008-04-08 12
-230 NULL 2008-04-08 12
-205 NULL 2008-04-08 12
-404 NULL 2008-04-08 12
-436 NULL 2008-04-08 12
-469 NULL 2008-04-08 12
-468 NULL 2008-04-08 12
-308 NULL 2008-04-08 12
-288 NULL 2008-04-08 12
-481 NULL 2008-04-08 12
-457 NULL 2008-04-08 12
-282 NULL 2008-04-08 12
-318 NULL 2008-04-08 12
-318 NULL 2008-04-08 12
-409 NULL 2008-04-08 12
-470 NULL 2008-04-08 12
-369 NULL 2008-04-08 12
-316 NULL 2008-04-08 12
-413 NULL 2008-04-08 12
-490 NULL 2008-04-08 12
-364 NULL 2008-04-08 12
-395 NULL 2008-04-08 12
-282 NULL 2008-04-08 12
-238 NULL 2008-04-08 12
-419 NULL 2008-04-08 12
-307 NULL 2008-04-08 12
-435 NULL 2008-04-08 12
-277 NULL 2008-04-08 12
-273 NULL 2008-04-08 12
-306 NULL 2008-04-08 12
-224 NULL 2008-04-08 12
-309 NULL 2008-04-08 12
-389 NULL 2008-04-08 12
-327 NULL 2008-04-08 12
-242 NULL 2008-04-08 12
-369 NULL 2008-04-08 12
-392 NULL 2008-04-08 12
-272 NULL 2008-04-08 12
-331 NULL 2008-04-08 12
-401 NULL 2008-04-08 12
-242 NULL 2008-04-08 12
-452 NULL 2008-04-08 12
-226 NULL 2008-04-08 12
-497 NULL 2008-04-08 12
-402 NULL 2008-04-08 12
-396 NULL 2008-04-08 12
-317 NULL 2008-04-08 12
-395 NULL 2008-04-08 12
-336 NULL 2008-04-08 12
-229 NULL 2008-04-08 12
-233 NULL 2008-04-08 12
-472 NULL 2008-04-08 12
-322 NULL 2008-04-08 12
-498 NULL 2008-04-08 12
-321 NULL 2008-04-08 12
-430 NULL 2008-04-08 12
-489 NULL 2008-04-08 12
-458 NULL 2008-04-08 12
-223 NULL 2008-04-08 12
-492 NULL 2008-04-08 12
-449 NULL 2008-04-08 12
-218 NULL 2008-04-08 12
-228 NULL 2008-04-08 12
-453 NULL 2008-04-08 12
-209 NULL 2008-04-08 12
-468 NULL 2008-04-08 12
-342 NULL 2008-04-08 12
-230 NULL 2008-04-08 12
-368 NULL 2008-04-08 12
-296 NULL 2008-04-08 12
-216 NULL 2008-04-08 12
-367 NULL 2008-04-08 12
-344 NULL 2008-04-08 12
-274 NULL 2008-04-08 12
-219 NULL 2008-04-08 12
-239 NULL 2008-04-08 12
-485 NULL 2008-04-08 12
-223 NULL 2008-04-08 12
-256 NULL 2008-04-08 12
-263 NULL 2008-04-08 12
-487 NULL 2008-04-08 12
-480 NULL 2008-04-08 12
-401 NULL 2008-04-08 12
-288 NULL 2008-04-08 12
-244 NULL 2008-04-08 12
-438 NULL 2008-04-08 12
-467 NULL 2008-04-08 12
-432 NULL 2008-04-08 12
-202 NULL 2008-04-08 12
-316 NULL 2008-04-08 12
-229 NULL 2008-04-08 12
-469 NULL 2008-04-08 12
-463 NULL 2008-04-08 12
-280 NULL 2008-04-08 12
-283 NULL 2008-04-08 12
-331 NULL 2008-04-08 12
-235 NULL 2008-04-08 12
-321 NULL 2008-04-08 12
-335 NULL 2008-04-08 12
-466 NULL 2008-04-08 12
-366 NULL 2008-04-08 12
-403 NULL 2008-04-08 12
-483 NULL 2008-04-08 12
-257 NULL 2008-04-08 12
-406 NULL 2008-04-08 12
-409 NULL 2008-04-08 12
-406 NULL 2008-04-08 12
-401 NULL 2008-04-08 12
-258 NULL 2008-04-08 12
-203 NULL 2008-04-08 12
-262 NULL 2008-04-08 12
-348 NULL 2008-04-08 12
-424 NULL 2008-04-08 12
-396 NULL 2008-04-08 12
-201 NULL 2008-04-08 12
-217 NULL 2008-04-08 12
-431 NULL 2008-04-08 12
-454 NULL 2008-04-08 12
-478 NULL 2008-04-08 12
-298 NULL 2008-04-08 12
-431 NULL 2008-04-08 12
-424 NULL 2008-04-08 12
-382 NULL 2008-04-08 12
-397 NULL 2008-04-08 12
-480 NULL 2008-04-08 12
-291 NULL 2008-04-08 12
-351 NULL 2008-04-08 12
-255 NULL 2008-04-08 12
-438 NULL 2008-04-08 12
-414 NULL 2008-04-08 12
-200 NULL 2008-04-08 12
-491 NULL 2008-04-08 12
-237 NULL 2008-04-08 12
-439 NULL 2008-04-08 12
-360 NULL 2008-04-08 12
-248 NULL 2008-04-08 12
-479 NULL 2008-04-08 12
-305 NULL 2008-04-08 12
-417 NULL 2008-04-08 12
-444 NULL 2008-04-08 12
-429 NULL 2008-04-08 12
-443 NULL 2008-04-08 12
-323 NULL 2008-04-08 12
-325 NULL 2008-04-08 12
-277 NULL 2008-04-08 12
-230 NULL 2008-04-08 12
-478 NULL 2008-04-08 12
-468 NULL 2008-04-08 12
-310 NULL 2008-04-08 12
-317 NULL 2008-04-08 12
-333 NULL 2008-04-08 12
-493 NULL 2008-04-08 12
-460 NULL 2008-04-08 12
-207 NULL 2008-04-08 12
-249 NULL 2008-04-08 12
-265 NULL 2008-04-08 12
-480 NULL 2008-04-08 12
-353 NULL 2008-04-08 12
-214 NULL 2008-04-08 12
-462 NULL 2008-04-08 12
-233 NULL 2008-04-08 12
-406 NULL 2008-04-08 12
-454 NULL 2008-04-08 12
-375 NULL 2008-04-08 12
-401 NULL 2008-04-08 12
-421 NULL 2008-04-08 12
-407 NULL 2008-04-08 12
-384 NULL 2008-04-08 12
-256 NULL 2008-04-08 12
-384 NULL 2008-04-08 12
-379 NULL 2008-04-08 12
-462 NULL 2008-04-08 12
-492 NULL 2008-04-08 12
-298 NULL 2008-04-08 12
-341 NULL 2008-04-08 12
-498 NULL 2008-04-08 12
-458 NULL 2008-04-08 12
-362 NULL 2008-04-08 12
-285 NULL 2008-04-08 12
-348 NULL 2008-04-08 12
-273 NULL 2008-04-08 12
-281 NULL 2008-04-08 12
-344 NULL 2008-04-08 12
-469 NULL 2008-04-08 12
-315 NULL 2008-04-08 12
-448 NULL 2008-04-08 12
-348 NULL 2008-04-08 12
-307 NULL 2008-04-08 12
-414 NULL 2008-04-08 12
-477 NULL 2008-04-08 12
-222 NULL 2008-04-08 12
-403 NULL 2008-04-08 12
-400 NULL 2008-04-08 12
-200 NULL 2008-04-08 12
+238 2008-04-08 12
+311 2008-04-08 12
+409 2008-04-08 12
+255 2008-04-08 12
+278 2008-04-08 12
+484 2008-04-08 12
+265 2008-04-08 12
+401 2008-04-08 12
+273 2008-04-08 12
+224 2008-04-08 12
+369 2008-04-08 12
+213 2008-04-08 12
+406 2008-04-08 12
+429 2008-04-08 12
+374 2008-04-08 12
+469 2008-04-08 12
+495 2008-04-08 12
+327 2008-04-08 12
+281 2008-04-08 12
+277 2008-04-08 12
+209 2008-04-08 12
+403 2008-04-08 12
+417 2008-04-08 12
+430 2008-04-08 12
+252 2008-04-08 12
+292 2008-04-08 12
+219 2008-04-08 12
+287 2008-04-08 12
+338 2008-04-08 12
+446 2008-04-08 12
+459 2008-04-08 12
+394 2008-04-08 12
+237 2008-04-08 12
+482 2008-04-08 12
+413 2008-04-08 12
+494 2008-04-08 12
+207 2008-04-08 12
+466 2008-04-08 12
+208 2008-04-08 12
+399 2008-04-08 12
+396 2008-04-08 12
+247 2008-04-08 12
+417 2008-04-08 12
+489 2008-04-08 12
+377 2008-04-08 12
+397 2008-04-08 12
+309 2008-04-08 12
+365 2008-04-08 12
+266 2008-04-08 12
+439 2008-04-08 12
+342 2008-04-08 12
+367 2008-04-08 12
+325 2008-04-08 12
+475 2008-04-08 12
+203 2008-04-08 12
+339 2008-04-08 12
+455 2008-04-08 12
+311 2008-04-08 12
+316 2008-04-08 12
+302 2008-04-08 12
+205 2008-04-08 12
+438 2008-04-08 12
+345 2008-04-08 12
+489 2008-04-08 12
+378 2008-04-08 12
+221 2008-04-08 12
+280 2008-04-08 12
+427 2008-04-08 12
+277 2008-04-08 12
+208 2008-04-08 12
+356 2008-04-08 12
+399 2008-04-08 12
+382 2008-04-08 12
+498 2008-04-08 12
+386 2008-04-08 12
+437 2008-04-08 12
+469 2008-04-08 12
+286 2008-04-08 12
+459 2008-04-08 12
+239 2008-04-08 12
+213 2008-04-08 12
+216 2008-04-08 12
+430 2008-04-08 12
+278 2008-04-08 12
+289 2008-04-08 12
+221 2008-04-08 12
+318 2008-04-08 12
+332 2008-04-08 12
+311 2008-04-08 12
+275 2008-04-08 12
+241 2008-04-08 12
+333 2008-04-08 12
+284 2008-04-08 12
+230 2008-04-08 12
+260 2008-04-08 12
+404 2008-04-08 12
+384 2008-04-08 12
+489 2008-04-08 12
+353 2008-04-08 12
+373 2008-04-08 12
+272 2008-04-08 12
+217 2008-04-08 12
+348 2008-04-08 12
+466 2008-04-08 12
+411 2008-04-08 12
+230 2008-04-08 12
+208 2008-04-08 12
+348 2008-04-08 12
+463 2008-04-08 12
+431 2008-04-08 12
+496 2008-04-08 12
+322 2008-04-08 12
+468 2008-04-08 12
+393 2008-04-08 12
+454 2008-04-08 12
+298 2008-04-08 12
+418 2008-04-08 12
+327 2008-04-08 12
+230 2008-04-08 12
+205 2008-04-08 12
+404 2008-04-08 12
+436 2008-04-08 12
+469 2008-04-08 12
+468 2008-04-08 12
+308 2008-04-08 12
+288 2008-04-08 12
+481 2008-04-08 12
+457 2008-04-08 12
+282 2008-04-08 12
+318 2008-04-08 12
+318 2008-04-08 12
+409 2008-04-08 12
+470 2008-04-08 12
+369 2008-04-08 12
+316 2008-04-08 12
+413 2008-04-08 12
+490 2008-04-08 12
+364 2008-04-08 12
+395 2008-04-08 12
+282 2008-04-08 12
+238 2008-04-08 12
+419 2008-04-08 12
+307 2008-04-08 12
+435 2008-04-08 12
+277 2008-04-08 12
+273 2008-04-08 12
+306 2008-04-08 12
+224 2008-04-08 12
+309 2008-04-08 12
+389 2008-04-08 12
+327 2008-04-08 12
+242 2008-04-08 12
+369 2008-04-08 12
+392 2008-04-08 12
+272 2008-04-08 12
+331 2008-04-08 12
+401 2008-04-08 12
+242 2008-04-08 12
+452 2008-04-08 12
+226 2008-04-08 12
+497 2008-04-08 12
+402 2008-04-08 12
+396 2008-04-08 12
+317 2008-04-08 12
+395 2008-04-08 12
+336 2008-04-08 12
+229 2008-04-08 12
+233 2008-04-08 12
+472 2008-04-08 12
+322 2008-04-08 12
+498 2008-04-08 12
+321 2008-04-08 12
+430 2008-04-08 12
+489 2008-04-08 12
+458 2008-04-08 12
+223 2008-04-08 12
+492 2008-04-08 12
+449 2008-04-08 12
+218 2008-04-08 12
+228 2008-04-08 12
+453 2008-04-08 12
+209 2008-04-08 12
+468 2008-04-08 12
+342 2008-04-08 12
+230 2008-04-08 12
+368 2008-04-08 12
+296 2008-04-08 12
+216 2008-04-08 12
+367 2008-04-08 12
+344 2008-04-08 12
+274 2008-04-08 12
+219 2008-04-08 12
+239 2008-04-08 12
+485 2008-04-08 12
+223 2008-04-08 12
+256 2008-04-08 12
+263 2008-04-08 12
+487 2008-04-08 12
+480 2008-04-08 12
+401 2008-04-08 12
+288 2008-04-08 12
+244 2008-04-08 12
+438 2008-04-08 12
+467 2008-04-08 12
+432 2008-04-08 12
+202 2008-04-08 12
+316 2008-04-08 12
+229 2008-04-08 12
+469 2008-04-08 12
+463 2008-04-08 12
+280 2008-04-08 12
+283 2008-04-08 12
+331 2008-04-08 12
+235 2008-04-08 12
+321 2008-04-08 12
+335 2008-04-08 12
+466 2008-04-08 12
+366 2008-04-08 12
+403 2008-04-08 12
+483 2008-04-08 12
+257 2008-04-08 12
+406 2008-04-08 12
+409 2008-04-08 12
+406 2008-04-08 12
+401 2008-04-08 12
+258 2008-04-08 12
+203 2008-04-08 12
+262 2008-04-08 12
+348 2008-04-08 12
+424 2008-04-08 12
+396 2008-04-08 12
+201 2008-04-08 12
+217 2008-04-08 12
+431 2008-04-08 12
+454 2008-04-08 12
+478 2008-04-08 12
+298 2008-04-08 12
+431 2008-04-08 12
+424 2008-04-08 12
+382 2008-04-08 12
+397 2008-04-08 12
+480 2008-04-08 12
+291 2008-04-08 12
+351 2008-04-08 12
+255 2008-04-08 12
+438 2008-04-08 12
+414 2008-04-08 12
+200 2008-04-08 12
+491 2008-04-08 12
+237 2008-04-08 12
+439 2008-04-08 12
+360 2008-04-08 12
+248 2008-04-08 12
+479 2008-04-08 12
+305 2008-04-08 12
+417 2008-04-08 12
+444 2008-04-08 12
+429 2008-04-08 12
+443 2008-04-08 12
+323 2008-04-08 12
+325 2008-04-08 12
+277 2008-04-08 12
+230 2008-04-08 12
+478 2008-04-08 12
+468 2008-04-08 12
+310 2008-04-08 12
+317 2008-04-08 12
+333 2008-04-08 12
+493 2008-04-08 12
+460 2008-04-08 12
+207 2008-04-08 12
+249 2008-04-08 12
+265 2008-04-08 12
+480 2008-04-08 12
+353 2008-04-08 12
+214 2008-04-08 12
+462 2008-04-08 12
+233 2008-04-08 12
+406 2008-04-08 12
+454 2008-04-08 12
+375 2008-04-08 12
+401 2008-04-08 12
+421 2008-04-08 12
+407 2008-04-08 12
+384 2008-04-08 12
+256 2008-04-08 12
+384 2008-04-08 12
+379 2008-04-08 12
+462 2008-04-08 12
+492 2008-04-08 12
+298 2008-04-08 12
+341 2008-04-08 12
+498 2008-04-08 12
+458 2008-04-08 12
+362 2008-04-08 12
+285 2008-04-08 12
+348 2008-04-08 12
+273 2008-04-08 12
+281 2008-04-08 12
+344 2008-04-08 12
+469 2008-04-08 12
+315 2008-04-08 12
+448 2008-04-08 12
+348 2008-04-08 12
+307 2008-04-08 12
+414 2008-04-08 12
+477 2008-04-08 12
+222 2008-04-08 12
+403 2008-04-08 12
+400 2008-04-08 12
+200 2008-04-08 12
Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input13.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input13.q.out?rev=712905&r1=712904&r2=712905&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input13.q.out (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input13.q.out Mon Nov 10 17:50:06 2008
@@ -13,7 +13,7 @@
Filter Operator
predicate:
expr: (key < 100)
- type: Boolean
+ type: boolean
Select Operator
expressions:
expr: key
@@ -29,7 +29,7 @@
Filter Operator
predicate:
expr: ((key >= 100) and (key < 200))
- type: Boolean
+ type: boolean
Select Operator
expressions:
expr: key
@@ -45,7 +45,7 @@
Filter Operator
predicate:
expr: ((key >= 200) and (key < 300))
- type: Boolean
+ type: boolean
Select Operator
expressions:
expr: key
@@ -59,7 +59,7 @@
Filter Operator
predicate:
expr: (key >= 300)
- type: Boolean
+ type: boolean
Select Operator
expressions:
expr: value
@@ -287,109 +287,109 @@
194 val_194
126 val_126
169 val_169
-238 NULL 2008-04-08 12
-255 NULL 2008-04-08 12
-278 NULL 2008-04-08 12
-265 NULL 2008-04-08 12
-273 NULL 2008-04-08 12
-224 NULL 2008-04-08 12
-213 NULL 2008-04-08 12
-281 NULL 2008-04-08 12
-277 NULL 2008-04-08 12
-209 NULL 2008-04-08 12
-252 NULL 2008-04-08 12
-292 NULL 2008-04-08 12
-219 NULL 2008-04-08 12
-287 NULL 2008-04-08 12
-237 NULL 2008-04-08 12
-207 NULL 2008-04-08 12
-208 NULL 2008-04-08 12
-247 NULL 2008-04-08 12
-266 NULL 2008-04-08 12
-203 NULL 2008-04-08 12
-205 NULL 2008-04-08 12
-221 NULL 2008-04-08 12
-280 NULL 2008-04-08 12
-277 NULL 2008-04-08 12
-208 NULL 2008-04-08 12
-286 NULL 2008-04-08 12
-239 NULL 2008-04-08 12
-213 NULL 2008-04-08 12
-216 NULL 2008-04-08 12
-278 NULL 2008-04-08 12
-289 NULL 2008-04-08 12
-221 NULL 2008-04-08 12
-275 NULL 2008-04-08 12
-241 NULL 2008-04-08 12
-284 NULL 2008-04-08 12
-230 NULL 2008-04-08 12
-260 NULL 2008-04-08 12
-272 NULL 2008-04-08 12
-217 NULL 2008-04-08 12
-230 NULL 2008-04-08 12
-208 NULL 2008-04-08 12
-298 NULL 2008-04-08 12
-230 NULL 2008-04-08 12
-205 NULL 2008-04-08 12
-288 NULL 2008-04-08 12
-282 NULL 2008-04-08 12
-282 NULL 2008-04-08 12
-238 NULL 2008-04-08 12
-277 NULL 2008-04-08 12
-273 NULL 2008-04-08 12
-224 NULL 2008-04-08 12
-242 NULL 2008-04-08 12
-272 NULL 2008-04-08 12
-242 NULL 2008-04-08 12
-226 NULL 2008-04-08 12
-229 NULL 2008-04-08 12
-233 NULL 2008-04-08 12
-223 NULL 2008-04-08 12
-218 NULL 2008-04-08 12
-228 NULL 2008-04-08 12
-209 NULL 2008-04-08 12
-230 NULL 2008-04-08 12
-296 NULL 2008-04-08 12
-216 NULL 2008-04-08 12
-274 NULL 2008-04-08 12
-219 NULL 2008-04-08 12
-239 NULL 2008-04-08 12
-223 NULL 2008-04-08 12
-256 NULL 2008-04-08 12
-263 NULL 2008-04-08 12
-288 NULL 2008-04-08 12
-244 NULL 2008-04-08 12
-202 NULL 2008-04-08 12
-229 NULL 2008-04-08 12
-280 NULL 2008-04-08 12
-283 NULL 2008-04-08 12
-235 NULL 2008-04-08 12
-257 NULL 2008-04-08 12
-258 NULL 2008-04-08 12
-203 NULL 2008-04-08 12
-262 NULL 2008-04-08 12
-201 NULL 2008-04-08 12
-217 NULL 2008-04-08 12
-298 NULL 2008-04-08 12
-291 NULL 2008-04-08 12
-255 NULL 2008-04-08 12
-200 NULL 2008-04-08 12
-237 NULL 2008-04-08 12
-248 NULL 2008-04-08 12
-277 NULL 2008-04-08 12
-230 NULL 2008-04-08 12
-207 NULL 2008-04-08 12
-249 NULL 2008-04-08 12
-265 NULL 2008-04-08 12
-214 NULL 2008-04-08 12
-233 NULL 2008-04-08 12
-256 NULL 2008-04-08 12
-298 NULL 2008-04-08 12
-285 NULL 2008-04-08 12
-273 NULL 2008-04-08 12
-281 NULL 2008-04-08 12
-222 NULL 2008-04-08 12
-200 NULL 2008-04-08 12
+238 2008-04-08 12
+255 2008-04-08 12
+278 2008-04-08 12
+265 2008-04-08 12
+273 2008-04-08 12
+224 2008-04-08 12
+213 2008-04-08 12
+281 2008-04-08 12
+277 2008-04-08 12
+209 2008-04-08 12
+252 2008-04-08 12
+292 2008-04-08 12
+219 2008-04-08 12
+287 2008-04-08 12
+237 2008-04-08 12
+207 2008-04-08 12
+208 2008-04-08 12
+247 2008-04-08 12
+266 2008-04-08 12
+203 2008-04-08 12
+205 2008-04-08 12
+221 2008-04-08 12
+280 2008-04-08 12
+277 2008-04-08 12
+208 2008-04-08 12
+286 2008-04-08 12
+239 2008-04-08 12
+213 2008-04-08 12
+216 2008-04-08 12
+278 2008-04-08 12
+289 2008-04-08 12
+221 2008-04-08 12
+275 2008-04-08 12
+241 2008-04-08 12
+284 2008-04-08 12
+230 2008-04-08 12
+260 2008-04-08 12
+272 2008-04-08 12
+217 2008-04-08 12
+230 2008-04-08 12
+208 2008-04-08 12
+298 2008-04-08 12
+230 2008-04-08 12
+205 2008-04-08 12
+288 2008-04-08 12
+282 2008-04-08 12
+282 2008-04-08 12
+238 2008-04-08 12
+277 2008-04-08 12
+273 2008-04-08 12
+224 2008-04-08 12
+242 2008-04-08 12
+272 2008-04-08 12
+242 2008-04-08 12
+226 2008-04-08 12
+229 2008-04-08 12
+233 2008-04-08 12
+223 2008-04-08 12
+218 2008-04-08 12
+228 2008-04-08 12
+209 2008-04-08 12
+230 2008-04-08 12
+296 2008-04-08 12
+216 2008-04-08 12
+274 2008-04-08 12
+219 2008-04-08 12
+239 2008-04-08 12
+223 2008-04-08 12
+256 2008-04-08 12
+263 2008-04-08 12
+288 2008-04-08 12
+244 2008-04-08 12
+202 2008-04-08 12
+229 2008-04-08 12
+280 2008-04-08 12
+283 2008-04-08 12
+235 2008-04-08 12
+257 2008-04-08 12
+258 2008-04-08 12
+203 2008-04-08 12
+262 2008-04-08 12
+201 2008-04-08 12
+217 2008-04-08 12
+298 2008-04-08 12
+291 2008-04-08 12
+255 2008-04-08 12
+200 2008-04-08 12
+237 2008-04-08 12
+248 2008-04-08 12
+277 2008-04-08 12
+230 2008-04-08 12
+207 2008-04-08 12
+249 2008-04-08 12
+265 2008-04-08 12
+214 2008-04-08 12
+233 2008-04-08 12
+256 2008-04-08 12
+298 2008-04-08 12
+285 2008-04-08 12
+273 2008-04-08 12
+281 2008-04-08 12
+222 2008-04-08 12
+200 2008-04-08 12
val_311
val_409
val_484
Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input14.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input14.q.out?rev=712905&r1=712904&r2=712905&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input14.q.out (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input14.q.out Mon Nov 10 17:50:06 2008
@@ -1,5 +1,5 @@
ABSTRACT SYNTAX TREE:
- (TOK_QUERY (TOK_FROM (TOK_SUBQUERY (TOK_QUERY (TOK_FROM (TOK_TABREF src)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_TRANSFORM (TOK_COLLIST (TOK_COLREF src key) (TOK_COLREF src value)) (TOK_ALIASLIST tkey tvalue) '/bin/cat'))) (TOK_CLUSTERBY tkey))) tmap)) (TOK_INSERT (TOK_DESTINATION (TOK_TAB dest1)) (TOK_SELECT (TOK_SELEXPR (TOK_COLREF tmap tkey)) (TOK_SELEXPR (TOK_COLREF tmap tvalue))) (TOK_WHERE (< (TOK_COLREF tmap tkey) 100))))
+ (TOK_QUERY (TOK_FROM (TOK_SUBQUERY (TOK_QUERY (TOK_FROM (TOK_TABREF src)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_TRANSFORM (TOK_EXPLIST (TOK_COLREF src key) (TOK_COLREF src value)) '/bin/cat' (TOK_ALIASLIST tkey tvalue)))) (TOK_CLUSTERBY tkey))) tmap)) (TOK_INSERT (TOK_DESTINATION (TOK_TAB dest1)) (TOK_SELECT (TOK_SELEXPR (TOK_COLREF tmap tkey)) (TOK_SELEXPR (TOK_COLREF tmap tvalue))) (TOK_WHERE (< (TOK_COLREF tmap tkey) 100))))
STAGE DEPENDENCIES:
Stage-1 is a root stage
@@ -25,7 +25,9 @@
key expressions:
expr: tkey
type: string
- # partition fields: 1
+ Map-reduce partition columns:
+ expr: tkey
+ type: string
tag: -1
value expressions:
expr: tkey
@@ -37,7 +39,7 @@
Filter Operator
predicate:
expr: (0 < 100)
- type: Boolean
+ type: boolean
Select Operator
expressions:
expr: 0
Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input14_limit.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input14_limit.q.out?rev=712905&r1=712904&r2=712905&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input14_limit.q.out (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input14_limit.q.out Mon Nov 10 17:50:06 2008
@@ -1,5 +1,5 @@
ABSTRACT SYNTAX TREE:
- (TOK_QUERY (TOK_FROM (TOK_SUBQUERY (TOK_QUERY (TOK_FROM (TOK_TABREF src)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_TRANSFORM (TOK_COLLIST (TOK_COLREF src key) (TOK_COLREF src value)) (TOK_ALIASLIST tkey tvalue) '/bin/cat'))) (TOK_CLUSTERBY tkey) (TOK_LIMIT 20))) tmap)) (TOK_INSERT (TOK_DESTINATION (TOK_TAB dest1)) (TOK_SELECT (TOK_SELEXPR (TOK_COLREF tmap tkey)) (TOK_SELEXPR (TOK_COLREF tmap tvalue))) (TOK_WHERE (< (TOK_COLREF tmap tkey) 100))))
+ (TOK_QUERY (TOK_FROM (TOK_SUBQUERY (TOK_QUERY (TOK_FROM (TOK_TABREF src)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_TRANSFORM (TOK_EXPLIST (TOK_COLREF src key) (TOK_COLREF src value)) '/bin/cat' (TOK_ALIASLIST tkey tvalue)))) (TOK_CLUSTERBY tkey) (TOK_LIMIT 20))) tmap)) (TOK_INSERT (TOK_DESTINATION (TOK_TAB dest1)) (TOK_SELECT (TOK_SELEXPR (TOK_COLREF tmap tkey)) (TOK_SELEXPR (TOK_COLREF tmap tvalue))) (TOK_WHERE (< (TOK_COLREF tmap tkey) 100))))
STAGE DEPENDENCIES:
Stage-1 is a root stage
@@ -26,7 +26,9 @@
key expressions:
expr: tkey
type: string
- # partition fields: 1
+ Map-reduce partition columns:
+ expr: tkey
+ type: string
tag: -1
value expressions:
expr: tkey
@@ -38,18 +40,21 @@
Limit
File Output Operator
table:
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ input format: org.apache.hadoop.mapred.SequenceFileInputFormat
+ output format: org.apache.hadoop.mapred.SequenceFileOutputFormat
+ name: binary_table
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- /tmp/hive-njain/945772770/1814909502.10001
+ /tmp/hive-njain/195632265/461794176.10001
Reduce Output Operator
key expressions:
expr: 0
type: string
- # partition fields: 1
+ Map-reduce partition columns:
+ expr: 0
+ type: string
tag: -1
value expressions:
expr: 0
@@ -63,7 +68,7 @@
Filter Operator
predicate:
expr: (0 < 100)
- type: Boolean
+ type: boolean
Select Operator
expressions:
expr: 0
Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input15.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input15.q.out?rev=712905&r1=712904&r2=712905&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input15.q.out (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input15.q.out Mon Nov 10 17:50:06 2008
@@ -1,5 +1,5 @@
ABSTRACT SYNTAX TREE:
- (TOK_CREATETABLE TEST15 (TOK_TABCOLLIST (TOK_TABCOL key TOK_INT) (TOK_TABCOL value TOK_STRING)) (TOK_TABLEROWFORMAT (TOK_TABLEROWFORMATFIELD '\t')))
+ (TOK_CREATETABLE TEST15 (TOK_TABCOLLIST (TOK_TABCOL key TOK_INT) (TOK_TABCOL value TOK_STRING)) (TOK_TABLEROWFORMAT (TOK_TABLEROWFORMATFIELD '\t')) TOK_TBLTEXTFILE)
STAGE DEPENDENCIES:
Stage-0 is a root stage
Added: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input17.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input17.q.out?rev=712905&view=auto
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input17.q.out (added)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input17.q.out Mon Nov 10 17:50:06 2008
@@ -0,0 +1,80 @@
+ABSTRACT SYNTAX TREE:
+ (TOK_QUERY (TOK_FROM (TOK_SUBQUERY (TOK_QUERY (TOK_FROM (TOK_TABREF src_thrift)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_TRANSFORM (TOK_EXPLIST (+ (TOK_COLREF src_thrift aint) ([ (TOK_COLREF src_thrift lint) 0)) ([ (TOK_COLREF src_thrift lintstring) 0)) '/bin/cat' (TOK_ALIASLIST tkey tvalue)))) (TOK_CLUSTERBY tkey))) tmap)) (TOK_INSERT (TOK_DESTINATION (TOK_TAB dest1)) (TOK_SELECT (TOK_SELEXPR (TOK_COLREF tmap tkey)) (TOK_SELEXPR (TOK_COLREF tmap tvalue)))))
+
+STAGE DEPENDENCIES:
+ Stage-1 is a root stage
+ Stage-0 depends on stages: Stage-1
+
+STAGE PLANS:
+ Stage: Stage-1
+ Map Reduce
+ Alias -> Map Operator Tree:
+ tmap:src_thrift
+ Select Operator
+ expressions:
+ expr: aint
+ type: int
+ expr: lint
+ type: array<int>
+ expr: lintstring
+ type: array<struct{myint:int,mystring:string}>
+ Select Operator
+ expressions:
+ expr: (0 + 1[0])
+ type: int
+ expr: 2[0]
+ type: struct{myint:int,mystring:string}
+ Transform Operator
+ command: /bin/cat
+ output info:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ Reduce Output Operator
+ key expressions:
+ expr: tkey
+ type: string
+ Map-reduce partition columns:
+ expr: tkey
+ type: string
+ tag: -1
+ value expressions:
+ expr: tkey
+ type: string
+ expr: tvalue
+ type: string
+ Reduce Operator Tree:
+ Extract
+ Select Operator
+ expressions:
+ expr: 0
+ type: string
+ expr: 1
+ type: string
+ File Output Operator
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+ name: dest1
+
+ Stage: Stage-0
+ Move Operator
+ tables:
+ replace:
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+ name: dest1
+
+
+-1103622755 {"myint":64,"mystring":"512"}
+-1147582749 {"myint":1,"mystring":"1"}
+-1220068486 {"myint":0,"mystring":"0"}
+-1281615204 {"myint":36,"mystring":"216"}
+-1587372270 {"myint":9,"mystring":"27"}
+-1883609158 {"myint":81,"mystring":"729"}
+-2091002568 {"myint":4,"mystring":"8"}
+-240543261 {"myint":16,"mystring":"64"}
+1539139271 {"myint":49,"mystring":"343"}
+1914724542 {"myint":25,"mystring":"125"}
Added: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input18.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input18.q.out?rev=712905&view=auto
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input18.q.out (added)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input18.q.out Mon Nov 10 17:50:06 2008
@@ -0,0 +1,154 @@
+ABSTRACT SYNTAX TREE:
+ (TOK_QUERY (TOK_FROM (TOK_SUBQUERY (TOK_QUERY (TOK_FROM (TOK_TABREF src)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_TRANSFORM (TOK_EXPLIST (TOK_COLREF src key) (TOK_COLREF src value) (+ 1 2) (+ 3 4)) '/bin/cat'))) (TOK_CLUSTERBY key))) tmap)) (TOK_INSERT (TOK_DESTINATION (TOK_TAB dest1)) (TOK_SELECT (TOK_SELEXPR (TOK_COLREF tmap key)) (TOK_SELEXPR (TOK_FUNCTION regexp_replace (TOK_COLREF tmap value) '\t' '+'))) (TOK_WHERE (< (TOK_COLREF tmap key) 100))))
+
+STAGE DEPENDENCIES:
+ Stage-1 is a root stage
+ Stage-0 depends on stages: Stage-1
+
+STAGE PLANS:
+ Stage: Stage-1
+ Map Reduce
+ Alias -> Map Operator Tree:
+ tmap:src
+ Select Operator
+ expressions:
+ expr: key
+ type: string
+ expr: value
+ type: string
+ expr: (1 + 2)
+ type: int
+ expr: (3 + 4)
+ type: int
+ Transform Operator
+ command: /bin/cat
+ output info:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ Reduce Output Operator
+ key expressions:
+ expr: key
+ type: string
+ Map-reduce partition columns:
+ expr: key
+ type: string
+ tag: -1
+ value expressions:
+ expr: key
+ type: string
+ expr: value
+ type: string
+ Reduce Operator Tree:
+ Extract
+ Filter Operator
+ predicate:
+ expr: (0 < 100)
+ type: boolean
+ Select Operator
+ expressions:
+ expr: 0
+ type: string
+ expr: regexp_replace(1, ' ', '+')
+ type: string
+ File Output Operator
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+ name: dest1
+
+ Stage: Stage-0
+ Move Operator
+ tables:
+ replace:
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+ name: dest1
+
+
+0 val_0+3+7
+0 val_0+3+7
+0 val_0+3+7
+10 val_10+3+7
+11 val_11+3+7
+12 val_12+3+7
+12 val_12+3+7
+15 val_15+3+7
+15 val_15+3+7
+17 val_17+3+7
+18 val_18+3+7
+18 val_18+3+7
+19 val_19+3+7
+2 val_2+3+7
+20 val_20+3+7
+24 val_24+3+7
+24 val_24+3+7
+26 val_26+3+7
+26 val_26+3+7
+27 val_27+3+7
+28 val_28+3+7
+30 val_30+3+7
+33 val_33+3+7
+34 val_34+3+7
+35 val_35+3+7
+35 val_35+3+7
+35 val_35+3+7
+37 val_37+3+7
+37 val_37+3+7
+4 val_4+3+7
+41 val_41+3+7
+42 val_42+3+7
+42 val_42+3+7
+43 val_43+3+7
+44 val_44+3+7
+47 val_47+3+7
+5 val_5+3+7
+5 val_5+3+7
+5 val_5+3+7
+51 val_51+3+7
+51 val_51+3+7
+53 val_53+3+7
+54 val_54+3+7
+57 val_57+3+7
+58 val_58+3+7
+58 val_58+3+7
+64 val_64+3+7
+65 val_65+3+7
+66 val_66+3+7
+67 val_67+3+7
+67 val_67+3+7
+69 val_69+3+7
+70 val_70+3+7
+70 val_70+3+7
+70 val_70+3+7
+72 val_72+3+7
+72 val_72+3+7
+74 val_74+3+7
+76 val_76+3+7
+76 val_76+3+7
+77 val_77+3+7
+78 val_78+3+7
+8 val_8+3+7
+80 val_80+3+7
+82 val_82+3+7
+83 val_83+3+7
+83 val_83+3+7
+84 val_84+3+7
+84 val_84+3+7
+85 val_85+3+7
+86 val_86+3+7
+87 val_87+3+7
+9 val_9+3+7
+90 val_90+3+7
+90 val_90+3+7
+90 val_90+3+7
+92 val_92+3+7
+95 val_95+3+7
+95 val_95+3+7
+96 val_96+3+7
+97 val_97+3+7
+97 val_97+3+7
+98 val_98+3+7
+98 val_98+3+7
Added: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input19.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input19.q.out?rev=712905&view=auto
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input19.q.out (added)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input19.q.out Mon Nov 10 17:50:06 2008
@@ -0,0 +1 @@
+127.0.0.1 frank 10/Oct/2000:13:55:36 -0700 GET /apache_pb.gif HTTP/1.0 200 2326
Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input1_limit.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input1_limit.q.out?rev=712905&r1=712904&r2=712905&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input1_limit.q.out (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input1_limit.q.out Mon Nov 10 17:50:06 2008
@@ -13,7 +13,7 @@
Filter Operator
predicate:
expr: (key < 100)
- type: Boolean
+ type: boolean
Select Operator
expressions:
expr: key
@@ -30,7 +30,7 @@
Filter Operator
predicate:
expr: (key < 100)
- type: Boolean
+ type: boolean
Select Operator
expressions:
expr: key
Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input2_limit.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input2_limit.q.out?rev=712905&r1=712904&r2=712905&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input2_limit.q.out (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input2_limit.q.out Mon Nov 10 17:50:06 2008
@@ -13,7 +13,7 @@
Filter Operator
predicate:
expr: (key < 300)
- type: Boolean
+ type: boolean
Select Operator
expressions:
expr: key
Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input3.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input3.q.out?rev=712905&r1=712904&r2=712905&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input3.q.out (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input3.q.out Mon Nov 10 17:50:06 2008
@@ -61,4 +61,4 @@
r1 int
r2 float
Detailed Table Information:
-Table(tableName:test3c,dbName:default,owner:njain,createTime:1224285029,lastAccessTime:0,retention:0,sd:StorageDescriptor(cols:[FieldSchema(name:r1,type:int,comment:null), FieldSchema(name:r2,type:float,comment:null)],location:file:/home/njain/workspace/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/test3b,inputFormat:org.apache.hadoop.mapred.TextInputFormat,outputFormat:org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat,compressed:false,numBuckets:-1,serdeInfo:SerDeInfo(name:null,serializationLib:org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe,parameters:{serialization.format=1}),bucketCols:[],sortCols:[],parameters:{}),partitionKeys:[],parameters:{last_modified_by=njain,last_modified_time=1224285029,SORTBUCKETCOLSPREFIX=TRUE})
+Table(tableName:test3c,dbName:default,owner:njain,createTime:1225993819,lastAccessTime:0,retention:0,sd:StorageDescriptor(cols:[FieldSchema(name:r1,type:int,comment:null), FieldSchema(name:r2,type:float,comment:null)],location:file:/home/njain/workspace/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/test3b,inputFormat:org.apache.hadoop.mapred.TextInputFormat,outputFormat:org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat,compressed:false,numBuckets:-1,serdeInfo:SerDeInfo(name:null,serializationLib:org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe,parameters:{serialization.format=1}),bucketCols:[],sortCols:[],parameters:{}),partitionKeys:[],parameters:{last_modified_by=njain,last_modified_time=1225993820})
Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input4.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input4.q.out?rev=712905&r1=712904&r2=712905&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input4.q.out (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input4.q.out Mon Nov 10 17:50:06 2008
@@ -9,7 +9,7 @@
Stage: Stage-0
Copy
source: file:/home/njain/workspace/hadoop-0.17/src/contrib/hive/data/files/kv1.txt
- destination: file:/tmp/hive-njain/-478939701
+ destination: file:/tmp/hive-njain/-1533162426
Stage: Stage-1
Move Operator
Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input5.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input5.q.out?rev=712905&r1=712904&r2=712905&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input5.q.out (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input5.q.out Mon Nov 10 17:50:06 2008
@@ -1,5 +1,5 @@
ABSTRACT SYNTAX TREE:
- (TOK_QUERY (TOK_FROM (TOK_SUBQUERY (TOK_QUERY (TOK_FROM (TOK_TABREF src_thrift)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_TRANSFORM (TOK_COLLIST (TOK_COLREF src_thrift lint) (TOK_COLREF src_thrift lintstring)) (TOK_ALIASLIST tkey tvalue) '/bin/cat'))) (TOK_CLUSTERBY tkey))) tmap)) (TOK_INSERT (TOK_DESTINATION (TOK_TAB dest1)) (TOK_SELECT (TOK_SELEXPR (TOK_COLREF tmap tkey)) (TOK_SELEXPR (TOK_COLREF tmap tvalue)))))
+ (TOK_QUERY (TOK_FROM (TOK_SUBQUERY (TOK_QUERY (TOK_FROM (TOK_TABREF src_thrift)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_TRANSFORM (TOK_EXPLIST (TOK_COLREF src_thrift lint) (TOK_COLREF src_thrift lintstring)) '/bin/cat' (TOK_ALIASLIST tkey tvalue)))) (TOK_CLUSTERBY tkey))) tmap)) (TOK_INSERT (TOK_DESTINATION (TOK_TAB dest1)) (TOK_SELECT (TOK_SELEXPR (TOK_COLREF tmap tkey)) (TOK_SELEXPR (TOK_COLREF tmap tvalue)))))
STAGE DEPENDENCIES:
Stage-1 is a root stage
@@ -16,22 +16,30 @@
type: array<int>
expr: lintstring
type: array<struct{myint:int,mystring:string}>
- Transform Operator
- command: /bin/cat
- output info:
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
- Reduce Output Operator
- key expressions:
- expr: tkey
- type: string
- # partition fields: 1
- tag: -1
- value expressions:
- expr: tkey
- type: string
- expr: tvalue
- type: string
+ Select Operator
+ expressions:
+ expr: 0
+ type: array<int>
+ expr: 1
+ type: array<struct{myint:int,mystring:string}>
+ Transform Operator
+ command: /bin/cat
+ output info:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ Reduce Output Operator
+ key expressions:
+ expr: tkey
+ type: string
+ Map-reduce partition columns:
+ expr: tkey
+ type: string
+ tag: -1
+ value expressions:
+ expr: tkey
+ type: string
+ expr: tvalue
+ type: string
Reduce Operator Tree:
Extract
Select Operator
Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input6.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input6.q.out?rev=712905&r1=712904&r2=712905&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input6.q.out (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input6.q.out Mon Nov 10 17:50:06 2008
@@ -13,7 +13,7 @@
Filter Operator
predicate:
expr: key is null
- type: Boolean
+ type: boolean
Select Operator
expressions:
expr: key
Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input7.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input7.q.out?rev=712905&r1=712904&r2=712905&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input7.q.out (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input7.q.out Mon Nov 10 17:50:06 2008
@@ -12,16 +12,20 @@
src1
Select Operator
expressions:
- expr: null
- type: string
expr: key
type: string
- File Output Operator
- table:
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
- serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
- name: dest1
+ Select Operator
+ expressions:
+ expr: null
+ type: string
+ expr: 0
+ type: string
+ File Output Operator
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+ name: dest1
Stage: Stage-0
Move Operator
Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input8.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input8.q.out?rev=712905&r1=712904&r2=712905&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input8.q.out (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input8.q.out Mon Nov 10 17:50:06 2008
@@ -12,18 +12,22 @@
src1
Select Operator
expressions:
- expr: (4 + null)
- type: int
- expr: (UDFToDouble(key) - null)
- type: double
- expr: (null + null)
- type: Byte
- File Output Operator
- table:
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
- serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
- name: dest1
+ expr: key
+ type: string
+ Select Operator
+ expressions:
+ expr: (4 + null)
+ type: int
+ expr: (UDFToDouble(0) - null)
+ type: double
+ expr: (null + null)
+ type: tinyint
+ File Output Operator
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+ name: dest1
Stage: Stage-0
Move Operator
Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input9.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input9.q.out?rev=712905&r1=712904&r2=712905&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input9.q.out (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input9.q.out Mon Nov 10 17:50:06 2008
@@ -10,22 +10,26 @@
Map Reduce
Alias -> Map Operator Tree:
src1
- Filter Operator
- predicate:
- expr: (null = null)
- type: Boolean
- Select Operator
- expressions:
- expr: null
- type: string
- expr: key
- type: string
- File Output Operator
- table:
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
- serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
- name: dest1
+ Select Operator
+ expressions:
+ expr: key
+ type: string
+ Filter Operator
+ predicate:
+ expr: (null = null)
+ type: boolean
+ Select Operator
+ expressions:
+ expr: null
+ type: string
+ expr: 0
+ type: string
+ File Output Operator
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+ name: dest1
Stage: Stage-0
Move Operator
Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input_dynamicserde.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input_dynamicserde.q.out?rev=712905&r1=712904&r2=712905&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input_dynamicserde.q.out (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input_dynamicserde.q.out Mon Nov 10 17:50:06 2008
@@ -22,12 +22,24 @@
type: int
expr: astring
type: string
- File Output Operator
- table:
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
- serde: org.apache.hadoop.hive.serde2.dynamic_type.DynamicSerDe
- name: dest1
+ Select Operator
+ expressions:
+ expr: 0
+ type: array<int>
+ expr: 1
+ type: array<string>
+ expr: 2
+ type: map<string,string>
+ expr: 3
+ type: int
+ expr: 4
+ type: string
+ File Output Operator
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.dynamic_type.DynamicSerDe
+ name: dest1
Stage: Stage-0
Move Operator
@@ -50,3 +62,13 @@
[7,14,21] ["70","700","7000"] {"key_7":"value_7"} 1539139264 record_7
[8,16,24] ["80","800","8000"] {"key_8":"value_8"} -1103622763 record_8
[9,18,27] ["90","900","9000"] {"key_9":"value_9"} -1883609167 record_9
+0 0 NULL -1220068486 record_0
+1 10 NULL -1147582750 record_1
+2 20 NULL -2091002570 record_2
+3 30 NULL -1587372273 record_3
+4 40 NULL -240543265 record_4
+5 50 NULL 1914724537 record_5
+6 60 NULL -1281615210 record_6
+7 70 NULL 1539139264 record_7
+8 80 NULL -1103622763 record_8
+9 90 NULL -1883609167 record_9
Added: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input_part0.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input_part0.q.out?rev=712905&view=auto
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input_part0.q.out (added)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input_part0.q.out Mon Nov 10 17:50:06 2008
@@ -0,0 +1,1012 @@
+ABSTRACT SYNTAX TREE:
+ (TOK_QUERY (TOK_FROM (TOK_TABREF SRCPART x)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_ALLCOLREF x))) (TOK_WHERE (= (TOK_COLREF x ds) '2008-04-08'))))
+
+STAGE DEPENDENCIES:
+ Stage-0 is a root stage
+
+STAGE PLANS:
+ Stage: Stage-0
+ Fetch Operator
+ limit: -1
+
+
+238 val_238 2008-04-08 11
+86 val_86 2008-04-08 11
+311 val_311 2008-04-08 11
+27 val_27 2008-04-08 11
+165 val_165 2008-04-08 11
+409 val_409 2008-04-08 11
+255 val_255 2008-04-08 11
+278 val_278 2008-04-08 11
+98 val_98 2008-04-08 11
+484 val_484 2008-04-08 11
+265 val_265 2008-04-08 11
+193 val_193 2008-04-08 11
+401 val_401 2008-04-08 11
+150 val_150 2008-04-08 11
+273 val_273 2008-04-08 11
+224 val_224 2008-04-08 11
+369 val_369 2008-04-08 11
+66 val_66 2008-04-08 11
+128 val_128 2008-04-08 11
+213 val_213 2008-04-08 11
+146 val_146 2008-04-08 11
+406 val_406 2008-04-08 11
+429 val_429 2008-04-08 11
+374 val_374 2008-04-08 11
+152 val_152 2008-04-08 11
+469 val_469 2008-04-08 11
+145 val_145 2008-04-08 11
+495 val_495 2008-04-08 11
+37 val_37 2008-04-08 11
+327 val_327 2008-04-08 11
+281 val_281 2008-04-08 11
+277 val_277 2008-04-08 11
+209 val_209 2008-04-08 11
+15 val_15 2008-04-08 11
+82 val_82 2008-04-08 11
+403 val_403 2008-04-08 11
+166 val_166 2008-04-08 11
+417 val_417 2008-04-08 11
+430 val_430 2008-04-08 11
+252 val_252 2008-04-08 11
+292 val_292 2008-04-08 11
+219 val_219 2008-04-08 11
+287 val_287 2008-04-08 11
+153 val_153 2008-04-08 11
+193 val_193 2008-04-08 11
+338 val_338 2008-04-08 11
+446 val_446 2008-04-08 11
+459 val_459 2008-04-08 11
+394 val_394 2008-04-08 11
+237 val_237 2008-04-08 11
+482 val_482 2008-04-08 11
+174 val_174 2008-04-08 11
+413 val_413 2008-04-08 11
+494 val_494 2008-04-08 11
+207 val_207 2008-04-08 11
+199 val_199 2008-04-08 11
+466 val_466 2008-04-08 11
+208 val_208 2008-04-08 11
+174 val_174 2008-04-08 11
+399 val_399 2008-04-08 11
+396 val_396 2008-04-08 11
+247 val_247 2008-04-08 11
+417 val_417 2008-04-08 11
+489 val_489 2008-04-08 11
+162 val_162 2008-04-08 11
+377 val_377 2008-04-08 11
+397 val_397 2008-04-08 11
+309 val_309 2008-04-08 11
+365 val_365 2008-04-08 11
+266 val_266 2008-04-08 11
+439 val_439 2008-04-08 11
+342 val_342 2008-04-08 11
+367 val_367 2008-04-08 11
+325 val_325 2008-04-08 11
+167 val_167 2008-04-08 11
+195 val_195 2008-04-08 11
+475 val_475 2008-04-08 11
+17 val_17 2008-04-08 11
+113 val_113 2008-04-08 11
+155 val_155 2008-04-08 11
+203 val_203 2008-04-08 11
+339 val_339 2008-04-08 11
+0 val_0 2008-04-08 11
+455 val_455 2008-04-08 11
+128 val_128 2008-04-08 11
+311 val_311 2008-04-08 11
+316 val_316 2008-04-08 11
+57 val_57 2008-04-08 11
+302 val_302 2008-04-08 11
+205 val_205 2008-04-08 11
+149 val_149 2008-04-08 11
+438 val_438 2008-04-08 11
+345 val_345 2008-04-08 11
+129 val_129 2008-04-08 11
+170 val_170 2008-04-08 11
+20 val_20 2008-04-08 11
+489 val_489 2008-04-08 11
+157 val_157 2008-04-08 11
+378 val_378 2008-04-08 11
+221 val_221 2008-04-08 11
+92 val_92 2008-04-08 11
+111 val_111 2008-04-08 11
+47 val_47 2008-04-08 11
+72 val_72 2008-04-08 11
+4 val_4 2008-04-08 11
+280 val_280 2008-04-08 11
+35 val_35 2008-04-08 11
+427 val_427 2008-04-08 11
+277 val_277 2008-04-08 11
+208 val_208 2008-04-08 11
+356 val_356 2008-04-08 11
+399 val_399 2008-04-08 11
+169 val_169 2008-04-08 11
+382 val_382 2008-04-08 11
+498 val_498 2008-04-08 11
+125 val_125 2008-04-08 11
+386 val_386 2008-04-08 11
+437 val_437 2008-04-08 11
+469 val_469 2008-04-08 11
+192 val_192 2008-04-08 11
+286 val_286 2008-04-08 11
+187 val_187 2008-04-08 11
+176 val_176 2008-04-08 11
+54 val_54 2008-04-08 11
+459 val_459 2008-04-08 11
+51 val_51 2008-04-08 11
+138 val_138 2008-04-08 11
+103 val_103 2008-04-08 11
+239 val_239 2008-04-08 11
+213 val_213 2008-04-08 11
+216 val_216 2008-04-08 11
+430 val_430 2008-04-08 11
+278 val_278 2008-04-08 11
+176 val_176 2008-04-08 11
+289 val_289 2008-04-08 11
+221 val_221 2008-04-08 11
+65 val_65 2008-04-08 11
+318 val_318 2008-04-08 11
+332 val_332 2008-04-08 11
+311 val_311 2008-04-08 11
+275 val_275 2008-04-08 11
+137 val_137 2008-04-08 11
+241 val_241 2008-04-08 11
+83 val_83 2008-04-08 11
+333 val_333 2008-04-08 11
+180 val_180 2008-04-08 11
+284 val_284 2008-04-08 11
+12 val_12 2008-04-08 11
+230 val_230 2008-04-08 11
+181 val_181 2008-04-08 11
+67 val_67 2008-04-08 11
+260 val_260 2008-04-08 11
+404 val_404 2008-04-08 11
+384 val_384 2008-04-08 11
+489 val_489 2008-04-08 11
+353 val_353 2008-04-08 11
+373 val_373 2008-04-08 11
+272 val_272 2008-04-08 11
+138 val_138 2008-04-08 11
+217 val_217 2008-04-08 11
+84 val_84 2008-04-08 11
+348 val_348 2008-04-08 11
+466 val_466 2008-04-08 11
+58 val_58 2008-04-08 11
+8 val_8 2008-04-08 11
+411 val_411 2008-04-08 11
+230 val_230 2008-04-08 11
+208 val_208 2008-04-08 11
+348 val_348 2008-04-08 11
+24 val_24 2008-04-08 11
+463 val_463 2008-04-08 11
+431 val_431 2008-04-08 11
+179 val_179 2008-04-08 11
+172 val_172 2008-04-08 11
+42 val_42 2008-04-08 11
+129 val_129 2008-04-08 11
+158 val_158 2008-04-08 11
+119 val_119 2008-04-08 11
+496 val_496 2008-04-08 11
+0 val_0 2008-04-08 11
+322 val_322 2008-04-08 11
+197 val_197 2008-04-08 11
+468 val_468 2008-04-08 11
+393 val_393 2008-04-08 11
+454 val_454 2008-04-08 11
+100 val_100 2008-04-08 11
+298 val_298 2008-04-08 11
+199 val_199 2008-04-08 11
+191 val_191 2008-04-08 11
+418 val_418 2008-04-08 11
+96 val_96 2008-04-08 11
+26 val_26 2008-04-08 11
+165 val_165 2008-04-08 11
+327 val_327 2008-04-08 11
+230 val_230 2008-04-08 11
+205 val_205 2008-04-08 11
+120 val_120 2008-04-08 11
+131 val_131 2008-04-08 11
+51 val_51 2008-04-08 11
+404 val_404 2008-04-08 11
+43 val_43 2008-04-08 11
+436 val_436 2008-04-08 11
+156 val_156 2008-04-08 11
+469 val_469 2008-04-08 11
+468 val_468 2008-04-08 11
+308 val_308 2008-04-08 11
+95 val_95 2008-04-08 11
+196 val_196 2008-04-08 11
+288 val_288 2008-04-08 11
+481 val_481 2008-04-08 11
+457 val_457 2008-04-08 11
+98 val_98 2008-04-08 11
+282 val_282 2008-04-08 11
+197 val_197 2008-04-08 11
+187 val_187 2008-04-08 11
+318 val_318 2008-04-08 11
+318 val_318 2008-04-08 11
+409 val_409 2008-04-08 11
+470 val_470 2008-04-08 11
+137 val_137 2008-04-08 11
+369 val_369 2008-04-08 11
+316 val_316 2008-04-08 11
+169 val_169 2008-04-08 11
+413 val_413 2008-04-08 11
+85 val_85 2008-04-08 11
+77 val_77 2008-04-08 11
+0 val_0 2008-04-08 11
+490 val_490 2008-04-08 11
+87 val_87 2008-04-08 11
+364 val_364 2008-04-08 11
+179 val_179 2008-04-08 11
+118 val_118 2008-04-08 11
+134 val_134 2008-04-08 11
+395 val_395 2008-04-08 11
+282 val_282 2008-04-08 11
+138 val_138 2008-04-08 11
+238 val_238 2008-04-08 11
+419 val_419 2008-04-08 11
+15 val_15 2008-04-08 11
+118 val_118 2008-04-08 11
+72 val_72 2008-04-08 11
+90 val_90 2008-04-08 11
+307 val_307 2008-04-08 11
+19 val_19 2008-04-08 11
+435 val_435 2008-04-08 11
+10 val_10 2008-04-08 11
+277 val_277 2008-04-08 11
+273 val_273 2008-04-08 11
+306 val_306 2008-04-08 11
+224 val_224 2008-04-08 11
+309 val_309 2008-04-08 11
+389 val_389 2008-04-08 11
+327 val_327 2008-04-08 11
+242 val_242 2008-04-08 11
+369 val_369 2008-04-08 11
+392 val_392 2008-04-08 11
+272 val_272 2008-04-08 11
+331 val_331 2008-04-08 11
+401 val_401 2008-04-08 11
+242 val_242 2008-04-08 11
+452 val_452 2008-04-08 11
+177 val_177 2008-04-08 11
+226 val_226 2008-04-08 11
+5 val_5 2008-04-08 11
+497 val_497 2008-04-08 11
+402 val_402 2008-04-08 11
+396 val_396 2008-04-08 11
+317 val_317 2008-04-08 11
+395 val_395 2008-04-08 11
+58 val_58 2008-04-08 11
+35 val_35 2008-04-08 11
+336 val_336 2008-04-08 11
+95 val_95 2008-04-08 11
+11 val_11 2008-04-08 11
+168 val_168 2008-04-08 11
+34 val_34 2008-04-08 11
+229 val_229 2008-04-08 11
+233 val_233 2008-04-08 11
+143 val_143 2008-04-08 11
+472 val_472 2008-04-08 11
+322 val_322 2008-04-08 11
+498 val_498 2008-04-08 11
+160 val_160 2008-04-08 11
+195 val_195 2008-04-08 11
+42 val_42 2008-04-08 11
+321 val_321 2008-04-08 11
+430 val_430 2008-04-08 11
+119 val_119 2008-04-08 11
+489 val_489 2008-04-08 11
+458 val_458 2008-04-08 11
+78 val_78 2008-04-08 11
+76 val_76 2008-04-08 11
+41 val_41 2008-04-08 11
+223 val_223 2008-04-08 11
+492 val_492 2008-04-08 11
+149 val_149 2008-04-08 11
+449 val_449 2008-04-08 11
+218 val_218 2008-04-08 11
+228 val_228 2008-04-08 11
+138 val_138 2008-04-08 11
+453 val_453 2008-04-08 11
+30 val_30 2008-04-08 11
+209 val_209 2008-04-08 11
+64 val_64 2008-04-08 11
+468 val_468 2008-04-08 11
+76 val_76 2008-04-08 11
+74 val_74 2008-04-08 11
+342 val_342 2008-04-08 11
+69 val_69 2008-04-08 11
+230 val_230 2008-04-08 11
+33 val_33 2008-04-08 11
+368 val_368 2008-04-08 11
+103 val_103 2008-04-08 11
+296 val_296 2008-04-08 11
+113 val_113 2008-04-08 11
+216 val_216 2008-04-08 11
+367 val_367 2008-04-08 11
+344 val_344 2008-04-08 11
+167 val_167 2008-04-08 11
+274 val_274 2008-04-08 11
+219 val_219 2008-04-08 11
+239 val_239 2008-04-08 11
+485 val_485 2008-04-08 11
+116 val_116 2008-04-08 11
+223 val_223 2008-04-08 11
+256 val_256 2008-04-08 11
+263 val_263 2008-04-08 11
+70 val_70 2008-04-08 11
+487 val_487 2008-04-08 11
+480 val_480 2008-04-08 11
+401 val_401 2008-04-08 11
+288 val_288 2008-04-08 11
+191 val_191 2008-04-08 11
+5 val_5 2008-04-08 11
+244 val_244 2008-04-08 11
+438 val_438 2008-04-08 11
+128 val_128 2008-04-08 11
+467 val_467 2008-04-08 11
+432 val_432 2008-04-08 11
+202 val_202 2008-04-08 11
+316 val_316 2008-04-08 11
+229 val_229 2008-04-08 11
+469 val_469 2008-04-08 11
+463 val_463 2008-04-08 11
+280 val_280 2008-04-08 11
+2 val_2 2008-04-08 11
+35 val_35 2008-04-08 11
+283 val_283 2008-04-08 11
+331 val_331 2008-04-08 11
+235 val_235 2008-04-08 11
+80 val_80 2008-04-08 11
+44 val_44 2008-04-08 11
+193 val_193 2008-04-08 11
+321 val_321 2008-04-08 11
+335 val_335 2008-04-08 11
+104 val_104 2008-04-08 11
+466 val_466 2008-04-08 11
+366 val_366 2008-04-08 11
+175 val_175 2008-04-08 11
+403 val_403 2008-04-08 11
+483 val_483 2008-04-08 11
+53 val_53 2008-04-08 11
+105 val_105 2008-04-08 11
+257 val_257 2008-04-08 11
+406 val_406 2008-04-08 11
+409 val_409 2008-04-08 11
+190 val_190 2008-04-08 11
+406 val_406 2008-04-08 11
+401 val_401 2008-04-08 11
+114 val_114 2008-04-08 11
+258 val_258 2008-04-08 11
+90 val_90 2008-04-08 11
+203 val_203 2008-04-08 11
+262 val_262 2008-04-08 11
+348 val_348 2008-04-08 11
+424 val_424 2008-04-08 11
+12 val_12 2008-04-08 11
+396 val_396 2008-04-08 11
+201 val_201 2008-04-08 11
+217 val_217 2008-04-08 11
+164 val_164 2008-04-08 11
+431 val_431 2008-04-08 11
+454 val_454 2008-04-08 11
+478 val_478 2008-04-08 11
+298 val_298 2008-04-08 11
+125 val_125 2008-04-08 11
+431 val_431 2008-04-08 11
+164 val_164 2008-04-08 11
+424 val_424 2008-04-08 11
+187 val_187 2008-04-08 11
+382 val_382 2008-04-08 11
+5 val_5 2008-04-08 11
+70 val_70 2008-04-08 11
+397 val_397 2008-04-08 11
+480 val_480 2008-04-08 11
+291 val_291 2008-04-08 11
+24 val_24 2008-04-08 11
+351 val_351 2008-04-08 11
+255 val_255 2008-04-08 11
+104 val_104 2008-04-08 11
+70 val_70 2008-04-08 11
+163 val_163 2008-04-08 11
+438 val_438 2008-04-08 11
+119 val_119 2008-04-08 11
+414 val_414 2008-04-08 11
+200 val_200 2008-04-08 11
+491 val_491 2008-04-08 11
+237 val_237 2008-04-08 11
+439 val_439 2008-04-08 11
+360 val_360 2008-04-08 11
+248 val_248 2008-04-08 11
+479 val_479 2008-04-08 11
+305 val_305 2008-04-08 11
+417 val_417 2008-04-08 11
+199 val_199 2008-04-08 11
+444 val_444 2008-04-08 11
+120 val_120 2008-04-08 11
+429 val_429 2008-04-08 11
+169 val_169 2008-04-08 11
+443 val_443 2008-04-08 11
+323 val_323 2008-04-08 11
+325 val_325 2008-04-08 11
+277 val_277 2008-04-08 11
+230 val_230 2008-04-08 11
+478 val_478 2008-04-08 11
+178 val_178 2008-04-08 11
+468 val_468 2008-04-08 11
+310 val_310 2008-04-08 11
+317 val_317 2008-04-08 11
+333 val_333 2008-04-08 11
+493 val_493 2008-04-08 11
+460 val_460 2008-04-08 11
+207 val_207 2008-04-08 11
+249 val_249 2008-04-08 11
+265 val_265 2008-04-08 11
+480 val_480 2008-04-08 11
+83 val_83 2008-04-08 11
+136 val_136 2008-04-08 11
+353 val_353 2008-04-08 11
+172 val_172 2008-04-08 11
+214 val_214 2008-04-08 11
+462 val_462 2008-04-08 11
+233 val_233 2008-04-08 11
+406 val_406 2008-04-08 11
+133 val_133 2008-04-08 11
+175 val_175 2008-04-08 11
+189 val_189 2008-04-08 11
+454 val_454 2008-04-08 11
+375 val_375 2008-04-08 11
+401 val_401 2008-04-08 11
+421 val_421 2008-04-08 11
+407 val_407 2008-04-08 11
+384 val_384 2008-04-08 11
+256 val_256 2008-04-08 11
+26 val_26 2008-04-08 11
+134 val_134 2008-04-08 11
+67 val_67 2008-04-08 11
+384 val_384 2008-04-08 11
+379 val_379 2008-04-08 11
+18 val_18 2008-04-08 11
+462 val_462 2008-04-08 11
+492 val_492 2008-04-08 11
+100 val_100 2008-04-08 11
+298 val_298 2008-04-08 11
+9 val_9 2008-04-08 11
+341 val_341 2008-04-08 11
+498 val_498 2008-04-08 11
+146 val_146 2008-04-08 11
+458 val_458 2008-04-08 11
+362 val_362 2008-04-08 11
+186 val_186 2008-04-08 11
+285 val_285 2008-04-08 11
+348 val_348 2008-04-08 11
+167 val_167 2008-04-08 11
+18 val_18 2008-04-08 11
+273 val_273 2008-04-08 11
+183 val_183 2008-04-08 11
+281 val_281 2008-04-08 11
+344 val_344 2008-04-08 11
+97 val_97 2008-04-08 11
+469 val_469 2008-04-08 11
+315 val_315 2008-04-08 11
+84 val_84 2008-04-08 11
+28 val_28 2008-04-08 11
+37 val_37 2008-04-08 11
+448 val_448 2008-04-08 11
+152 val_152 2008-04-08 11
+348 val_348 2008-04-08 11
+307 val_307 2008-04-08 11
+194 val_194 2008-04-08 11
+414 val_414 2008-04-08 11
+477 val_477 2008-04-08 11
+222 val_222 2008-04-08 11
+126 val_126 2008-04-08 11
+90 val_90 2008-04-08 11
+169 val_169 2008-04-08 11
+403 val_403 2008-04-08 11
+400 val_400 2008-04-08 11
+200 val_200 2008-04-08 11
+97 val_97 2008-04-08 11
+238 val_238 2008-04-08 12
+86 val_86 2008-04-08 12
+311 val_311 2008-04-08 12
+27 val_27 2008-04-08 12
+165 val_165 2008-04-08 12
+409 val_409 2008-04-08 12
+255 val_255 2008-04-08 12
+278 val_278 2008-04-08 12
+98 val_98 2008-04-08 12
+484 val_484 2008-04-08 12
+265 val_265 2008-04-08 12
+193 val_193 2008-04-08 12
+401 val_401 2008-04-08 12
+150 val_150 2008-04-08 12
+273 val_273 2008-04-08 12
+224 val_224 2008-04-08 12
+369 val_369 2008-04-08 12
+66 val_66 2008-04-08 12
+128 val_128 2008-04-08 12
+213 val_213 2008-04-08 12
+146 val_146 2008-04-08 12
+406 val_406 2008-04-08 12
+429 val_429 2008-04-08 12
+374 val_374 2008-04-08 12
+152 val_152 2008-04-08 12
+469 val_469 2008-04-08 12
+145 val_145 2008-04-08 12
+495 val_495 2008-04-08 12
+37 val_37 2008-04-08 12
+327 val_327 2008-04-08 12
+281 val_281 2008-04-08 12
+277 val_277 2008-04-08 12
+209 val_209 2008-04-08 12
+15 val_15 2008-04-08 12
+82 val_82 2008-04-08 12
+403 val_403 2008-04-08 12
+166 val_166 2008-04-08 12
+417 val_417 2008-04-08 12
+430 val_430 2008-04-08 12
+252 val_252 2008-04-08 12
+292 val_292 2008-04-08 12
+219 val_219 2008-04-08 12
+287 val_287 2008-04-08 12
+153 val_153 2008-04-08 12
+193 val_193 2008-04-08 12
+338 val_338 2008-04-08 12
+446 val_446 2008-04-08 12
+459 val_459 2008-04-08 12
+394 val_394 2008-04-08 12
+237 val_237 2008-04-08 12
+482 val_482 2008-04-08 12
+174 val_174 2008-04-08 12
+413 val_413 2008-04-08 12
+494 val_494 2008-04-08 12
+207 val_207 2008-04-08 12
+199 val_199 2008-04-08 12
+466 val_466 2008-04-08 12
+208 val_208 2008-04-08 12
+174 val_174 2008-04-08 12
+399 val_399 2008-04-08 12
+396 val_396 2008-04-08 12
+247 val_247 2008-04-08 12
+417 val_417 2008-04-08 12
+489 val_489 2008-04-08 12
+162 val_162 2008-04-08 12
+377 val_377 2008-04-08 12
+397 val_397 2008-04-08 12
+309 val_309 2008-04-08 12
+365 val_365 2008-04-08 12
+266 val_266 2008-04-08 12
+439 val_439 2008-04-08 12
+342 val_342 2008-04-08 12
+367 val_367 2008-04-08 12
+325 val_325 2008-04-08 12
+167 val_167 2008-04-08 12
+195 val_195 2008-04-08 12
+475 val_475 2008-04-08 12
+17 val_17 2008-04-08 12
+113 val_113 2008-04-08 12
+155 val_155 2008-04-08 12
+203 val_203 2008-04-08 12
+339 val_339 2008-04-08 12
+0 val_0 2008-04-08 12
+455 val_455 2008-04-08 12
+128 val_128 2008-04-08 12
+311 val_311 2008-04-08 12
+316 val_316 2008-04-08 12
+57 val_57 2008-04-08 12
+302 val_302 2008-04-08 12
+205 val_205 2008-04-08 12
+149 val_149 2008-04-08 12
+438 val_438 2008-04-08 12
+345 val_345 2008-04-08 12
+129 val_129 2008-04-08 12
+170 val_170 2008-04-08 12
+20 val_20 2008-04-08 12
+489 val_489 2008-04-08 12
+157 val_157 2008-04-08 12
+378 val_378 2008-04-08 12
+221 val_221 2008-04-08 12
+92 val_92 2008-04-08 12
+111 val_111 2008-04-08 12
+47 val_47 2008-04-08 12
+72 val_72 2008-04-08 12
+4 val_4 2008-04-08 12
+280 val_280 2008-04-08 12
+35 val_35 2008-04-08 12
+427 val_427 2008-04-08 12
+277 val_277 2008-04-08 12
+208 val_208 2008-04-08 12
+356 val_356 2008-04-08 12
+399 val_399 2008-04-08 12
+169 val_169 2008-04-08 12
+382 val_382 2008-04-08 12
+498 val_498 2008-04-08 12
+125 val_125 2008-04-08 12
+386 val_386 2008-04-08 12
+437 val_437 2008-04-08 12
+469 val_469 2008-04-08 12
+192 val_192 2008-04-08 12
+286 val_286 2008-04-08 12
+187 val_187 2008-04-08 12
+176 val_176 2008-04-08 12
+54 val_54 2008-04-08 12
+459 val_459 2008-04-08 12
+51 val_51 2008-04-08 12
+138 val_138 2008-04-08 12
+103 val_103 2008-04-08 12
+239 val_239 2008-04-08 12
+213 val_213 2008-04-08 12
+216 val_216 2008-04-08 12
+430 val_430 2008-04-08 12
+278 val_278 2008-04-08 12
+176 val_176 2008-04-08 12
+289 val_289 2008-04-08 12
+221 val_221 2008-04-08 12
+65 val_65 2008-04-08 12
+318 val_318 2008-04-08 12
+332 val_332 2008-04-08 12
+311 val_311 2008-04-08 12
+275 val_275 2008-04-08 12
+137 val_137 2008-04-08 12
+241 val_241 2008-04-08 12
+83 val_83 2008-04-08 12
+333 val_333 2008-04-08 12
+180 val_180 2008-04-08 12
+284 val_284 2008-04-08 12
+12 val_12 2008-04-08 12
+230 val_230 2008-04-08 12
+181 val_181 2008-04-08 12
+67 val_67 2008-04-08 12
+260 val_260 2008-04-08 12
+404 val_404 2008-04-08 12
+384 val_384 2008-04-08 12
+489 val_489 2008-04-08 12
+353 val_353 2008-04-08 12
+373 val_373 2008-04-08 12
+272 val_272 2008-04-08 12
+138 val_138 2008-04-08 12
+217 val_217 2008-04-08 12
+84 val_84 2008-04-08 12
+348 val_348 2008-04-08 12
+466 val_466 2008-04-08 12
+58 val_58 2008-04-08 12
+8 val_8 2008-04-08 12
+411 val_411 2008-04-08 12
+230 val_230 2008-04-08 12
+208 val_208 2008-04-08 12
+348 val_348 2008-04-08 12
+24 val_24 2008-04-08 12
+463 val_463 2008-04-08 12
+431 val_431 2008-04-08 12
+179 val_179 2008-04-08 12
+172 val_172 2008-04-08 12
+42 val_42 2008-04-08 12
+129 val_129 2008-04-08 12
+158 val_158 2008-04-08 12
+119 val_119 2008-04-08 12
+496 val_496 2008-04-08 12
+0 val_0 2008-04-08 12
+322 val_322 2008-04-08 12
+197 val_197 2008-04-08 12
+468 val_468 2008-04-08 12
+393 val_393 2008-04-08 12
+454 val_454 2008-04-08 12
+100 val_100 2008-04-08 12
+298 val_298 2008-04-08 12
+199 val_199 2008-04-08 12
+191 val_191 2008-04-08 12
+418 val_418 2008-04-08 12
+96 val_96 2008-04-08 12
+26 val_26 2008-04-08 12
+165 val_165 2008-04-08 12
+327 val_327 2008-04-08 12
+230 val_230 2008-04-08 12
+205 val_205 2008-04-08 12
+120 val_120 2008-04-08 12
+131 val_131 2008-04-08 12
+51 val_51 2008-04-08 12
+404 val_404 2008-04-08 12
+43 val_43 2008-04-08 12
+436 val_436 2008-04-08 12
+156 val_156 2008-04-08 12
+469 val_469 2008-04-08 12
+468 val_468 2008-04-08 12
+308 val_308 2008-04-08 12
+95 val_95 2008-04-08 12
+196 val_196 2008-04-08 12
+288 val_288 2008-04-08 12
+481 val_481 2008-04-08 12
+457 val_457 2008-04-08 12
+98 val_98 2008-04-08 12
+282 val_282 2008-04-08 12
+197 val_197 2008-04-08 12
+187 val_187 2008-04-08 12
+318 val_318 2008-04-08 12
+318 val_318 2008-04-08 12
+409 val_409 2008-04-08 12
+470 val_470 2008-04-08 12
+137 val_137 2008-04-08 12
+369 val_369 2008-04-08 12
+316 val_316 2008-04-08 12
+169 val_169 2008-04-08 12
+413 val_413 2008-04-08 12
+85 val_85 2008-04-08 12
+77 val_77 2008-04-08 12
+0 val_0 2008-04-08 12
+490 val_490 2008-04-08 12
+87 val_87 2008-04-08 12
+364 val_364 2008-04-08 12
+179 val_179 2008-04-08 12
+118 val_118 2008-04-08 12
+134 val_134 2008-04-08 12
+395 val_395 2008-04-08 12
+282 val_282 2008-04-08 12
+138 val_138 2008-04-08 12
+238 val_238 2008-04-08 12
+419 val_419 2008-04-08 12
+15 val_15 2008-04-08 12
+118 val_118 2008-04-08 12
+72 val_72 2008-04-08 12
+90 val_90 2008-04-08 12
+307 val_307 2008-04-08 12
+19 val_19 2008-04-08 12
+435 val_435 2008-04-08 12
+10 val_10 2008-04-08 12
+277 val_277 2008-04-08 12
+273 val_273 2008-04-08 12
+306 val_306 2008-04-08 12
+224 val_224 2008-04-08 12
+309 val_309 2008-04-08 12
+389 val_389 2008-04-08 12
+327 val_327 2008-04-08 12
+242 val_242 2008-04-08 12
+369 val_369 2008-04-08 12
+392 val_392 2008-04-08 12
+272 val_272 2008-04-08 12
+331 val_331 2008-04-08 12
+401 val_401 2008-04-08 12
+242 val_242 2008-04-08 12
+452 val_452 2008-04-08 12
+177 val_177 2008-04-08 12
+226 val_226 2008-04-08 12
+5 val_5 2008-04-08 12
+497 val_497 2008-04-08 12
+402 val_402 2008-04-08 12
+396 val_396 2008-04-08 12
+317 val_317 2008-04-08 12
+395 val_395 2008-04-08 12
+58 val_58 2008-04-08 12
+35 val_35 2008-04-08 12
+336 val_336 2008-04-08 12
+95 val_95 2008-04-08 12
+11 val_11 2008-04-08 12
+168 val_168 2008-04-08 12
+34 val_34 2008-04-08 12
+229 val_229 2008-04-08 12
+233 val_233 2008-04-08 12
+143 val_143 2008-04-08 12
+472 val_472 2008-04-08 12
+322 val_322 2008-04-08 12
+498 val_498 2008-04-08 12
+160 val_160 2008-04-08 12
+195 val_195 2008-04-08 12
+42 val_42 2008-04-08 12
+321 val_321 2008-04-08 12
+430 val_430 2008-04-08 12
+119 val_119 2008-04-08 12
+489 val_489 2008-04-08 12
+458 val_458 2008-04-08 12
+78 val_78 2008-04-08 12
+76 val_76 2008-04-08 12
+41 val_41 2008-04-08 12
+223 val_223 2008-04-08 12
+492 val_492 2008-04-08 12
+149 val_149 2008-04-08 12
+449 val_449 2008-04-08 12
+218 val_218 2008-04-08 12
+228 val_228 2008-04-08 12
+138 val_138 2008-04-08 12
+453 val_453 2008-04-08 12
+30 val_30 2008-04-08 12
+209 val_209 2008-04-08 12
+64 val_64 2008-04-08 12
+468 val_468 2008-04-08 12
+76 val_76 2008-04-08 12
+74 val_74 2008-04-08 12
+342 val_342 2008-04-08 12
+69 val_69 2008-04-08 12
+230 val_230 2008-04-08 12
+33 val_33 2008-04-08 12
+368 val_368 2008-04-08 12
+103 val_103 2008-04-08 12
+296 val_296 2008-04-08 12
+113 val_113 2008-04-08 12
+216 val_216 2008-04-08 12
+367 val_367 2008-04-08 12
+344 val_344 2008-04-08 12
+167 val_167 2008-04-08 12
+274 val_274 2008-04-08 12
+219 val_219 2008-04-08 12
+239 val_239 2008-04-08 12
+485 val_485 2008-04-08 12
+116 val_116 2008-04-08 12
+223 val_223 2008-04-08 12
+256 val_256 2008-04-08 12
+263 val_263 2008-04-08 12
+70 val_70 2008-04-08 12
+487 val_487 2008-04-08 12
+480 val_480 2008-04-08 12
+401 val_401 2008-04-08 12
+288 val_288 2008-04-08 12
+191 val_191 2008-04-08 12
+5 val_5 2008-04-08 12
+244 val_244 2008-04-08 12
+438 val_438 2008-04-08 12
+128 val_128 2008-04-08 12
+467 val_467 2008-04-08 12
+432 val_432 2008-04-08 12
+202 val_202 2008-04-08 12
+316 val_316 2008-04-08 12
+229 val_229 2008-04-08 12
+469 val_469 2008-04-08 12
+463 val_463 2008-04-08 12
+280 val_280 2008-04-08 12
+2 val_2 2008-04-08 12
+35 val_35 2008-04-08 12
+283 val_283 2008-04-08 12
+331 val_331 2008-04-08 12
+235 val_235 2008-04-08 12
+80 val_80 2008-04-08 12
+44 val_44 2008-04-08 12
+193 val_193 2008-04-08 12
+321 val_321 2008-04-08 12
+335 val_335 2008-04-08 12
+104 val_104 2008-04-08 12
+466 val_466 2008-04-08 12
+366 val_366 2008-04-08 12
+175 val_175 2008-04-08 12
+403 val_403 2008-04-08 12
+483 val_483 2008-04-08 12
+53 val_53 2008-04-08 12
+105 val_105 2008-04-08 12
+257 val_257 2008-04-08 12
+406 val_406 2008-04-08 12
+409 val_409 2008-04-08 12
+190 val_190 2008-04-08 12
+406 val_406 2008-04-08 12
+401 val_401 2008-04-08 12
+114 val_114 2008-04-08 12
+258 val_258 2008-04-08 12
+90 val_90 2008-04-08 12
+203 val_203 2008-04-08 12
+262 val_262 2008-04-08 12
+348 val_348 2008-04-08 12
+424 val_424 2008-04-08 12
+12 val_12 2008-04-08 12
+396 val_396 2008-04-08 12
+201 val_201 2008-04-08 12
+217 val_217 2008-04-08 12
+164 val_164 2008-04-08 12
+431 val_431 2008-04-08 12
+454 val_454 2008-04-08 12
+478 val_478 2008-04-08 12
+298 val_298 2008-04-08 12
+125 val_125 2008-04-08 12
+431 val_431 2008-04-08 12
+164 val_164 2008-04-08 12
+424 val_424 2008-04-08 12
+187 val_187 2008-04-08 12
+382 val_382 2008-04-08 12
+5 val_5 2008-04-08 12
+70 val_70 2008-04-08 12
+397 val_397 2008-04-08 12
+480 val_480 2008-04-08 12
+291 val_291 2008-04-08 12
+24 val_24 2008-04-08 12
+351 val_351 2008-04-08 12
+255 val_255 2008-04-08 12
+104 val_104 2008-04-08 12
+70 val_70 2008-04-08 12
+163 val_163 2008-04-08 12
+438 val_438 2008-04-08 12
+119 val_119 2008-04-08 12
+414 val_414 2008-04-08 12
+200 val_200 2008-04-08 12
+491 val_491 2008-04-08 12
+237 val_237 2008-04-08 12
+439 val_439 2008-04-08 12
+360 val_360 2008-04-08 12
+248 val_248 2008-04-08 12
+479 val_479 2008-04-08 12
+305 val_305 2008-04-08 12
+417 val_417 2008-04-08 12
+199 val_199 2008-04-08 12
+444 val_444 2008-04-08 12
+120 val_120 2008-04-08 12
+429 val_429 2008-04-08 12
+169 val_169 2008-04-08 12
+443 val_443 2008-04-08 12
+323 val_323 2008-04-08 12
+325 val_325 2008-04-08 12
+277 val_277 2008-04-08 12
+230 val_230 2008-04-08 12
+478 val_478 2008-04-08 12
+178 val_178 2008-04-08 12
+468 val_468 2008-04-08 12
+310 val_310 2008-04-08 12
+317 val_317 2008-04-08 12
+333 val_333 2008-04-08 12
+493 val_493 2008-04-08 12
+460 val_460 2008-04-08 12
+207 val_207 2008-04-08 12
+249 val_249 2008-04-08 12
+265 val_265 2008-04-08 12
+480 val_480 2008-04-08 12
+83 val_83 2008-04-08 12
+136 val_136 2008-04-08 12
+353 val_353 2008-04-08 12
+172 val_172 2008-04-08 12
+214 val_214 2008-04-08 12
+462 val_462 2008-04-08 12
+233 val_233 2008-04-08 12
+406 val_406 2008-04-08 12
+133 val_133 2008-04-08 12
+175 val_175 2008-04-08 12
+189 val_189 2008-04-08 12
+454 val_454 2008-04-08 12
+375 val_375 2008-04-08 12
+401 val_401 2008-04-08 12
+421 val_421 2008-04-08 12
+407 val_407 2008-04-08 12
+384 val_384 2008-04-08 12
+256 val_256 2008-04-08 12
+26 val_26 2008-04-08 12
+134 val_134 2008-04-08 12
+67 val_67 2008-04-08 12
+384 val_384 2008-04-08 12
+379 val_379 2008-04-08 12
+18 val_18 2008-04-08 12
+462 val_462 2008-04-08 12
+492 val_492 2008-04-08 12
+100 val_100 2008-04-08 12
+298 val_298 2008-04-08 12
+9 val_9 2008-04-08 12
+341 val_341 2008-04-08 12
+498 val_498 2008-04-08 12
+146 val_146 2008-04-08 12
+458 val_458 2008-04-08 12
+362 val_362 2008-04-08 12
+186 val_186 2008-04-08 12
+285 val_285 2008-04-08 12
+348 val_348 2008-04-08 12
+167 val_167 2008-04-08 12
+18 val_18 2008-04-08 12
+273 val_273 2008-04-08 12
+183 val_183 2008-04-08 12
+281 val_281 2008-04-08 12
+344 val_344 2008-04-08 12
+97 val_97 2008-04-08 12
+469 val_469 2008-04-08 12
+315 val_315 2008-04-08 12
+84 val_84 2008-04-08 12
+28 val_28 2008-04-08 12
+37 val_37 2008-04-08 12
+448 val_448 2008-04-08 12
+152 val_152 2008-04-08 12
+348 val_348 2008-04-08 12
+307 val_307 2008-04-08 12
+194 val_194 2008-04-08 12
+414 val_414 2008-04-08 12
+477 val_477 2008-04-08 12
+222 val_222 2008-04-08 12
+126 val_126 2008-04-08 12
+90 val_90 2008-04-08 12
+169 val_169 2008-04-08 12
+403 val_403 2008-04-08 12
+400 val_400 2008-04-08 12
+200 val_200 2008-04-08 12
+97 val_97 2008-04-08 12
Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input_part1.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input_part1.q.out?rev=712905&r1=712904&r2=712905&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input_part1.q.out (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input_part1.q.out Mon Nov 10 17:50:06 2008
@@ -13,7 +13,7 @@
Filter Operator
predicate:
expr: (((key < 100) and (ds = '2008-04-08')) and (hr = '12'))
- type: Boolean
+ type: boolean
Select Operator
expressions:
expr: key
@@ -25,7 +25,7 @@
expr: ds
type: string
File Output Operator
- directory: /tmp/hive-njain/13222008/293248514.10000.insclause-0
+ directory: /tmp/hive-njain/482622140/1009180747.10000.insclause-0
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
@@ -34,7 +34,6 @@
serialization.ddl struct dest1 { i32 key, string value, string hr, string ds}
serialization.format 1
columns key,value,hr,ds
- SORTBUCKETCOLSPREFIX TRUE
bucket_count -1
serialization.lib org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
file.inputformat org.apache.hadoop.mapred.TextInputFormat
@@ -72,7 +71,7 @@
Move Operator
tables:
replace:
- source: /tmp/hive-njain/13222008/293248514.10000.insclause-0
+ source: /tmp/hive-njain/482622140/1009180747.10000.insclause-0
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
@@ -81,7 +80,6 @@
serialization.ddl struct dest1 { i32 key, string value, string hr, string ds}
serialization.format 1
columns key,value,hr,ds
- SORTBUCKETCOLSPREFIX TRUE
bucket_count -1
serialization.lib org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
file.inputformat org.apache.hadoop.mapred.TextInputFormat
Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input_part2.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input_part2.q.out?rev=712905&r1=712904&r2=712905&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input_part2.q.out (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input_part2.q.out Mon Nov 10 17:50:06 2008
@@ -13,7 +13,7 @@
Filter Operator
predicate:
expr: (((key < 100) and (ds = '2008-04-08')) and (hr = '12'))
- type: Boolean
+ type: boolean
Select Operator
expressions:
expr: key
@@ -25,7 +25,7 @@
expr: ds
type: string
File Output Operator
- directory: /tmp/hive-njain/925269835/11972654.10000.insclause-0
+ directory: /tmp/hive-njain/238334885/114382058.10000.insclause-0
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
@@ -34,7 +34,6 @@
serialization.ddl struct dest1 { i32 key, string value, string hr, string ds}
serialization.format 1
columns key,value,hr,ds
- SORTBUCKETCOLSPREFIX TRUE
bucket_count -1
serialization.lib org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
file.inputformat org.apache.hadoop.mapred.TextInputFormat
@@ -45,7 +44,7 @@
Filter Operator
predicate:
expr: (((key < 100) and (ds = '2008-04-09')) and (hr = '12'))
- type: Boolean
+ type: boolean
Select Operator
expressions:
expr: key
@@ -57,7 +56,7 @@
expr: ds
type: string
File Output Operator
- directory: /tmp/hive-njain/925269835/11972654.10001.insclause-1
+ directory: /tmp/hive-njain/238334885/114382058.10001.insclause-1
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
@@ -66,7 +65,6 @@
serialization.ddl struct dest2 { i32 key, string value, string hr, string ds}
serialization.format 1
columns key,value,hr,ds
- SORTBUCKETCOLSPREFIX TRUE
bucket_count -1
serialization.lib org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
file.inputformat org.apache.hadoop.mapred.TextInputFormat
@@ -126,7 +124,7 @@
Move Operator
tables:
replace:
- source: /tmp/hive-njain/925269835/11972654.10000.insclause-0
+ source: /tmp/hive-njain/238334885/114382058.10000.insclause-0
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
@@ -135,7 +133,6 @@
serialization.ddl struct dest1 { i32 key, string value, string hr, string ds}
serialization.format 1
columns key,value,hr,ds
- SORTBUCKETCOLSPREFIX TRUE
bucket_count -1
serialization.lib org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
file.inputformat org.apache.hadoop.mapred.TextInputFormat
@@ -144,7 +141,7 @@
serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
name: dest1
replace:
- source: /tmp/hive-njain/925269835/11972654.10001.insclause-1
+ source: /tmp/hive-njain/238334885/114382058.10001.insclause-1
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
@@ -153,7 +150,6 @@
serialization.ddl struct dest2 { i32 key, string value, string hr, string ds}
serialization.format 1
columns key,value,hr,ds
- SORTBUCKETCOLSPREFIX TRUE
bucket_count -1
serialization.lib org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
file.inputformat org.apache.hadoop.mapred.TextInputFormat