Added: hive/branches/spark/ql/src/test/results/clientpositive/spark/load_dyn_part12.q.out URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/spark/load_dyn_part12.q.out?rev=1622504&view=auto ============================================================================== --- hive/branches/spark/ql/src/test/results/clientpositive/spark/load_dyn_part12.q.out (added) +++ hive/branches/spark/ql/src/test/results/clientpositive/spark/load_dyn_part12.q.out Thu Sep 4 15:49:58 2014 @@ -0,0 +1,2078 @@ +PREHOOK: query: show partitions srcpart +PREHOOK: type: SHOWPARTITIONS +PREHOOK: Input: default@srcpart +POSTHOOK: query: show partitions srcpart +POSTHOOK: type: SHOWPARTITIONS +POSTHOOK: Input: default@srcpart +ds=2008-04-08/hr=11 +ds=2008-04-08/hr=12 +ds=2008-04-09/hr=11 +ds=2008-04-09/hr=12 +PREHOOK: query: create table if not exists nzhang_part12 like srcpart +PREHOOK: type: CREATETABLE +PREHOOK: Output: database:default +PREHOOK: Output: default@nzhang_part12 +POSTHOOK: query: create table if not exists nzhang_part12 like srcpart +POSTHOOK: type: CREATETABLE +POSTHOOK: Output: database:default +POSTHOOK: Output: default@nzhang_part12 +PREHOOK: query: describe extended nzhang_part12 +PREHOOK: type: DESCTABLE +PREHOOK: Input: default@nzhang_part12 +POSTHOOK: query: describe extended nzhang_part12 +POSTHOOK: type: DESCTABLE +POSTHOOK: Input: default@nzhang_part12 +key string default +value string default +ds string +hr string + +# Partition Information +# col_name data_type comment + +ds string +hr string + +#### A masked pattern was here #### +PREHOOK: query: insert overwrite table nzhang_part12 partition (ds="2010-03-03", hr) select key, value, cast(hr*2 as int) from srcpart where ds is not null and hr is not null +PREHOOK: type: QUERY +PREHOOK: Input: default@srcpart +PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=11 +PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=12 +PREHOOK: Input: default@srcpart@ds=2008-04-09/hr=11 +PREHOOK: Input: default@srcpart@ds=2008-04-09/hr=12 +PREHOOK: Output: default@nzhang_part12@ds=2010-03-03 +[Error 30017]: Skipping stats aggregation by error org.apache.hadoop.hive.ql.metadata.HiveException: [Error 30015]: Stats aggregator of type counter cannot be connected to +POSTHOOK: query: insert overwrite table nzhang_part12 partition (ds="2010-03-03", hr) select key, value, cast(hr*2 as int) from srcpart where ds is not null and hr is not null +POSTHOOK: type: QUERY +POSTHOOK: Input: default@srcpart +POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=11 +POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=12 +POSTHOOK: Input: default@srcpart@ds=2008-04-09/hr=11 +POSTHOOK: Input: default@srcpart@ds=2008-04-09/hr=12 +POSTHOOK: Output: default@nzhang_part12@ds=2010-03-03/hr=22 +POSTHOOK: Output: default@nzhang_part12@ds=2010-03-03/hr=24 +POSTHOOK: Lineage: nzhang_part12 PARTITION(ds=2010-03-03,hr=22).key SIMPLE [(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ] +POSTHOOK: Lineage: nzhang_part12 PARTITION(ds=2010-03-03,hr=22).value SIMPLE [(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ] +POSTHOOK: Lineage: nzhang_part12 PARTITION(ds=2010-03-03,hr=24).key SIMPLE [(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ] +POSTHOOK: Lineage: nzhang_part12 PARTITION(ds=2010-03-03,hr=24).value SIMPLE [(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ] +PREHOOK: query: show partitions nzhang_part12 +PREHOOK: type: SHOWPARTITIONS +PREHOOK: Input: default@nzhang_part12 +POSTHOOK: query: show partitions nzhang_part12 +POSTHOOK: type: SHOWPARTITIONS +POSTHOOK: Input: default@nzhang_part12 +ds=2010-03-03/hr=22 +ds=2010-03-03/hr=24 +PREHOOK: query: select * from nzhang_part12 where ds is not null and hr is not null +PREHOOK: type: QUERY +PREHOOK: Input: default@nzhang_part12 +PREHOOK: Input: default@nzhang_part12@ds=2010-03-03/hr=22 +PREHOOK: Input: default@nzhang_part12@ds=2010-03-03/hr=24 +#### A masked pattern was here #### +POSTHOOK: query: select * from nzhang_part12 where ds is not null and hr is not null +POSTHOOK: type: QUERY +POSTHOOK: Input: default@nzhang_part12 +POSTHOOK: Input: default@nzhang_part12@ds=2010-03-03/hr=22 +POSTHOOK: Input: default@nzhang_part12@ds=2010-03-03/hr=24 +#### A masked pattern was here #### +238 val_238 2010-03-03 22 +86 val_86 2010-03-03 22 +311 val_311 2010-03-03 22 +27 val_27 2010-03-03 22 +165 val_165 2010-03-03 22 +409 val_409 2010-03-03 22 +255 val_255 2010-03-03 22 +278 val_278 2010-03-03 22 +98 val_98 2010-03-03 22 +484 val_484 2010-03-03 22 +265 val_265 2010-03-03 22 +193 val_193 2010-03-03 22 +401 val_401 2010-03-03 22 +150 val_150 2010-03-03 22 +273 val_273 2010-03-03 22 +224 val_224 2010-03-03 22 +369 val_369 2010-03-03 22 +66 val_66 2010-03-03 22 +128 val_128 2010-03-03 22 +213 val_213 2010-03-03 22 +146 val_146 2010-03-03 22 +406 val_406 2010-03-03 22 +429 val_429 2010-03-03 22 +374 val_374 2010-03-03 22 +152 val_152 2010-03-03 22 +469 val_469 2010-03-03 22 +145 val_145 2010-03-03 22 +495 val_495 2010-03-03 22 +37 val_37 2010-03-03 22 +327 val_327 2010-03-03 22 +281 val_281 2010-03-03 22 +277 val_277 2010-03-03 22 +209 val_209 2010-03-03 22 +15 val_15 2010-03-03 22 +82 val_82 2010-03-03 22 +403 val_403 2010-03-03 22 +166 val_166 2010-03-03 22 +417 val_417 2010-03-03 22 +430 val_430 2010-03-03 22 +252 val_252 2010-03-03 22 +292 val_292 2010-03-03 22 +219 val_219 2010-03-03 22 +287 val_287 2010-03-03 22 +153 val_153 2010-03-03 22 +193 val_193 2010-03-03 22 +338 val_338 2010-03-03 22 +446 val_446 2010-03-03 22 +459 val_459 2010-03-03 22 +394 val_394 2010-03-03 22 +237 val_237 2010-03-03 22 +482 val_482 2010-03-03 22 +174 val_174 2010-03-03 22 +413 val_413 2010-03-03 22 +494 val_494 2010-03-03 22 +207 val_207 2010-03-03 22 +199 val_199 2010-03-03 22 +466 val_466 2010-03-03 22 +208 val_208 2010-03-03 22 +174 val_174 2010-03-03 22 +399 val_399 2010-03-03 22 +396 val_396 2010-03-03 22 +247 val_247 2010-03-03 22 +417 val_417 2010-03-03 22 +489 val_489 2010-03-03 22 +162 val_162 2010-03-03 22 +377 val_377 2010-03-03 22 +397 val_397 2010-03-03 22 +309 val_309 2010-03-03 22 +365 val_365 2010-03-03 22 +266 val_266 2010-03-03 22 +439 val_439 2010-03-03 22 +342 val_342 2010-03-03 22 +367 val_367 2010-03-03 22 +325 val_325 2010-03-03 22 +167 val_167 2010-03-03 22 +195 val_195 2010-03-03 22 +475 val_475 2010-03-03 22 +17 val_17 2010-03-03 22 +113 val_113 2010-03-03 22 +155 val_155 2010-03-03 22 +203 val_203 2010-03-03 22 +339 val_339 2010-03-03 22 +0 val_0 2010-03-03 22 +455 val_455 2010-03-03 22 +128 val_128 2010-03-03 22 +311 val_311 2010-03-03 22 +316 val_316 2010-03-03 22 +57 val_57 2010-03-03 22 +302 val_302 2010-03-03 22 +205 val_205 2010-03-03 22 +149 val_149 2010-03-03 22 +438 val_438 2010-03-03 22 +345 val_345 2010-03-03 22 +129 val_129 2010-03-03 22 +170 val_170 2010-03-03 22 +20 val_20 2010-03-03 22 +489 val_489 2010-03-03 22 +157 val_157 2010-03-03 22 +378 val_378 2010-03-03 22 +221 val_221 2010-03-03 22 +92 val_92 2010-03-03 22 +111 val_111 2010-03-03 22 +47 val_47 2010-03-03 22 +72 val_72 2010-03-03 22 +4 val_4 2010-03-03 22 +280 val_280 2010-03-03 22 +35 val_35 2010-03-03 22 +427 val_427 2010-03-03 22 +277 val_277 2010-03-03 22 +208 val_208 2010-03-03 22 +356 val_356 2010-03-03 22 +399 val_399 2010-03-03 22 +169 val_169 2010-03-03 22 +382 val_382 2010-03-03 22 +498 val_498 2010-03-03 22 +125 val_125 2010-03-03 22 +386 val_386 2010-03-03 22 +437 val_437 2010-03-03 22 +469 val_469 2010-03-03 22 +192 val_192 2010-03-03 22 +286 val_286 2010-03-03 22 +187 val_187 2010-03-03 22 +176 val_176 2010-03-03 22 +54 val_54 2010-03-03 22 +459 val_459 2010-03-03 22 +51 val_51 2010-03-03 22 +138 val_138 2010-03-03 22 +103 val_103 2010-03-03 22 +239 val_239 2010-03-03 22 +213 val_213 2010-03-03 22 +216 val_216 2010-03-03 22 +430 val_430 2010-03-03 22 +278 val_278 2010-03-03 22 +176 val_176 2010-03-03 22 +289 val_289 2010-03-03 22 +221 val_221 2010-03-03 22 +65 val_65 2010-03-03 22 +318 val_318 2010-03-03 22 +332 val_332 2010-03-03 22 +311 val_311 2010-03-03 22 +275 val_275 2010-03-03 22 +137 val_137 2010-03-03 22 +241 val_241 2010-03-03 22 +83 val_83 2010-03-03 22 +333 val_333 2010-03-03 22 +180 val_180 2010-03-03 22 +284 val_284 2010-03-03 22 +12 val_12 2010-03-03 22 +230 val_230 2010-03-03 22 +181 val_181 2010-03-03 22 +67 val_67 2010-03-03 22 +260 val_260 2010-03-03 22 +404 val_404 2010-03-03 22 +384 val_384 2010-03-03 22 +489 val_489 2010-03-03 22 +353 val_353 2010-03-03 22 +373 val_373 2010-03-03 22 +272 val_272 2010-03-03 22 +138 val_138 2010-03-03 22 +217 val_217 2010-03-03 22 +84 val_84 2010-03-03 22 +348 val_348 2010-03-03 22 +466 val_466 2010-03-03 22 +58 val_58 2010-03-03 22 +8 val_8 2010-03-03 22 +411 val_411 2010-03-03 22 +230 val_230 2010-03-03 22 +208 val_208 2010-03-03 22 +348 val_348 2010-03-03 22 +24 val_24 2010-03-03 22 +463 val_463 2010-03-03 22 +431 val_431 2010-03-03 22 +179 val_179 2010-03-03 22 +172 val_172 2010-03-03 22 +42 val_42 2010-03-03 22 +129 val_129 2010-03-03 22 +158 val_158 2010-03-03 22 +119 val_119 2010-03-03 22 +496 val_496 2010-03-03 22 +0 val_0 2010-03-03 22 +322 val_322 2010-03-03 22 +197 val_197 2010-03-03 22 +468 val_468 2010-03-03 22 +393 val_393 2010-03-03 22 +454 val_454 2010-03-03 22 +100 val_100 2010-03-03 22 +298 val_298 2010-03-03 22 +199 val_199 2010-03-03 22 +191 val_191 2010-03-03 22 +418 val_418 2010-03-03 22 +96 val_96 2010-03-03 22 +26 val_26 2010-03-03 22 +165 val_165 2010-03-03 22 +327 val_327 2010-03-03 22 +230 val_230 2010-03-03 22 +205 val_205 2010-03-03 22 +120 val_120 2010-03-03 22 +131 val_131 2010-03-03 22 +51 val_51 2010-03-03 22 +404 val_404 2010-03-03 22 +43 val_43 2010-03-03 22 +436 val_436 2010-03-03 22 +156 val_156 2010-03-03 22 +469 val_469 2010-03-03 22 +468 val_468 2010-03-03 22 +308 val_308 2010-03-03 22 +95 val_95 2010-03-03 22 +196 val_196 2010-03-03 22 +288 val_288 2010-03-03 22 +481 val_481 2010-03-03 22 +457 val_457 2010-03-03 22 +98 val_98 2010-03-03 22 +282 val_282 2010-03-03 22 +197 val_197 2010-03-03 22 +187 val_187 2010-03-03 22 +318 val_318 2010-03-03 22 +318 val_318 2010-03-03 22 +409 val_409 2010-03-03 22 +470 val_470 2010-03-03 22 +137 val_137 2010-03-03 22 +369 val_369 2010-03-03 22 +316 val_316 2010-03-03 22 +169 val_169 2010-03-03 22 +413 val_413 2010-03-03 22 +85 val_85 2010-03-03 22 +77 val_77 2010-03-03 22 +0 val_0 2010-03-03 22 +490 val_490 2010-03-03 22 +87 val_87 2010-03-03 22 +364 val_364 2010-03-03 22 +179 val_179 2010-03-03 22 +118 val_118 2010-03-03 22 +134 val_134 2010-03-03 22 +395 val_395 2010-03-03 22 +282 val_282 2010-03-03 22 +138 val_138 2010-03-03 22 +238 val_238 2010-03-03 22 +419 val_419 2010-03-03 22 +15 val_15 2010-03-03 22 +118 val_118 2010-03-03 22 +72 val_72 2010-03-03 22 +90 val_90 2010-03-03 22 +307 val_307 2010-03-03 22 +19 val_19 2010-03-03 22 +435 val_435 2010-03-03 22 +10 val_10 2010-03-03 22 +277 val_277 2010-03-03 22 +273 val_273 2010-03-03 22 +306 val_306 2010-03-03 22 +224 val_224 2010-03-03 22 +309 val_309 2010-03-03 22 +389 val_389 2010-03-03 22 +327 val_327 2010-03-03 22 +242 val_242 2010-03-03 22 +369 val_369 2010-03-03 22 +392 val_392 2010-03-03 22 +272 val_272 2010-03-03 22 +331 val_331 2010-03-03 22 +401 val_401 2010-03-03 22 +242 val_242 2010-03-03 22 +452 val_452 2010-03-03 22 +177 val_177 2010-03-03 22 +226 val_226 2010-03-03 22 +5 val_5 2010-03-03 22 +497 val_497 2010-03-03 22 +402 val_402 2010-03-03 22 +396 val_396 2010-03-03 22 +317 val_317 2010-03-03 22 +395 val_395 2010-03-03 22 +58 val_58 2010-03-03 22 +35 val_35 2010-03-03 22 +336 val_336 2010-03-03 22 +95 val_95 2010-03-03 22 +11 val_11 2010-03-03 22 +168 val_168 2010-03-03 22 +34 val_34 2010-03-03 22 +229 val_229 2010-03-03 22 +233 val_233 2010-03-03 22 +143 val_143 2010-03-03 22 +472 val_472 2010-03-03 22 +322 val_322 2010-03-03 22 +498 val_498 2010-03-03 22 +160 val_160 2010-03-03 22 +195 val_195 2010-03-03 22 +42 val_42 2010-03-03 22 +321 val_321 2010-03-03 22 +430 val_430 2010-03-03 22 +119 val_119 2010-03-03 22 +489 val_489 2010-03-03 22 +458 val_458 2010-03-03 22 +78 val_78 2010-03-03 22 +76 val_76 2010-03-03 22 +41 val_41 2010-03-03 22 +223 val_223 2010-03-03 22 +492 val_492 2010-03-03 22 +149 val_149 2010-03-03 22 +449 val_449 2010-03-03 22 +218 val_218 2010-03-03 22 +228 val_228 2010-03-03 22 +138 val_138 2010-03-03 22 +453 val_453 2010-03-03 22 +30 val_30 2010-03-03 22 +209 val_209 2010-03-03 22 +64 val_64 2010-03-03 22 +468 val_468 2010-03-03 22 +76 val_76 2010-03-03 22 +74 val_74 2010-03-03 22 +342 val_342 2010-03-03 22 +69 val_69 2010-03-03 22 +230 val_230 2010-03-03 22 +33 val_33 2010-03-03 22 +368 val_368 2010-03-03 22 +103 val_103 2010-03-03 22 +296 val_296 2010-03-03 22 +113 val_113 2010-03-03 22 +216 val_216 2010-03-03 22 +367 val_367 2010-03-03 22 +344 val_344 2010-03-03 22 +167 val_167 2010-03-03 22 +274 val_274 2010-03-03 22 +219 val_219 2010-03-03 22 +239 val_239 2010-03-03 22 +485 val_485 2010-03-03 22 +116 val_116 2010-03-03 22 +223 val_223 2010-03-03 22 +256 val_256 2010-03-03 22 +263 val_263 2010-03-03 22 +70 val_70 2010-03-03 22 +487 val_487 2010-03-03 22 +480 val_480 2010-03-03 22 +401 val_401 2010-03-03 22 +288 val_288 2010-03-03 22 +191 val_191 2010-03-03 22 +5 val_5 2010-03-03 22 +244 val_244 2010-03-03 22 +438 val_438 2010-03-03 22 +128 val_128 2010-03-03 22 +467 val_467 2010-03-03 22 +432 val_432 2010-03-03 22 +202 val_202 2010-03-03 22 +316 val_316 2010-03-03 22 +229 val_229 2010-03-03 22 +469 val_469 2010-03-03 22 +463 val_463 2010-03-03 22 +280 val_280 2010-03-03 22 +2 val_2 2010-03-03 22 +35 val_35 2010-03-03 22 +283 val_283 2010-03-03 22 +331 val_331 2010-03-03 22 +235 val_235 2010-03-03 22 +80 val_80 2010-03-03 22 +44 val_44 2010-03-03 22 +193 val_193 2010-03-03 22 +321 val_321 2010-03-03 22 +335 val_335 2010-03-03 22 +104 val_104 2010-03-03 22 +466 val_466 2010-03-03 22 +366 val_366 2010-03-03 22 +175 val_175 2010-03-03 22 +403 val_403 2010-03-03 22 +483 val_483 2010-03-03 22 +53 val_53 2010-03-03 22 +105 val_105 2010-03-03 22 +257 val_257 2010-03-03 22 +406 val_406 2010-03-03 22 +409 val_409 2010-03-03 22 +190 val_190 2010-03-03 22 +406 val_406 2010-03-03 22 +401 val_401 2010-03-03 22 +114 val_114 2010-03-03 22 +258 val_258 2010-03-03 22 +90 val_90 2010-03-03 22 +203 val_203 2010-03-03 22 +262 val_262 2010-03-03 22 +348 val_348 2010-03-03 22 +424 val_424 2010-03-03 22 +12 val_12 2010-03-03 22 +396 val_396 2010-03-03 22 +201 val_201 2010-03-03 22 +217 val_217 2010-03-03 22 +164 val_164 2010-03-03 22 +431 val_431 2010-03-03 22 +454 val_454 2010-03-03 22 +478 val_478 2010-03-03 22 +298 val_298 2010-03-03 22 +125 val_125 2010-03-03 22 +431 val_431 2010-03-03 22 +164 val_164 2010-03-03 22 +424 val_424 2010-03-03 22 +187 val_187 2010-03-03 22 +382 val_382 2010-03-03 22 +5 val_5 2010-03-03 22 +70 val_70 2010-03-03 22 +397 val_397 2010-03-03 22 +480 val_480 2010-03-03 22 +291 val_291 2010-03-03 22 +24 val_24 2010-03-03 22 +351 val_351 2010-03-03 22 +255 val_255 2010-03-03 22 +104 val_104 2010-03-03 22 +70 val_70 2010-03-03 22 +163 val_163 2010-03-03 22 +438 val_438 2010-03-03 22 +119 val_119 2010-03-03 22 +414 val_414 2010-03-03 22 +200 val_200 2010-03-03 22 +491 val_491 2010-03-03 22 +237 val_237 2010-03-03 22 +439 val_439 2010-03-03 22 +360 val_360 2010-03-03 22 +248 val_248 2010-03-03 22 +479 val_479 2010-03-03 22 +305 val_305 2010-03-03 22 +417 val_417 2010-03-03 22 +199 val_199 2010-03-03 22 +444 val_444 2010-03-03 22 +120 val_120 2010-03-03 22 +429 val_429 2010-03-03 22 +169 val_169 2010-03-03 22 +443 val_443 2010-03-03 22 +323 val_323 2010-03-03 22 +325 val_325 2010-03-03 22 +277 val_277 2010-03-03 22 +230 val_230 2010-03-03 22 +478 val_478 2010-03-03 22 +178 val_178 2010-03-03 22 +468 val_468 2010-03-03 22 +310 val_310 2010-03-03 22 +317 val_317 2010-03-03 22 +333 val_333 2010-03-03 22 +493 val_493 2010-03-03 22 +460 val_460 2010-03-03 22 +207 val_207 2010-03-03 22 +249 val_249 2010-03-03 22 +265 val_265 2010-03-03 22 +480 val_480 2010-03-03 22 +83 val_83 2010-03-03 22 +136 val_136 2010-03-03 22 +353 val_353 2010-03-03 22 +172 val_172 2010-03-03 22 +214 val_214 2010-03-03 22 +462 val_462 2010-03-03 22 +233 val_233 2010-03-03 22 +406 val_406 2010-03-03 22 +133 val_133 2010-03-03 22 +175 val_175 2010-03-03 22 +189 val_189 2010-03-03 22 +454 val_454 2010-03-03 22 +375 val_375 2010-03-03 22 +401 val_401 2010-03-03 22 +421 val_421 2010-03-03 22 +407 val_407 2010-03-03 22 +384 val_384 2010-03-03 22 +256 val_256 2010-03-03 22 +26 val_26 2010-03-03 22 +134 val_134 2010-03-03 22 +67 val_67 2010-03-03 22 +384 val_384 2010-03-03 22 +379 val_379 2010-03-03 22 +18 val_18 2010-03-03 22 +462 val_462 2010-03-03 22 +492 val_492 2010-03-03 22 +100 val_100 2010-03-03 22 +298 val_298 2010-03-03 22 +9 val_9 2010-03-03 22 +341 val_341 2010-03-03 22 +498 val_498 2010-03-03 22 +146 val_146 2010-03-03 22 +458 val_458 2010-03-03 22 +362 val_362 2010-03-03 22 +186 val_186 2010-03-03 22 +285 val_285 2010-03-03 22 +348 val_348 2010-03-03 22 +167 val_167 2010-03-03 22 +18 val_18 2010-03-03 22 +273 val_273 2010-03-03 22 +183 val_183 2010-03-03 22 +281 val_281 2010-03-03 22 +344 val_344 2010-03-03 22 +97 val_97 2010-03-03 22 +469 val_469 2010-03-03 22 +315 val_315 2010-03-03 22 +84 val_84 2010-03-03 22 +28 val_28 2010-03-03 22 +37 val_37 2010-03-03 22 +448 val_448 2010-03-03 22 +152 val_152 2010-03-03 22 +348 val_348 2010-03-03 22 +307 val_307 2010-03-03 22 +194 val_194 2010-03-03 22 +414 val_414 2010-03-03 22 +477 val_477 2010-03-03 22 +222 val_222 2010-03-03 22 +126 val_126 2010-03-03 22 +90 val_90 2010-03-03 22 +169 val_169 2010-03-03 22 +403 val_403 2010-03-03 22 +400 val_400 2010-03-03 22 +200 val_200 2010-03-03 22 +97 val_97 2010-03-03 22 +238 val_238 2010-03-03 22 +86 val_86 2010-03-03 22 +311 val_311 2010-03-03 22 +27 val_27 2010-03-03 22 +165 val_165 2010-03-03 22 +409 val_409 2010-03-03 22 +255 val_255 2010-03-03 22 +278 val_278 2010-03-03 22 +98 val_98 2010-03-03 22 +484 val_484 2010-03-03 22 +265 val_265 2010-03-03 22 +193 val_193 2010-03-03 22 +401 val_401 2010-03-03 22 +150 val_150 2010-03-03 22 +273 val_273 2010-03-03 22 +224 val_224 2010-03-03 22 +369 val_369 2010-03-03 22 +66 val_66 2010-03-03 22 +128 val_128 2010-03-03 22 +213 val_213 2010-03-03 22 +146 val_146 2010-03-03 22 +406 val_406 2010-03-03 22 +429 val_429 2010-03-03 22 +374 val_374 2010-03-03 22 +152 val_152 2010-03-03 22 +469 val_469 2010-03-03 22 +145 val_145 2010-03-03 22 +495 val_495 2010-03-03 22 +37 val_37 2010-03-03 22 +327 val_327 2010-03-03 22 +281 val_281 2010-03-03 22 +277 val_277 2010-03-03 22 +209 val_209 2010-03-03 22 +15 val_15 2010-03-03 22 +82 val_82 2010-03-03 22 +403 val_403 2010-03-03 22 +166 val_166 2010-03-03 22 +417 val_417 2010-03-03 22 +430 val_430 2010-03-03 22 +252 val_252 2010-03-03 22 +292 val_292 2010-03-03 22 +219 val_219 2010-03-03 22 +287 val_287 2010-03-03 22 +153 val_153 2010-03-03 22 +193 val_193 2010-03-03 22 +338 val_338 2010-03-03 22 +446 val_446 2010-03-03 22 +459 val_459 2010-03-03 22 +394 val_394 2010-03-03 22 +237 val_237 2010-03-03 22 +482 val_482 2010-03-03 22 +174 val_174 2010-03-03 22 +413 val_413 2010-03-03 22 +494 val_494 2010-03-03 22 +207 val_207 2010-03-03 22 +199 val_199 2010-03-03 22 +466 val_466 2010-03-03 22 +208 val_208 2010-03-03 22 +174 val_174 2010-03-03 22 +399 val_399 2010-03-03 22 +396 val_396 2010-03-03 22 +247 val_247 2010-03-03 22 +417 val_417 2010-03-03 22 +489 val_489 2010-03-03 22 +162 val_162 2010-03-03 22 +377 val_377 2010-03-03 22 +397 val_397 2010-03-03 22 +309 val_309 2010-03-03 22 +365 val_365 2010-03-03 22 +266 val_266 2010-03-03 22 +439 val_439 2010-03-03 22 +342 val_342 2010-03-03 22 +367 val_367 2010-03-03 22 +325 val_325 2010-03-03 22 +167 val_167 2010-03-03 22 +195 val_195 2010-03-03 22 +475 val_475 2010-03-03 22 +17 val_17 2010-03-03 22 +113 val_113 2010-03-03 22 +155 val_155 2010-03-03 22 +203 val_203 2010-03-03 22 +339 val_339 2010-03-03 22 +0 val_0 2010-03-03 22 +455 val_455 2010-03-03 22 +128 val_128 2010-03-03 22 +311 val_311 2010-03-03 22 +316 val_316 2010-03-03 22 +57 val_57 2010-03-03 22 +302 val_302 2010-03-03 22 +205 val_205 2010-03-03 22 +149 val_149 2010-03-03 22 +438 val_438 2010-03-03 22 +345 val_345 2010-03-03 22 +129 val_129 2010-03-03 22 +170 val_170 2010-03-03 22 +20 val_20 2010-03-03 22 +489 val_489 2010-03-03 22 +157 val_157 2010-03-03 22 +378 val_378 2010-03-03 22 +221 val_221 2010-03-03 22 +92 val_92 2010-03-03 22 +111 val_111 2010-03-03 22 +47 val_47 2010-03-03 22 +72 val_72 2010-03-03 22 +4 val_4 2010-03-03 22 +280 val_280 2010-03-03 22 +35 val_35 2010-03-03 22 +427 val_427 2010-03-03 22 +277 val_277 2010-03-03 22 +208 val_208 2010-03-03 22 +356 val_356 2010-03-03 22 +399 val_399 2010-03-03 22 +169 val_169 2010-03-03 22 +382 val_382 2010-03-03 22 +498 val_498 2010-03-03 22 +125 val_125 2010-03-03 22 +386 val_386 2010-03-03 22 +437 val_437 2010-03-03 22 +469 val_469 2010-03-03 22 +192 val_192 2010-03-03 22 +286 val_286 2010-03-03 22 +187 val_187 2010-03-03 22 +176 val_176 2010-03-03 22 +54 val_54 2010-03-03 22 +459 val_459 2010-03-03 22 +51 val_51 2010-03-03 22 +138 val_138 2010-03-03 22 +103 val_103 2010-03-03 22 +239 val_239 2010-03-03 22 +213 val_213 2010-03-03 22 +216 val_216 2010-03-03 22 +430 val_430 2010-03-03 22 +278 val_278 2010-03-03 22 +176 val_176 2010-03-03 22 +289 val_289 2010-03-03 22 +221 val_221 2010-03-03 22 +65 val_65 2010-03-03 22 +318 val_318 2010-03-03 22 +332 val_332 2010-03-03 22 +311 val_311 2010-03-03 22 +275 val_275 2010-03-03 22 +137 val_137 2010-03-03 22 +241 val_241 2010-03-03 22 +83 val_83 2010-03-03 22 +333 val_333 2010-03-03 22 +180 val_180 2010-03-03 22 +284 val_284 2010-03-03 22 +12 val_12 2010-03-03 22 +230 val_230 2010-03-03 22 +181 val_181 2010-03-03 22 +67 val_67 2010-03-03 22 +260 val_260 2010-03-03 22 +404 val_404 2010-03-03 22 +384 val_384 2010-03-03 22 +489 val_489 2010-03-03 22 +353 val_353 2010-03-03 22 +373 val_373 2010-03-03 22 +272 val_272 2010-03-03 22 +138 val_138 2010-03-03 22 +217 val_217 2010-03-03 22 +84 val_84 2010-03-03 22 +348 val_348 2010-03-03 22 +466 val_466 2010-03-03 22 +58 val_58 2010-03-03 22 +8 val_8 2010-03-03 22 +411 val_411 2010-03-03 22 +230 val_230 2010-03-03 22 +208 val_208 2010-03-03 22 +348 val_348 2010-03-03 22 +24 val_24 2010-03-03 22 +463 val_463 2010-03-03 22 +431 val_431 2010-03-03 22 +179 val_179 2010-03-03 22 +172 val_172 2010-03-03 22 +42 val_42 2010-03-03 22 +129 val_129 2010-03-03 22 +158 val_158 2010-03-03 22 +119 val_119 2010-03-03 22 +496 val_496 2010-03-03 22 +0 val_0 2010-03-03 22 +322 val_322 2010-03-03 22 +197 val_197 2010-03-03 22 +468 val_468 2010-03-03 22 +393 val_393 2010-03-03 22 +454 val_454 2010-03-03 22 +100 val_100 2010-03-03 22 +298 val_298 2010-03-03 22 +199 val_199 2010-03-03 22 +191 val_191 2010-03-03 22 +418 val_418 2010-03-03 22 +96 val_96 2010-03-03 22 +26 val_26 2010-03-03 22 +165 val_165 2010-03-03 22 +327 val_327 2010-03-03 22 +230 val_230 2010-03-03 22 +205 val_205 2010-03-03 22 +120 val_120 2010-03-03 22 +131 val_131 2010-03-03 22 +51 val_51 2010-03-03 22 +404 val_404 2010-03-03 22 +43 val_43 2010-03-03 22 +436 val_436 2010-03-03 22 +156 val_156 2010-03-03 22 +469 val_469 2010-03-03 22 +468 val_468 2010-03-03 22 +308 val_308 2010-03-03 22 +95 val_95 2010-03-03 22 +196 val_196 2010-03-03 22 +288 val_288 2010-03-03 22 +481 val_481 2010-03-03 22 +457 val_457 2010-03-03 22 +98 val_98 2010-03-03 22 +282 val_282 2010-03-03 22 +197 val_197 2010-03-03 22 +187 val_187 2010-03-03 22 +318 val_318 2010-03-03 22 +318 val_318 2010-03-03 22 +409 val_409 2010-03-03 22 +470 val_470 2010-03-03 22 +137 val_137 2010-03-03 22 +369 val_369 2010-03-03 22 +316 val_316 2010-03-03 22 +169 val_169 2010-03-03 22 +413 val_413 2010-03-03 22 +85 val_85 2010-03-03 22 +77 val_77 2010-03-03 22 +0 val_0 2010-03-03 22 +490 val_490 2010-03-03 22 +87 val_87 2010-03-03 22 +364 val_364 2010-03-03 22 +179 val_179 2010-03-03 22 +118 val_118 2010-03-03 22 +134 val_134 2010-03-03 22 +395 val_395 2010-03-03 22 +282 val_282 2010-03-03 22 +138 val_138 2010-03-03 22 +238 val_238 2010-03-03 22 +419 val_419 2010-03-03 22 +15 val_15 2010-03-03 22 +118 val_118 2010-03-03 22 +72 val_72 2010-03-03 22 +90 val_90 2010-03-03 22 +307 val_307 2010-03-03 22 +19 val_19 2010-03-03 22 +435 val_435 2010-03-03 22 +10 val_10 2010-03-03 22 +277 val_277 2010-03-03 22 +273 val_273 2010-03-03 22 +306 val_306 2010-03-03 22 +224 val_224 2010-03-03 22 +309 val_309 2010-03-03 22 +389 val_389 2010-03-03 22 +327 val_327 2010-03-03 22 +242 val_242 2010-03-03 22 +369 val_369 2010-03-03 22 +392 val_392 2010-03-03 22 +272 val_272 2010-03-03 22 +331 val_331 2010-03-03 22 +401 val_401 2010-03-03 22 +242 val_242 2010-03-03 22 +452 val_452 2010-03-03 22 +177 val_177 2010-03-03 22 +226 val_226 2010-03-03 22 +5 val_5 2010-03-03 22 +497 val_497 2010-03-03 22 +402 val_402 2010-03-03 22 +396 val_396 2010-03-03 22 +317 val_317 2010-03-03 22 +395 val_395 2010-03-03 22 +58 val_58 2010-03-03 22 +35 val_35 2010-03-03 22 +336 val_336 2010-03-03 22 +95 val_95 2010-03-03 22 +11 val_11 2010-03-03 22 +168 val_168 2010-03-03 22 +34 val_34 2010-03-03 22 +229 val_229 2010-03-03 22 +233 val_233 2010-03-03 22 +143 val_143 2010-03-03 22 +472 val_472 2010-03-03 22 +322 val_322 2010-03-03 22 +498 val_498 2010-03-03 22 +160 val_160 2010-03-03 22 +195 val_195 2010-03-03 22 +42 val_42 2010-03-03 22 +321 val_321 2010-03-03 22 +430 val_430 2010-03-03 22 +119 val_119 2010-03-03 22 +489 val_489 2010-03-03 22 +458 val_458 2010-03-03 22 +78 val_78 2010-03-03 22 +76 val_76 2010-03-03 22 +41 val_41 2010-03-03 22 +223 val_223 2010-03-03 22 +492 val_492 2010-03-03 22 +149 val_149 2010-03-03 22 +449 val_449 2010-03-03 22 +218 val_218 2010-03-03 22 +228 val_228 2010-03-03 22 +138 val_138 2010-03-03 22 +453 val_453 2010-03-03 22 +30 val_30 2010-03-03 22 +209 val_209 2010-03-03 22 +64 val_64 2010-03-03 22 +468 val_468 2010-03-03 22 +76 val_76 2010-03-03 22 +74 val_74 2010-03-03 22 +342 val_342 2010-03-03 22 +69 val_69 2010-03-03 22 +230 val_230 2010-03-03 22 +33 val_33 2010-03-03 22 +368 val_368 2010-03-03 22 +103 val_103 2010-03-03 22 +296 val_296 2010-03-03 22 +113 val_113 2010-03-03 22 +216 val_216 2010-03-03 22 +367 val_367 2010-03-03 22 +344 val_344 2010-03-03 22 +167 val_167 2010-03-03 22 +274 val_274 2010-03-03 22 +219 val_219 2010-03-03 22 +239 val_239 2010-03-03 22 +485 val_485 2010-03-03 22 +116 val_116 2010-03-03 22 +223 val_223 2010-03-03 22 +256 val_256 2010-03-03 22 +263 val_263 2010-03-03 22 +70 val_70 2010-03-03 22 +487 val_487 2010-03-03 22 +480 val_480 2010-03-03 22 +401 val_401 2010-03-03 22 +288 val_288 2010-03-03 22 +191 val_191 2010-03-03 22 +5 val_5 2010-03-03 22 +244 val_244 2010-03-03 22 +438 val_438 2010-03-03 22 +128 val_128 2010-03-03 22 +467 val_467 2010-03-03 22 +432 val_432 2010-03-03 22 +202 val_202 2010-03-03 22 +316 val_316 2010-03-03 22 +229 val_229 2010-03-03 22 +469 val_469 2010-03-03 22 +463 val_463 2010-03-03 22 +280 val_280 2010-03-03 22 +2 val_2 2010-03-03 22 +35 val_35 2010-03-03 22 +283 val_283 2010-03-03 22 +331 val_331 2010-03-03 22 +235 val_235 2010-03-03 22 +80 val_80 2010-03-03 22 +44 val_44 2010-03-03 22 +193 val_193 2010-03-03 22 +321 val_321 2010-03-03 22 +335 val_335 2010-03-03 22 +104 val_104 2010-03-03 22 +466 val_466 2010-03-03 22 +366 val_366 2010-03-03 22 +175 val_175 2010-03-03 22 +403 val_403 2010-03-03 22 +483 val_483 2010-03-03 22 +53 val_53 2010-03-03 22 +105 val_105 2010-03-03 22 +257 val_257 2010-03-03 22 +406 val_406 2010-03-03 22 +409 val_409 2010-03-03 22 +190 val_190 2010-03-03 22 +406 val_406 2010-03-03 22 +401 val_401 2010-03-03 22 +114 val_114 2010-03-03 22 +258 val_258 2010-03-03 22 +90 val_90 2010-03-03 22 +203 val_203 2010-03-03 22 +262 val_262 2010-03-03 22 +348 val_348 2010-03-03 22 +424 val_424 2010-03-03 22 +12 val_12 2010-03-03 22 +396 val_396 2010-03-03 22 +201 val_201 2010-03-03 22 +217 val_217 2010-03-03 22 +164 val_164 2010-03-03 22 +431 val_431 2010-03-03 22 +454 val_454 2010-03-03 22 +478 val_478 2010-03-03 22 +298 val_298 2010-03-03 22 +125 val_125 2010-03-03 22 +431 val_431 2010-03-03 22 +164 val_164 2010-03-03 22 +424 val_424 2010-03-03 22 +187 val_187 2010-03-03 22 +382 val_382 2010-03-03 22 +5 val_5 2010-03-03 22 +70 val_70 2010-03-03 22 +397 val_397 2010-03-03 22 +480 val_480 2010-03-03 22 +291 val_291 2010-03-03 22 +24 val_24 2010-03-03 22 +351 val_351 2010-03-03 22 +255 val_255 2010-03-03 22 +104 val_104 2010-03-03 22 +70 val_70 2010-03-03 22 +163 val_163 2010-03-03 22 +438 val_438 2010-03-03 22 +119 val_119 2010-03-03 22 +414 val_414 2010-03-03 22 +200 val_200 2010-03-03 22 +491 val_491 2010-03-03 22 +237 val_237 2010-03-03 22 +439 val_439 2010-03-03 22 +360 val_360 2010-03-03 22 +248 val_248 2010-03-03 22 +479 val_479 2010-03-03 22 +305 val_305 2010-03-03 22 +417 val_417 2010-03-03 22 +199 val_199 2010-03-03 22 +444 val_444 2010-03-03 22 +120 val_120 2010-03-03 22 +429 val_429 2010-03-03 22 +169 val_169 2010-03-03 22 +443 val_443 2010-03-03 22 +323 val_323 2010-03-03 22 +325 val_325 2010-03-03 22 +277 val_277 2010-03-03 22 +230 val_230 2010-03-03 22 +478 val_478 2010-03-03 22 +178 val_178 2010-03-03 22 +468 val_468 2010-03-03 22 +310 val_310 2010-03-03 22 +317 val_317 2010-03-03 22 +333 val_333 2010-03-03 22 +493 val_493 2010-03-03 22 +460 val_460 2010-03-03 22 +207 val_207 2010-03-03 22 +249 val_249 2010-03-03 22 +265 val_265 2010-03-03 22 +480 val_480 2010-03-03 22 +83 val_83 2010-03-03 22 +136 val_136 2010-03-03 22 +353 val_353 2010-03-03 22 +172 val_172 2010-03-03 22 +214 val_214 2010-03-03 22 +462 val_462 2010-03-03 22 +233 val_233 2010-03-03 22 +406 val_406 2010-03-03 22 +133 val_133 2010-03-03 22 +175 val_175 2010-03-03 22 +189 val_189 2010-03-03 22 +454 val_454 2010-03-03 22 +375 val_375 2010-03-03 22 +401 val_401 2010-03-03 22 +421 val_421 2010-03-03 22 +407 val_407 2010-03-03 22 +384 val_384 2010-03-03 22 +256 val_256 2010-03-03 22 +26 val_26 2010-03-03 22 +134 val_134 2010-03-03 22 +67 val_67 2010-03-03 22 +384 val_384 2010-03-03 22 +379 val_379 2010-03-03 22 +18 val_18 2010-03-03 22 +462 val_462 2010-03-03 22 +492 val_492 2010-03-03 22 +100 val_100 2010-03-03 22 +298 val_298 2010-03-03 22 +9 val_9 2010-03-03 22 +341 val_341 2010-03-03 22 +498 val_498 2010-03-03 22 +146 val_146 2010-03-03 22 +458 val_458 2010-03-03 22 +362 val_362 2010-03-03 22 +186 val_186 2010-03-03 22 +285 val_285 2010-03-03 22 +348 val_348 2010-03-03 22 +167 val_167 2010-03-03 22 +18 val_18 2010-03-03 22 +273 val_273 2010-03-03 22 +183 val_183 2010-03-03 22 +281 val_281 2010-03-03 22 +344 val_344 2010-03-03 22 +97 val_97 2010-03-03 22 +469 val_469 2010-03-03 22 +315 val_315 2010-03-03 22 +84 val_84 2010-03-03 22 +28 val_28 2010-03-03 22 +37 val_37 2010-03-03 22 +448 val_448 2010-03-03 22 +152 val_152 2010-03-03 22 +348 val_348 2010-03-03 22 +307 val_307 2010-03-03 22 +194 val_194 2010-03-03 22 +414 val_414 2010-03-03 22 +477 val_477 2010-03-03 22 +222 val_222 2010-03-03 22 +126 val_126 2010-03-03 22 +90 val_90 2010-03-03 22 +169 val_169 2010-03-03 22 +403 val_403 2010-03-03 22 +400 val_400 2010-03-03 22 +200 val_200 2010-03-03 22 +97 val_97 2010-03-03 22 +238 val_238 2010-03-03 24 +86 val_86 2010-03-03 24 +311 val_311 2010-03-03 24 +27 val_27 2010-03-03 24 +165 val_165 2010-03-03 24 +409 val_409 2010-03-03 24 +255 val_255 2010-03-03 24 +278 val_278 2010-03-03 24 +98 val_98 2010-03-03 24 +484 val_484 2010-03-03 24 +265 val_265 2010-03-03 24 +193 val_193 2010-03-03 24 +401 val_401 2010-03-03 24 +150 val_150 2010-03-03 24 +273 val_273 2010-03-03 24 +224 val_224 2010-03-03 24 +369 val_369 2010-03-03 24 +66 val_66 2010-03-03 24 +128 val_128 2010-03-03 24 +213 val_213 2010-03-03 24 +146 val_146 2010-03-03 24 +406 val_406 2010-03-03 24 +429 val_429 2010-03-03 24 +374 val_374 2010-03-03 24 +152 val_152 2010-03-03 24 +469 val_469 2010-03-03 24 +145 val_145 2010-03-03 24 +495 val_495 2010-03-03 24 +37 val_37 2010-03-03 24 +327 val_327 2010-03-03 24 +281 val_281 2010-03-03 24 +277 val_277 2010-03-03 24 +209 val_209 2010-03-03 24 +15 val_15 2010-03-03 24 +82 val_82 2010-03-03 24 +403 val_403 2010-03-03 24 +166 val_166 2010-03-03 24 +417 val_417 2010-03-03 24 +430 val_430 2010-03-03 24 +252 val_252 2010-03-03 24 +292 val_292 2010-03-03 24 +219 val_219 2010-03-03 24 +287 val_287 2010-03-03 24 +153 val_153 2010-03-03 24 +193 val_193 2010-03-03 24 +338 val_338 2010-03-03 24 +446 val_446 2010-03-03 24 +459 val_459 2010-03-03 24 +394 val_394 2010-03-03 24 +237 val_237 2010-03-03 24 +482 val_482 2010-03-03 24 +174 val_174 2010-03-03 24 +413 val_413 2010-03-03 24 +494 val_494 2010-03-03 24 +207 val_207 2010-03-03 24 +199 val_199 2010-03-03 24 +466 val_466 2010-03-03 24 +208 val_208 2010-03-03 24 +174 val_174 2010-03-03 24 +399 val_399 2010-03-03 24 +396 val_396 2010-03-03 24 +247 val_247 2010-03-03 24 +417 val_417 2010-03-03 24 +489 val_489 2010-03-03 24 +162 val_162 2010-03-03 24 +377 val_377 2010-03-03 24 +397 val_397 2010-03-03 24 +309 val_309 2010-03-03 24 +365 val_365 2010-03-03 24 +266 val_266 2010-03-03 24 +439 val_439 2010-03-03 24 +342 val_342 2010-03-03 24 +367 val_367 2010-03-03 24 +325 val_325 2010-03-03 24 +167 val_167 2010-03-03 24 +195 val_195 2010-03-03 24 +475 val_475 2010-03-03 24 +17 val_17 2010-03-03 24 +113 val_113 2010-03-03 24 +155 val_155 2010-03-03 24 +203 val_203 2010-03-03 24 +339 val_339 2010-03-03 24 +0 val_0 2010-03-03 24 +455 val_455 2010-03-03 24 +128 val_128 2010-03-03 24 +311 val_311 2010-03-03 24 +316 val_316 2010-03-03 24 +57 val_57 2010-03-03 24 +302 val_302 2010-03-03 24 +205 val_205 2010-03-03 24 +149 val_149 2010-03-03 24 +438 val_438 2010-03-03 24 +345 val_345 2010-03-03 24 +129 val_129 2010-03-03 24 +170 val_170 2010-03-03 24 +20 val_20 2010-03-03 24 +489 val_489 2010-03-03 24 +157 val_157 2010-03-03 24 +378 val_378 2010-03-03 24 +221 val_221 2010-03-03 24 +92 val_92 2010-03-03 24 +111 val_111 2010-03-03 24 +47 val_47 2010-03-03 24 +72 val_72 2010-03-03 24 +4 val_4 2010-03-03 24 +280 val_280 2010-03-03 24 +35 val_35 2010-03-03 24 +427 val_427 2010-03-03 24 +277 val_277 2010-03-03 24 +208 val_208 2010-03-03 24 +356 val_356 2010-03-03 24 +399 val_399 2010-03-03 24 +169 val_169 2010-03-03 24 +382 val_382 2010-03-03 24 +498 val_498 2010-03-03 24 +125 val_125 2010-03-03 24 +386 val_386 2010-03-03 24 +437 val_437 2010-03-03 24 +469 val_469 2010-03-03 24 +192 val_192 2010-03-03 24 +286 val_286 2010-03-03 24 +187 val_187 2010-03-03 24 +176 val_176 2010-03-03 24 +54 val_54 2010-03-03 24 +459 val_459 2010-03-03 24 +51 val_51 2010-03-03 24 +138 val_138 2010-03-03 24 +103 val_103 2010-03-03 24 +239 val_239 2010-03-03 24 +213 val_213 2010-03-03 24 +216 val_216 2010-03-03 24 +430 val_430 2010-03-03 24 +278 val_278 2010-03-03 24 +176 val_176 2010-03-03 24 +289 val_289 2010-03-03 24 +221 val_221 2010-03-03 24 +65 val_65 2010-03-03 24 +318 val_318 2010-03-03 24 +332 val_332 2010-03-03 24 +311 val_311 2010-03-03 24 +275 val_275 2010-03-03 24 +137 val_137 2010-03-03 24 +241 val_241 2010-03-03 24 +83 val_83 2010-03-03 24 +333 val_333 2010-03-03 24 +180 val_180 2010-03-03 24 +284 val_284 2010-03-03 24 +12 val_12 2010-03-03 24 +230 val_230 2010-03-03 24 +181 val_181 2010-03-03 24 +67 val_67 2010-03-03 24 +260 val_260 2010-03-03 24 +404 val_404 2010-03-03 24 +384 val_384 2010-03-03 24 +489 val_489 2010-03-03 24 +353 val_353 2010-03-03 24 +373 val_373 2010-03-03 24 +272 val_272 2010-03-03 24 +138 val_138 2010-03-03 24 +217 val_217 2010-03-03 24 +84 val_84 2010-03-03 24 +348 val_348 2010-03-03 24 +466 val_466 2010-03-03 24 +58 val_58 2010-03-03 24 +8 val_8 2010-03-03 24 +411 val_411 2010-03-03 24 +230 val_230 2010-03-03 24 +208 val_208 2010-03-03 24 +348 val_348 2010-03-03 24 +24 val_24 2010-03-03 24 +463 val_463 2010-03-03 24 +431 val_431 2010-03-03 24 +179 val_179 2010-03-03 24 +172 val_172 2010-03-03 24 +42 val_42 2010-03-03 24 +129 val_129 2010-03-03 24 +158 val_158 2010-03-03 24 +119 val_119 2010-03-03 24 +496 val_496 2010-03-03 24 +0 val_0 2010-03-03 24 +322 val_322 2010-03-03 24 +197 val_197 2010-03-03 24 +468 val_468 2010-03-03 24 +393 val_393 2010-03-03 24 +454 val_454 2010-03-03 24 +100 val_100 2010-03-03 24 +298 val_298 2010-03-03 24 +199 val_199 2010-03-03 24 +191 val_191 2010-03-03 24 +418 val_418 2010-03-03 24 +96 val_96 2010-03-03 24 +26 val_26 2010-03-03 24 +165 val_165 2010-03-03 24 +327 val_327 2010-03-03 24 +230 val_230 2010-03-03 24 +205 val_205 2010-03-03 24 +120 val_120 2010-03-03 24 +131 val_131 2010-03-03 24 +51 val_51 2010-03-03 24 +404 val_404 2010-03-03 24 +43 val_43 2010-03-03 24 +436 val_436 2010-03-03 24 +156 val_156 2010-03-03 24 +469 val_469 2010-03-03 24 +468 val_468 2010-03-03 24 +308 val_308 2010-03-03 24 +95 val_95 2010-03-03 24 +196 val_196 2010-03-03 24 +288 val_288 2010-03-03 24 +481 val_481 2010-03-03 24 +457 val_457 2010-03-03 24 +98 val_98 2010-03-03 24 +282 val_282 2010-03-03 24 +197 val_197 2010-03-03 24 +187 val_187 2010-03-03 24 +318 val_318 2010-03-03 24 +318 val_318 2010-03-03 24 +409 val_409 2010-03-03 24 +470 val_470 2010-03-03 24 +137 val_137 2010-03-03 24 +369 val_369 2010-03-03 24 +316 val_316 2010-03-03 24 +169 val_169 2010-03-03 24 +413 val_413 2010-03-03 24 +85 val_85 2010-03-03 24 +77 val_77 2010-03-03 24 +0 val_0 2010-03-03 24 +490 val_490 2010-03-03 24 +87 val_87 2010-03-03 24 +364 val_364 2010-03-03 24 +179 val_179 2010-03-03 24 +118 val_118 2010-03-03 24 +134 val_134 2010-03-03 24 +395 val_395 2010-03-03 24 +282 val_282 2010-03-03 24 +138 val_138 2010-03-03 24 +238 val_238 2010-03-03 24 +419 val_419 2010-03-03 24 +15 val_15 2010-03-03 24 +118 val_118 2010-03-03 24 +72 val_72 2010-03-03 24 +90 val_90 2010-03-03 24 +307 val_307 2010-03-03 24 +19 val_19 2010-03-03 24 +435 val_435 2010-03-03 24 +10 val_10 2010-03-03 24 +277 val_277 2010-03-03 24 +273 val_273 2010-03-03 24 +306 val_306 2010-03-03 24 +224 val_224 2010-03-03 24 +309 val_309 2010-03-03 24 +389 val_389 2010-03-03 24 +327 val_327 2010-03-03 24 +242 val_242 2010-03-03 24 +369 val_369 2010-03-03 24 +392 val_392 2010-03-03 24 +272 val_272 2010-03-03 24 +331 val_331 2010-03-03 24 +401 val_401 2010-03-03 24 +242 val_242 2010-03-03 24 +452 val_452 2010-03-03 24 +177 val_177 2010-03-03 24 +226 val_226 2010-03-03 24 +5 val_5 2010-03-03 24 +497 val_497 2010-03-03 24 +402 val_402 2010-03-03 24 +396 val_396 2010-03-03 24 +317 val_317 2010-03-03 24 +395 val_395 2010-03-03 24 +58 val_58 2010-03-03 24 +35 val_35 2010-03-03 24 +336 val_336 2010-03-03 24 +95 val_95 2010-03-03 24 +11 val_11 2010-03-03 24 +168 val_168 2010-03-03 24 +34 val_34 2010-03-03 24 +229 val_229 2010-03-03 24 +233 val_233 2010-03-03 24 +143 val_143 2010-03-03 24 +472 val_472 2010-03-03 24 +322 val_322 2010-03-03 24 +498 val_498 2010-03-03 24 +160 val_160 2010-03-03 24 +195 val_195 2010-03-03 24 +42 val_42 2010-03-03 24 +321 val_321 2010-03-03 24 +430 val_430 2010-03-03 24 +119 val_119 2010-03-03 24 +489 val_489 2010-03-03 24 +458 val_458 2010-03-03 24 +78 val_78 2010-03-03 24 +76 val_76 2010-03-03 24 +41 val_41 2010-03-03 24 +223 val_223 2010-03-03 24 +492 val_492 2010-03-03 24 +149 val_149 2010-03-03 24 +449 val_449 2010-03-03 24 +218 val_218 2010-03-03 24 +228 val_228 2010-03-03 24 +138 val_138 2010-03-03 24 +453 val_453 2010-03-03 24 +30 val_30 2010-03-03 24 +209 val_209 2010-03-03 24 +64 val_64 2010-03-03 24 +468 val_468 2010-03-03 24 +76 val_76 2010-03-03 24 +74 val_74 2010-03-03 24 +342 val_342 2010-03-03 24 +69 val_69 2010-03-03 24 +230 val_230 2010-03-03 24 +33 val_33 2010-03-03 24 +368 val_368 2010-03-03 24 +103 val_103 2010-03-03 24 +296 val_296 2010-03-03 24 +113 val_113 2010-03-03 24 +216 val_216 2010-03-03 24 +367 val_367 2010-03-03 24 +344 val_344 2010-03-03 24 +167 val_167 2010-03-03 24 +274 val_274 2010-03-03 24 +219 val_219 2010-03-03 24 +239 val_239 2010-03-03 24 +485 val_485 2010-03-03 24 +116 val_116 2010-03-03 24 +223 val_223 2010-03-03 24 +256 val_256 2010-03-03 24 +263 val_263 2010-03-03 24 +70 val_70 2010-03-03 24 +487 val_487 2010-03-03 24 +480 val_480 2010-03-03 24 +401 val_401 2010-03-03 24 +288 val_288 2010-03-03 24 +191 val_191 2010-03-03 24 +5 val_5 2010-03-03 24 +244 val_244 2010-03-03 24 +438 val_438 2010-03-03 24 +128 val_128 2010-03-03 24 +467 val_467 2010-03-03 24 +432 val_432 2010-03-03 24 +202 val_202 2010-03-03 24 +316 val_316 2010-03-03 24 +229 val_229 2010-03-03 24 +469 val_469 2010-03-03 24 +463 val_463 2010-03-03 24 +280 val_280 2010-03-03 24 +2 val_2 2010-03-03 24 +35 val_35 2010-03-03 24 +283 val_283 2010-03-03 24 +331 val_331 2010-03-03 24 +235 val_235 2010-03-03 24 +80 val_80 2010-03-03 24 +44 val_44 2010-03-03 24 +193 val_193 2010-03-03 24 +321 val_321 2010-03-03 24 +335 val_335 2010-03-03 24 +104 val_104 2010-03-03 24 +466 val_466 2010-03-03 24 +366 val_366 2010-03-03 24 +175 val_175 2010-03-03 24 +403 val_403 2010-03-03 24 +483 val_483 2010-03-03 24 +53 val_53 2010-03-03 24 +105 val_105 2010-03-03 24 +257 val_257 2010-03-03 24 +406 val_406 2010-03-03 24 +409 val_409 2010-03-03 24 +190 val_190 2010-03-03 24 +406 val_406 2010-03-03 24 +401 val_401 2010-03-03 24 +114 val_114 2010-03-03 24 +258 val_258 2010-03-03 24 +90 val_90 2010-03-03 24 +203 val_203 2010-03-03 24 +262 val_262 2010-03-03 24 +348 val_348 2010-03-03 24 +424 val_424 2010-03-03 24 +12 val_12 2010-03-03 24 +396 val_396 2010-03-03 24 +201 val_201 2010-03-03 24 +217 val_217 2010-03-03 24 +164 val_164 2010-03-03 24 +431 val_431 2010-03-03 24 +454 val_454 2010-03-03 24 +478 val_478 2010-03-03 24 +298 val_298 2010-03-03 24 +125 val_125 2010-03-03 24 +431 val_431 2010-03-03 24 +164 val_164 2010-03-03 24 +424 val_424 2010-03-03 24 +187 val_187 2010-03-03 24 +382 val_382 2010-03-03 24 +5 val_5 2010-03-03 24 +70 val_70 2010-03-03 24 +397 val_397 2010-03-03 24 +480 val_480 2010-03-03 24 +291 val_291 2010-03-03 24 +24 val_24 2010-03-03 24 +351 val_351 2010-03-03 24 +255 val_255 2010-03-03 24 +104 val_104 2010-03-03 24 +70 val_70 2010-03-03 24 +163 val_163 2010-03-03 24 +438 val_438 2010-03-03 24 +119 val_119 2010-03-03 24 +414 val_414 2010-03-03 24 +200 val_200 2010-03-03 24 +491 val_491 2010-03-03 24 +237 val_237 2010-03-03 24 +439 val_439 2010-03-03 24 +360 val_360 2010-03-03 24 +248 val_248 2010-03-03 24 +479 val_479 2010-03-03 24 +305 val_305 2010-03-03 24 +417 val_417 2010-03-03 24 +199 val_199 2010-03-03 24 +444 val_444 2010-03-03 24 +120 val_120 2010-03-03 24 +429 val_429 2010-03-03 24 +169 val_169 2010-03-03 24 +443 val_443 2010-03-03 24 +323 val_323 2010-03-03 24 +325 val_325 2010-03-03 24 +277 val_277 2010-03-03 24 +230 val_230 2010-03-03 24 +478 val_478 2010-03-03 24 +178 val_178 2010-03-03 24 +468 val_468 2010-03-03 24 +310 val_310 2010-03-03 24 +317 val_317 2010-03-03 24 +333 val_333 2010-03-03 24 +493 val_493 2010-03-03 24 +460 val_460 2010-03-03 24 +207 val_207 2010-03-03 24 +249 val_249 2010-03-03 24 +265 val_265 2010-03-03 24 +480 val_480 2010-03-03 24 +83 val_83 2010-03-03 24 +136 val_136 2010-03-03 24 +353 val_353 2010-03-03 24 +172 val_172 2010-03-03 24 +214 val_214 2010-03-03 24 +462 val_462 2010-03-03 24 +233 val_233 2010-03-03 24 +406 val_406 2010-03-03 24 +133 val_133 2010-03-03 24 +175 val_175 2010-03-03 24 +189 val_189 2010-03-03 24 +454 val_454 2010-03-03 24 +375 val_375 2010-03-03 24 +401 val_401 2010-03-03 24 +421 val_421 2010-03-03 24 +407 val_407 2010-03-03 24 +384 val_384 2010-03-03 24 +256 val_256 2010-03-03 24 +26 val_26 2010-03-03 24 +134 val_134 2010-03-03 24 +67 val_67 2010-03-03 24 +384 val_384 2010-03-03 24 +379 val_379 2010-03-03 24 +18 val_18 2010-03-03 24 +462 val_462 2010-03-03 24 +492 val_492 2010-03-03 24 +100 val_100 2010-03-03 24 +298 val_298 2010-03-03 24 +9 val_9 2010-03-03 24 +341 val_341 2010-03-03 24 +498 val_498 2010-03-03 24 +146 val_146 2010-03-03 24 +458 val_458 2010-03-03 24 +362 val_362 2010-03-03 24 +186 val_186 2010-03-03 24 +285 val_285 2010-03-03 24 +348 val_348 2010-03-03 24 +167 val_167 2010-03-03 24 +18 val_18 2010-03-03 24 +273 val_273 2010-03-03 24 +183 val_183 2010-03-03 24 +281 val_281 2010-03-03 24 +344 val_344 2010-03-03 24 +97 val_97 2010-03-03 24 +469 val_469 2010-03-03 24 +315 val_315 2010-03-03 24 +84 val_84 2010-03-03 24 +28 val_28 2010-03-03 24 +37 val_37 2010-03-03 24 +448 val_448 2010-03-03 24 +152 val_152 2010-03-03 24 +348 val_348 2010-03-03 24 +307 val_307 2010-03-03 24 +194 val_194 2010-03-03 24 +414 val_414 2010-03-03 24 +477 val_477 2010-03-03 24 +222 val_222 2010-03-03 24 +126 val_126 2010-03-03 24 +90 val_90 2010-03-03 24 +169 val_169 2010-03-03 24 +403 val_403 2010-03-03 24 +400 val_400 2010-03-03 24 +200 val_200 2010-03-03 24 +97 val_97 2010-03-03 24 +238 val_238 2010-03-03 24 +86 val_86 2010-03-03 24 +311 val_311 2010-03-03 24 +27 val_27 2010-03-03 24 +165 val_165 2010-03-03 24 +409 val_409 2010-03-03 24 +255 val_255 2010-03-03 24 +278 val_278 2010-03-03 24 +98 val_98 2010-03-03 24 +484 val_484 2010-03-03 24 +265 val_265 2010-03-03 24 +193 val_193 2010-03-03 24 +401 val_401 2010-03-03 24 +150 val_150 2010-03-03 24 +273 val_273 2010-03-03 24 +224 val_224 2010-03-03 24 +369 val_369 2010-03-03 24 +66 val_66 2010-03-03 24 +128 val_128 2010-03-03 24 +213 val_213 2010-03-03 24 +146 val_146 2010-03-03 24 +406 val_406 2010-03-03 24 +429 val_429 2010-03-03 24 +374 val_374 2010-03-03 24 +152 val_152 2010-03-03 24 +469 val_469 2010-03-03 24 +145 val_145 2010-03-03 24 +495 val_495 2010-03-03 24 +37 val_37 2010-03-03 24 +327 val_327 2010-03-03 24 +281 val_281 2010-03-03 24 +277 val_277 2010-03-03 24 +209 val_209 2010-03-03 24 +15 val_15 2010-03-03 24 +82 val_82 2010-03-03 24 +403 val_403 2010-03-03 24 +166 val_166 2010-03-03 24 +417 val_417 2010-03-03 24 +430 val_430 2010-03-03 24 +252 val_252 2010-03-03 24 +292 val_292 2010-03-03 24 +219 val_219 2010-03-03 24 +287 val_287 2010-03-03 24 +153 val_153 2010-03-03 24 +193 val_193 2010-03-03 24 +338 val_338 2010-03-03 24 +446 val_446 2010-03-03 24 +459 val_459 2010-03-03 24 +394 val_394 2010-03-03 24 +237 val_237 2010-03-03 24 +482 val_482 2010-03-03 24 +174 val_174 2010-03-03 24 +413 val_413 2010-03-03 24 +494 val_494 2010-03-03 24 +207 val_207 2010-03-03 24 +199 val_199 2010-03-03 24 +466 val_466 2010-03-03 24 +208 val_208 2010-03-03 24 +174 val_174 2010-03-03 24 +399 val_399 2010-03-03 24 +396 val_396 2010-03-03 24 +247 val_247 2010-03-03 24 +417 val_417 2010-03-03 24 +489 val_489 2010-03-03 24 +162 val_162 2010-03-03 24 +377 val_377 2010-03-03 24 +397 val_397 2010-03-03 24 +309 val_309 2010-03-03 24 +365 val_365 2010-03-03 24 +266 val_266 2010-03-03 24 +439 val_439 2010-03-03 24 +342 val_342 2010-03-03 24 +367 val_367 2010-03-03 24 +325 val_325 2010-03-03 24 +167 val_167 2010-03-03 24 +195 val_195 2010-03-03 24 +475 val_475 2010-03-03 24 +17 val_17 2010-03-03 24 +113 val_113 2010-03-03 24 +155 val_155 2010-03-03 24 +203 val_203 2010-03-03 24 +339 val_339 2010-03-03 24 +0 val_0 2010-03-03 24 +455 val_455 2010-03-03 24 +128 val_128 2010-03-03 24 +311 val_311 2010-03-03 24 +316 val_316 2010-03-03 24 +57 val_57 2010-03-03 24 +302 val_302 2010-03-03 24 +205 val_205 2010-03-03 24 +149 val_149 2010-03-03 24 +438 val_438 2010-03-03 24 +345 val_345 2010-03-03 24 +129 val_129 2010-03-03 24 +170 val_170 2010-03-03 24 +20 val_20 2010-03-03 24 +489 val_489 2010-03-03 24 +157 val_157 2010-03-03 24 +378 val_378 2010-03-03 24 +221 val_221 2010-03-03 24 +92 val_92 2010-03-03 24 +111 val_111 2010-03-03 24 +47 val_47 2010-03-03 24 +72 val_72 2010-03-03 24 +4 val_4 2010-03-03 24 +280 val_280 2010-03-03 24 +35 val_35 2010-03-03 24 +427 val_427 2010-03-03 24 +277 val_277 2010-03-03 24 +208 val_208 2010-03-03 24 +356 val_356 2010-03-03 24 +399 val_399 2010-03-03 24 +169 val_169 2010-03-03 24 +382 val_382 2010-03-03 24 +498 val_498 2010-03-03 24 +125 val_125 2010-03-03 24 +386 val_386 2010-03-03 24 +437 val_437 2010-03-03 24 +469 val_469 2010-03-03 24 +192 val_192 2010-03-03 24 +286 val_286 2010-03-03 24 +187 val_187 2010-03-03 24 +176 val_176 2010-03-03 24 +54 val_54 2010-03-03 24 +459 val_459 2010-03-03 24 +51 val_51 2010-03-03 24 +138 val_138 2010-03-03 24 +103 val_103 2010-03-03 24 +239 val_239 2010-03-03 24 +213 val_213 2010-03-03 24 +216 val_216 2010-03-03 24 +430 val_430 2010-03-03 24 +278 val_278 2010-03-03 24 +176 val_176 2010-03-03 24 +289 val_289 2010-03-03 24 +221 val_221 2010-03-03 24 +65 val_65 2010-03-03 24 +318 val_318 2010-03-03 24 +332 val_332 2010-03-03 24 +311 val_311 2010-03-03 24 +275 val_275 2010-03-03 24 +137 val_137 2010-03-03 24 +241 val_241 2010-03-03 24 +83 val_83 2010-03-03 24 +333 val_333 2010-03-03 24 +180 val_180 2010-03-03 24 +284 val_284 2010-03-03 24 +12 val_12 2010-03-03 24 +230 val_230 2010-03-03 24 +181 val_181 2010-03-03 24 +67 val_67 2010-03-03 24 +260 val_260 2010-03-03 24 +404 val_404 2010-03-03 24 +384 val_384 2010-03-03 24 +489 val_489 2010-03-03 24 +353 val_353 2010-03-03 24 +373 val_373 2010-03-03 24 +272 val_272 2010-03-03 24 +138 val_138 2010-03-03 24 +217 val_217 2010-03-03 24 +84 val_84 2010-03-03 24 +348 val_348 2010-03-03 24 +466 val_466 2010-03-03 24 +58 val_58 2010-03-03 24 +8 val_8 2010-03-03 24 +411 val_411 2010-03-03 24 +230 val_230 2010-03-03 24 +208 val_208 2010-03-03 24 +348 val_348 2010-03-03 24 +24 val_24 2010-03-03 24 +463 val_463 2010-03-03 24 +431 val_431 2010-03-03 24 +179 val_179 2010-03-03 24 +172 val_172 2010-03-03 24 +42 val_42 2010-03-03 24 +129 val_129 2010-03-03 24 +158 val_158 2010-03-03 24 +119 val_119 2010-03-03 24 +496 val_496 2010-03-03 24 +0 val_0 2010-03-03 24 +322 val_322 2010-03-03 24 +197 val_197 2010-03-03 24 +468 val_468 2010-03-03 24 +393 val_393 2010-03-03 24 +454 val_454 2010-03-03 24 +100 val_100 2010-03-03 24 +298 val_298 2010-03-03 24 +199 val_199 2010-03-03 24 +191 val_191 2010-03-03 24 +418 val_418 2010-03-03 24 +96 val_96 2010-03-03 24 +26 val_26 2010-03-03 24 +165 val_165 2010-03-03 24 +327 val_327 2010-03-03 24 +230 val_230 2010-03-03 24 +205 val_205 2010-03-03 24 +120 val_120 2010-03-03 24 +131 val_131 2010-03-03 24 +51 val_51 2010-03-03 24 +404 val_404 2010-03-03 24 +43 val_43 2010-03-03 24 +436 val_436 2010-03-03 24 +156 val_156 2010-03-03 24 +469 val_469 2010-03-03 24 +468 val_468 2010-03-03 24 +308 val_308 2010-03-03 24 +95 val_95 2010-03-03 24 +196 val_196 2010-03-03 24 +288 val_288 2010-03-03 24 +481 val_481 2010-03-03 24 +457 val_457 2010-03-03 24 +98 val_98 2010-03-03 24 +282 val_282 2010-03-03 24 +197 val_197 2010-03-03 24 +187 val_187 2010-03-03 24 +318 val_318 2010-03-03 24 +318 val_318 2010-03-03 24 +409 val_409 2010-03-03 24 +470 val_470 2010-03-03 24 +137 val_137 2010-03-03 24 +369 val_369 2010-03-03 24 +316 val_316 2010-03-03 24 +169 val_169 2010-03-03 24 +413 val_413 2010-03-03 24 +85 val_85 2010-03-03 24 +77 val_77 2010-03-03 24 +0 val_0 2010-03-03 24 +490 val_490 2010-03-03 24 +87 val_87 2010-03-03 24 +364 val_364 2010-03-03 24 +179 val_179 2010-03-03 24 +118 val_118 2010-03-03 24 +134 val_134 2010-03-03 24 +395 val_395 2010-03-03 24 +282 val_282 2010-03-03 24 +138 val_138 2010-03-03 24 +238 val_238 2010-03-03 24 +419 val_419 2010-03-03 24 +15 val_15 2010-03-03 24 +118 val_118 2010-03-03 24 +72 val_72 2010-03-03 24 +90 val_90 2010-03-03 24 +307 val_307 2010-03-03 24 +19 val_19 2010-03-03 24 +435 val_435 2010-03-03 24 +10 val_10 2010-03-03 24 +277 val_277 2010-03-03 24 +273 val_273 2010-03-03 24 +306 val_306 2010-03-03 24 +224 val_224 2010-03-03 24 +309 val_309 2010-03-03 24 +389 val_389 2010-03-03 24 +327 val_327 2010-03-03 24 +242 val_242 2010-03-03 24 +369 val_369 2010-03-03 24 +392 val_392 2010-03-03 24 +272 val_272 2010-03-03 24 +331 val_331 2010-03-03 24 +401 val_401 2010-03-03 24 +242 val_242 2010-03-03 24 +452 val_452 2010-03-03 24 +177 val_177 2010-03-03 24 +226 val_226 2010-03-03 24 +5 val_5 2010-03-03 24 +497 val_497 2010-03-03 24 +402 val_402 2010-03-03 24 +396 val_396 2010-03-03 24 +317 val_317 2010-03-03 24 +395 val_395 2010-03-03 24 +58 val_58 2010-03-03 24 +35 val_35 2010-03-03 24 +336 val_336 2010-03-03 24 +95 val_95 2010-03-03 24 +11 val_11 2010-03-03 24 +168 val_168 2010-03-03 24 +34 val_34 2010-03-03 24 +229 val_229 2010-03-03 24 +233 val_233 2010-03-03 24 +143 val_143 2010-03-03 24 +472 val_472 2010-03-03 24 +322 val_322 2010-03-03 24 +498 val_498 2010-03-03 24 +160 val_160 2010-03-03 24 +195 val_195 2010-03-03 24 +42 val_42 2010-03-03 24 +321 val_321 2010-03-03 24 +430 val_430 2010-03-03 24 +119 val_119 2010-03-03 24 +489 val_489 2010-03-03 24 +458 val_458 2010-03-03 24 +78 val_78 2010-03-03 24 +76 val_76 2010-03-03 24 +41 val_41 2010-03-03 24 +223 val_223 2010-03-03 24 +492 val_492 2010-03-03 24 +149 val_149 2010-03-03 24 +449 val_449 2010-03-03 24 +218 val_218 2010-03-03 24 +228 val_228 2010-03-03 24 +138 val_138 2010-03-03 24 +453 val_453 2010-03-03 24 +30 val_30 2010-03-03 24 +209 val_209 2010-03-03 24 +64 val_64 2010-03-03 24 +468 val_468 2010-03-03 24 +76 val_76 2010-03-03 24 +74 val_74 2010-03-03 24 +342 val_342 2010-03-03 24 +69 val_69 2010-03-03 24 +230 val_230 2010-03-03 24 +33 val_33 2010-03-03 24 +368 val_368 2010-03-03 24 +103 val_103 2010-03-03 24 +296 val_296 2010-03-03 24 +113 val_113 2010-03-03 24 +216 val_216 2010-03-03 24 +367 val_367 2010-03-03 24 +344 val_344 2010-03-03 24 +167 val_167 2010-03-03 24 +274 val_274 2010-03-03 24 +219 val_219 2010-03-03 24 +239 val_239 2010-03-03 24 +485 val_485 2010-03-03 24 +116 val_116 2010-03-03 24 +223 val_223 2010-03-03 24 +256 val_256 2010-03-03 24 +263 val_263 2010-03-03 24 +70 val_70 2010-03-03 24 +487 val_487 2010-03-03 24 +480 val_480 2010-03-03 24 +401 val_401 2010-03-03 24 +288 val_288 2010-03-03 24 +191 val_191 2010-03-03 24 +5 val_5 2010-03-03 24 +244 val_244 2010-03-03 24 +438 val_438 2010-03-03 24 +128 val_128 2010-03-03 24 +467 val_467 2010-03-03 24 +432 val_432 2010-03-03 24 +202 val_202 2010-03-03 24 +316 val_316 2010-03-03 24 +229 val_229 2010-03-03 24 +469 val_469 2010-03-03 24 +463 val_463 2010-03-03 24 +280 val_280 2010-03-03 24 +2 val_2 2010-03-03 24 +35 val_35 2010-03-03 24 +283 val_283 2010-03-03 24 +331 val_331 2010-03-03 24 +235 val_235 2010-03-03 24 +80 val_80 2010-03-03 24 +44 val_44 2010-03-03 24 +193 val_193 2010-03-03 24 +321 val_321 2010-03-03 24 +335 val_335 2010-03-03 24 +104 val_104 2010-03-03 24 +466 val_466 2010-03-03 24 +366 val_366 2010-03-03 24 +175 val_175 2010-03-03 24 +403 val_403 2010-03-03 24 +483 val_483 2010-03-03 24 +53 val_53 2010-03-03 24 +105 val_105 2010-03-03 24 +257 val_257 2010-03-03 24 +406 val_406 2010-03-03 24 +409 val_409 2010-03-03 24 +190 val_190 2010-03-03 24 +406 val_406 2010-03-03 24 +401 val_401 2010-03-03 24 +114 val_114 2010-03-03 24 +258 val_258 2010-03-03 24 +90 val_90 2010-03-03 24 +203 val_203 2010-03-03 24 +262 val_262 2010-03-03 24 +348 val_348 2010-03-03 24 +424 val_424 2010-03-03 24 +12 val_12 2010-03-03 24 +396 val_396 2010-03-03 24 +201 val_201 2010-03-03 24 +217 val_217 2010-03-03 24 +164 val_164 2010-03-03 24 +431 val_431 2010-03-03 24 +454 val_454 2010-03-03 24 +478 val_478 2010-03-03 24 +298 val_298 2010-03-03 24 +125 val_125 2010-03-03 24 +431 val_431 2010-03-03 24 +164 val_164 2010-03-03 24 +424 val_424 2010-03-03 24 +187 val_187 2010-03-03 24 +382 val_382 2010-03-03 24 +5 val_5 2010-03-03 24 +70 val_70 2010-03-03 24 +397 val_397 2010-03-03 24 +480 val_480 2010-03-03 24 +291 val_291 2010-03-03 24 +24 val_24 2010-03-03 24 +351 val_351 2010-03-03 24 +255 val_255 2010-03-03 24 +104 val_104 2010-03-03 24 +70 val_70 2010-03-03 24 +163 val_163 2010-03-03 24 +438 val_438 2010-03-03 24 +119 val_119 2010-03-03 24 +414 val_414 2010-03-03 24 +200 val_200 2010-03-03 24 +491 val_491 2010-03-03 24 +237 val_237 2010-03-03 24 +439 val_439 2010-03-03 24 +360 val_360 2010-03-03 24 +248 val_248 2010-03-03 24 +479 val_479 2010-03-03 24 +305 val_305 2010-03-03 24 +417 val_417 2010-03-03 24 +199 val_199 2010-03-03 24 +444 val_444 2010-03-03 24 +120 val_120 2010-03-03 24 +429 val_429 2010-03-03 24 +169 val_169 2010-03-03 24 +443 val_443 2010-03-03 24 +323 val_323 2010-03-03 24 +325 val_325 2010-03-03 24 +277 val_277 2010-03-03 24 +230 val_230 2010-03-03 24 +478 val_478 2010-03-03 24 +178 val_178 2010-03-03 24 +468 val_468 2010-03-03 24 +310 val_310 2010-03-03 24 +317 val_317 2010-03-03 24 +333 val_333 2010-03-03 24 +493 val_493 2010-03-03 24 +460 val_460 2010-03-03 24 +207 val_207 2010-03-03 24 +249 val_249 2010-03-03 24 +265 val_265 2010-03-03 24 +480 val_480 2010-03-03 24 +83 val_83 2010-03-03 24 +136 val_136 2010-03-03 24 +353 val_353 2010-03-03 24 +172 val_172 2010-03-03 24 +214 val_214 2010-03-03 24 +462 val_462 2010-03-03 24 +233 val_233 2010-03-03 24 +406 val_406 2010-03-03 24 +133 val_133 2010-03-03 24 +175 val_175 2010-03-03 24 +189 val_189 2010-03-03 24 +454 val_454 2010-03-03 24 +375 val_375 2010-03-03 24 +401 val_401 2010-03-03 24 +421 val_421 2010-03-03 24 +407 val_407 2010-03-03 24 +384 val_384 2010-03-03 24 +256 val_256 2010-03-03 24 +26 val_26 2010-03-03 24 +134 val_134 2010-03-03 24 +67 val_67 2010-03-03 24 +384 val_384 2010-03-03 24 +379 val_379 2010-03-03 24 +18 val_18 2010-03-03 24 +462 val_462 2010-03-03 24 +492 val_492 2010-03-03 24 +100 val_100 2010-03-03 24 +298 val_298 2010-03-03 24 +9 val_9 2010-03-03 24 +341 val_341 2010-03-03 24 +498 val_498 2010-03-03 24 +146 val_146 2010-03-03 24 +458 val_458 2010-03-03 24 +362 val_362 2010-03-03 24 +186 val_186 2010-03-03 24 +285 val_285 2010-03-03 24 +348 val_348 2010-03-03 24 +167 val_167 2010-03-03 24 +18 val_18 2010-03-03 24 +273 val_273 2010-03-03 24 +183 val_183 2010-03-03 24 +281 val_281 2010-03-03 24 +344 val_344 2010-03-03 24 +97 val_97 2010-03-03 24 +469 val_469 2010-03-03 24 +315 val_315 2010-03-03 24 +84 val_84 2010-03-03 24 +28 val_28 2010-03-03 24 +37 val_37 2010-03-03 24 +448 val_448 2010-03-03 24 +152 val_152 2010-03-03 24 +348 val_348 2010-03-03 24 +307 val_307 2010-03-03 24 +194 val_194 2010-03-03 24 +414 val_414 2010-03-03 24 +477 val_477 2010-03-03 24 +222 val_222 2010-03-03 24 +126 val_126 2010-03-03 24 +90 val_90 2010-03-03 24 +169 val_169 2010-03-03 24 +403 val_403 2010-03-03 24 +400 val_400 2010-03-03 24 +200 val_200 2010-03-03 24 +97 val_97 2010-03-03 24
Added: hive/branches/spark/ql/src/test/results/clientpositive/spark/load_dyn_part13.q.out URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/spark/load_dyn_part13.q.out?rev=1622504&view=auto ============================================================================== --- hive/branches/spark/ql/src/test/results/clientpositive/spark/load_dyn_part13.q.out (added) +++ hive/branches/spark/ql/src/test/results/clientpositive/spark/load_dyn_part13.q.out Thu Sep 4 15:49:58 2014 @@ -0,0 +1,225 @@ +PREHOOK: query: show partitions srcpart +PREHOOK: type: SHOWPARTITIONS +PREHOOK: Input: default@srcpart +POSTHOOK: query: show partitions srcpart +POSTHOOK: type: SHOWPARTITIONS +POSTHOOK: Input: default@srcpart +ds=2008-04-08/hr=11 +ds=2008-04-08/hr=12 +ds=2008-04-09/hr=11 +ds=2008-04-09/hr=12 +PREHOOK: query: create table if not exists nzhang_part13 like srcpart +PREHOOK: type: CREATETABLE +PREHOOK: Output: database:default +PREHOOK: Output: default@nzhang_part13 +POSTHOOK: query: create table if not exists nzhang_part13 like srcpart +POSTHOOK: type: CREATETABLE +POSTHOOK: Output: database:default +POSTHOOK: Output: default@nzhang_part13 +PREHOOK: query: describe extended nzhang_part13 +PREHOOK: type: DESCTABLE +PREHOOK: Input: default@nzhang_part13 +POSTHOOK: query: describe extended nzhang_part13 +POSTHOOK: type: DESCTABLE +POSTHOOK: Input: default@nzhang_part13 +key string default +value string default +ds string +hr string + +# Partition Information +# col_name data_type comment + +ds string +hr string + +#### A masked pattern was here #### +PREHOOK: query: explain +insert overwrite table nzhang_part13 partition (ds="2010-03-03", hr) +select * from ( + select key, value, '22' + from src + where key < 20 + union all + select key, value, '33' + from src + where key > 20 and key < 40) s +PREHOOK: type: QUERY +POSTHOOK: query: explain +insert overwrite table nzhang_part13 partition (ds="2010-03-03", hr) +select * from ( + select key, value, '22' + from src + where key < 20 + union all + select key, value, '33' + from src + where key > 20 and key < 40) s +POSTHOOK: type: QUERY +STAGE DEPENDENCIES: + Stage-1 is a root stage + Stage-2 depends on stages: Stage-1 + Stage-0 depends on stages: Stage-2 + Stage-3 depends on stages: Stage-0 + Stage-4 depends on stages: Stage-0 + Stage-5 depends on stages: Stage-0 + +STAGE PLANS: + Stage: Stage-1 + Spark + Edges: + Union 2 <- Map 1 (NONE), Map 3 (NONE) +#### A masked pattern was here #### + Vertices: + Map 1 + Map Operator Tree: + TableScan + alias: src + Filter Operator + predicate: ((key > 20) and (key < 40)) (type: boolean) + Select Operator + expressions: key (type: string), value (type: string), '33' (type: string) + outputColumnNames: _col0, _col1, _col2 + Select Operator + expressions: _col0 (type: string), _col1 (type: string), _col2 (type: string) + outputColumnNames: _col0, _col1, _col2 + File Output Operator + compressed: false + table: + input format: org.apache.hadoop.mapred.TextInputFormat + output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat + serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe + name: default.nzhang_part13 + Map 3 + Map Operator Tree: + TableScan + alias: src + Filter Operator + predicate: (key < 20) (type: boolean) + Select Operator + expressions: key (type: string), value (type: string), '22' (type: string) + outputColumnNames: _col0, _col1, _col2 + Select Operator + expressions: _col0 (type: string), _col1 (type: string), _col2 (type: string) + outputColumnNames: _col0, _col1, _col2 + File Output Operator + compressed: false + table: + input format: org.apache.hadoop.mapred.TextInputFormat + output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat + serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe + name: default.nzhang_part13 + Union 2 + Vertex: Union 2 + + Stage: Stage-2 + Dependency Collection + + Stage: Stage-0 + Move Operator + tables: + partition: + ds 2010-03-03 + hr + replace: true + table: + input format: org.apache.hadoop.mapred.TextInputFormat + output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat + serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe + name: default.nzhang_part13 + + Stage: Stage-3 + Stats-Aggr Operator + + Stage: Stage-4 + Stats-Aggr Operator + + Stage: Stage-5 + Stats-Aggr Operator + +PREHOOK: query: insert overwrite table nzhang_part13 partition (ds="2010-03-03", hr) +select * from ( + select key, value, '22' + from src + where key < 20 + union all + select key, value, '33' + from src + where key > 20 and key < 40) s +PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Output: default@nzhang_part13@ds=2010-03-03 +[Error 30017]: Skipping stats aggregation by error org.apache.hadoop.hive.ql.metadata.HiveException: [Error 30015]: Stats aggregator of type counter cannot be connected to +[Error 30017]: Skipping stats aggregation by error org.apache.hadoop.hive.ql.metadata.HiveException: [Error 30015]: Stats aggregator of type counter cannot be connected to +[Error 30017]: Skipping stats aggregation by error org.apache.hadoop.hive.ql.metadata.HiveException: [Error 30015]: Stats aggregator of type counter cannot be connected to +POSTHOOK: query: insert overwrite table nzhang_part13 partition (ds="2010-03-03", hr) +select * from ( + select key, value, '22' + from src + where key < 20 + union all + select key, value, '33' + from src + where key > 20 and key < 40) s +POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Output: default@nzhang_part13@ds=2010-03-03/hr=22 +POSTHOOK: Output: default@nzhang_part13@ds=2010-03-03/hr=33 +POSTHOOK: Lineage: nzhang_part13 PARTITION(ds=2010-03-03,hr=22).key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), (src)src.FieldSchema(name:key, type:string, comment:default), ] +POSTHOOK: Lineage: nzhang_part13 PARTITION(ds=2010-03-03,hr=22).value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), (src)src.FieldSchema(name:value, type:string, comment:default), ] +POSTHOOK: Lineage: nzhang_part13 PARTITION(ds=2010-03-03,hr=33).key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), (src)src.FieldSchema(name:key, type:string, comment:default), ] +POSTHOOK: Lineage: nzhang_part13 PARTITION(ds=2010-03-03,hr=33).value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), (src)src.FieldSchema(name:value, type:string, comment:default), ] +PREHOOK: query: show partitions nzhang_part13 +PREHOOK: type: SHOWPARTITIONS +PREHOOK: Input: default@nzhang_part13 +POSTHOOK: query: show partitions nzhang_part13 +POSTHOOK: type: SHOWPARTITIONS +POSTHOOK: Input: default@nzhang_part13 +ds=2010-03-03/hr=22 +ds=2010-03-03/hr=33 +PREHOOK: query: select * from nzhang_part13 where ds is not null and hr is not null +PREHOOK: type: QUERY +PREHOOK: Input: default@nzhang_part13 +PREHOOK: Input: default@nzhang_part13@ds=2010-03-03/hr=22 +PREHOOK: Input: default@nzhang_part13@ds=2010-03-03/hr=33 +#### A masked pattern was here #### +POSTHOOK: query: select * from nzhang_part13 where ds is not null and hr is not null +POSTHOOK: type: QUERY +POSTHOOK: Input: default@nzhang_part13 +POSTHOOK: Input: default@nzhang_part13@ds=2010-03-03/hr=22 +POSTHOOK: Input: default@nzhang_part13@ds=2010-03-03/hr=33 +#### A masked pattern was here #### +15 val_15 2010-03-03 22 +17 val_17 2010-03-03 22 +0 val_0 2010-03-03 22 +4 val_4 2010-03-03 22 +12 val_12 2010-03-03 22 +8 val_8 2010-03-03 22 +0 val_0 2010-03-03 22 +0 val_0 2010-03-03 22 +15 val_15 2010-03-03 22 +19 val_19 2010-03-03 22 +10 val_10 2010-03-03 22 +5 val_5 2010-03-03 22 +11 val_11 2010-03-03 22 +5 val_5 2010-03-03 22 +2 val_2 2010-03-03 22 +12 val_12 2010-03-03 22 +5 val_5 2010-03-03 22 +18 val_18 2010-03-03 22 +9 val_9 2010-03-03 22 +18 val_18 2010-03-03 22 +27 val_27 2010-03-03 33 +37 val_37 2010-03-03 33 +35 val_35 2010-03-03 33 +24 val_24 2010-03-03 33 +26 val_26 2010-03-03 33 +35 val_35 2010-03-03 33 +34 val_34 2010-03-03 33 +30 val_30 2010-03-03 33 +33 val_33 2010-03-03 33 +35 val_35 2010-03-03 33 +24 val_24 2010-03-03 33 +26 val_26 2010-03-03 33 +28 val_28 2010-03-03 33 +37 val_37 2010-03-03 33 Added: hive/branches/spark/ql/src/test/results/clientpositive/spark/load_dyn_part14.q.out URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/spark/load_dyn_part14.q.out?rev=1622504&view=auto ============================================================================== --- hive/branches/spark/ql/src/test/results/clientpositive/spark/load_dyn_part14.q.out (added) +++ hive/branches/spark/ql/src/test/results/clientpositive/spark/load_dyn_part14.q.out Thu Sep 4 15:49:58 2014 @@ -0,0 +1,250 @@ +PREHOOK: query: -- EXCLUDE_OS_WINDOWS +-- excluded on windows because of difference in file name encoding logic + +-- SORT_QUERY_RESULTS + +create table if not exists nzhang_part14 (key string) + partitioned by (value string) +PREHOOK: type: CREATETABLE +PREHOOK: Output: database:default +PREHOOK: Output: default@nzhang_part14 +POSTHOOK: query: -- EXCLUDE_OS_WINDOWS +-- excluded on windows because of difference in file name encoding logic + +-- SORT_QUERY_RESULTS + +create table if not exists nzhang_part14 (key string) + partitioned by (value string) +POSTHOOK: type: CREATETABLE +POSTHOOK: Output: database:default +POSTHOOK: Output: default@nzhang_part14 +PREHOOK: query: describe extended nzhang_part14 +PREHOOK: type: DESCTABLE +PREHOOK: Input: default@nzhang_part14 +POSTHOOK: query: describe extended nzhang_part14 +POSTHOOK: type: DESCTABLE +POSTHOOK: Input: default@nzhang_part14 +key string +value string + +# Partition Information +# col_name data_type comment + +value string + +#### A masked pattern was here #### +PREHOOK: query: explain +insert overwrite table nzhang_part14 partition(value) +select key, value from ( + select 'k1' as key, cast(null as string) as value from src limit 2 + union all + select 'k2' as key, '' as value from src limit 2 + union all + select 'k3' as key, ' ' as value from src limit 2 +) T +PREHOOK: type: QUERY +POSTHOOK: query: explain +insert overwrite table nzhang_part14 partition(value) +select key, value from ( + select 'k1' as key, cast(null as string) as value from src limit 2 + union all + select 'k2' as key, '' as value from src limit 2 + union all + select 'k3' as key, ' ' as value from src limit 2 +) T +POSTHOOK: type: QUERY +STAGE DEPENDENCIES: + Stage-1 is a root stage + Stage-2 depends on stages: Stage-1 + Stage-0 depends on stages: Stage-2 + Stage-3 depends on stages: Stage-0 + +STAGE PLANS: + Stage: Stage-1 + Spark + Edges: + Reducer 2 <- Map 1 (GROUP) + Reducer 4 <- Union 3 (GROUP SORT) + Reducer 6 <- Map 5 (GROUP) + Reducer 8 <- Map 7 (GROUP) + Union 3 <- Reducer 2 (NONE), Reducer 6 (NONE), Reducer 8 (NONE) +#### A masked pattern was here #### + Vertices: + Map 1 + Map Operator Tree: + TableScan + alias: src + Statistics: Num rows: 0 Data size: 5812 Basic stats: PARTIAL Column stats: COMPLETE + Select Operator + expressions: 'k2' (type: string), '' (type: string) + outputColumnNames: _col0, _col1 + Statistics: Num rows: 0 Data size: 5812 Basic stats: PARTIAL Column stats: COMPLETE + Limit + Number of rows: 2 + Statistics: Num rows: 0 Data size: 5812 Basic stats: PARTIAL Column stats: COMPLETE + Reduce Output Operator + sort order: + Statistics: Num rows: 0 Data size: 5812 Basic stats: PARTIAL Column stats: COMPLETE + value expressions: _col0 (type: string), _col1 (type: string) + Map 5 + Map Operator Tree: + TableScan + alias: src + Statistics: Num rows: 0 Data size: 5812 Basic stats: PARTIAL Column stats: COMPLETE + Select Operator + expressions: 'k3' (type: string), ' ' (type: string) + outputColumnNames: _col0, _col1 + Statistics: Num rows: 0 Data size: 5812 Basic stats: PARTIAL Column stats: COMPLETE + Limit + Number of rows: 2 + Statistics: Num rows: 0 Data size: 5812 Basic stats: PARTIAL Column stats: COMPLETE + Reduce Output Operator + sort order: + Statistics: Num rows: 0 Data size: 5812 Basic stats: PARTIAL Column stats: COMPLETE + value expressions: _col0 (type: string), _col1 (type: string) + Map 7 + Map Operator Tree: + TableScan + alias: src + Statistics: Num rows: 0 Data size: 5812 Basic stats: PARTIAL Column stats: COMPLETE + Select Operator + expressions: 'k1' (type: string), UDFToString(null) (type: string) + outputColumnNames: _col0, _col1 + Statistics: Num rows: 0 Data size: 5812 Basic stats: PARTIAL Column stats: COMPLETE + Limit + Number of rows: 2 + Statistics: Num rows: 0 Data size: 5812 Basic stats: PARTIAL Column stats: COMPLETE + Reduce Output Operator + sort order: + Statistics: Num rows: 0 Data size: 5812 Basic stats: PARTIAL Column stats: COMPLETE + value expressions: _col0 (type: string), _col1 (type: string) + Reducer 2 + Reduce Operator Tree: + Select Operator + expressions: VALUE._col0 (type: string), VALUE._col1 (type: string) + outputColumnNames: _col0, _col1 + Limit + Number of rows: 2 + Select Operator + expressions: _col0 (type: string), _col1 (type: string) + outputColumnNames: _col0, _col1 + Reduce Output Operator + key expressions: _col1 (type: string) + sort order: + + Map-reduce partition columns: _col1 (type: string) + value expressions: _col0 (type: string), _col1 (type: string) + Reducer 4 + Reduce Operator Tree: + Extract + Statistics: Num rows: 0 Data size: 17436 Basic stats: PARTIAL Column stats: COMPLETE + File Output Operator + compressed: false + Statistics: Num rows: 0 Data size: 17436 Basic stats: PARTIAL Column stats: COMPLETE + table: + input format: org.apache.hadoop.mapred.TextInputFormat + output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat + serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe + name: default.nzhang_part14 + Reducer 6 + Reduce Operator Tree: + Select Operator + expressions: VALUE._col0 (type: string), VALUE._col1 (type: string) + outputColumnNames: _col0, _col1 + Limit + Number of rows: 2 + Select Operator + expressions: _col0 (type: string), _col1 (type: string) + outputColumnNames: _col0, _col1 + Reduce Output Operator + key expressions: _col1 (type: string) + sort order: + + Map-reduce partition columns: _col1 (type: string) + value expressions: _col0 (type: string), _col1 (type: string) + Reducer 8 + Reduce Operator Tree: + Select Operator + expressions: VALUE._col0 (type: string), VALUE._col1 (type: string) + outputColumnNames: _col0, _col1 + Limit + Number of rows: 2 + Select Operator + expressions: _col0 (type: string), _col1 (type: string) + outputColumnNames: _col0, _col1 + Reduce Output Operator + key expressions: _col1 (type: string) + sort order: + + Map-reduce partition columns: _col1 (type: string) + value expressions: _col0 (type: string), _col1 (type: string) + Union 3 + Vertex: Union 3 + + Stage: Stage-2 + Dependency Collection + + Stage: Stage-0 + Move Operator + tables: + partition: + value + replace: true + table: + input format: org.apache.hadoop.mapred.TextInputFormat + output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat + serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe + name: default.nzhang_part14 + + Stage: Stage-3 + Stats-Aggr Operator + +PREHOOK: query: insert overwrite table nzhang_part14 partition(value) +select key, value from ( + select 'k1' as key, cast(null as string) as value from src limit 2 + union all + select 'k2' as key, '' as value from src limit 2 + union all + select 'k3' as key, ' ' as value from src limit 2 +) T +PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Output: default@nzhang_part14 +[Error 30017]: Skipping stats aggregation by error org.apache.hadoop.hive.ql.metadata.HiveException: [Error 30015]: Stats aggregator of type counter cannot be connected to +POSTHOOK: query: insert overwrite table nzhang_part14 partition(value) +select key, value from ( + select 'k1' as key, cast(null as string) as value from src limit 2 + union all + select 'k2' as key, '' as value from src limit 2 + union all + select 'k3' as key, ' ' as value from src limit 2 +) T +POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Output: default@nzhang_part14@value= +POSTHOOK: Output: default@nzhang_part14@value=__HIVE_DEFAULT_PARTITION__ +POSTHOOK: Lineage: nzhang_part14 PARTITION(value= ).key EXPRESSION [] +POSTHOOK: Lineage: nzhang_part14 PARTITION(value=__HIVE_DEFAULT_PARTITION__).key EXPRESSION [] +PREHOOK: query: show partitions nzhang_part14 +PREHOOK: type: SHOWPARTITIONS +PREHOOK: Input: default@nzhang_part14 +POSTHOOK: query: show partitions nzhang_part14 +POSTHOOK: type: SHOWPARTITIONS +POSTHOOK: Input: default@nzhang_part14 +value= +value=__HIVE_DEFAULT_PARTITION__ +PREHOOK: query: select * from nzhang_part14 where value <> 'a' +PREHOOK: type: QUERY +PREHOOK: Input: default@nzhang_part14 +PREHOOK: Input: default@nzhang_part14@value= +PREHOOK: Input: default@nzhang_part14@value=__HIVE_DEFAULT_PARTITION__ +#### A masked pattern was here #### +POSTHOOK: query: select * from nzhang_part14 where value <> 'a' +POSTHOOK: type: QUERY +POSTHOOK: Input: default@nzhang_part14 +POSTHOOK: Input: default@nzhang_part14@value= +POSTHOOK: Input: default@nzhang_part14@value=__HIVE_DEFAULT_PARTITION__ +#### A masked pattern was here #### +k1 __HIVE_DEFAULT_PARTITION__ +k1 __HIVE_DEFAULT_PARTITION__ +k2 __HIVE_DEFAULT_PARTITION__ +k2 __HIVE_DEFAULT_PARTITION__ +k3 +k3 Added: hive/branches/spark/ql/src/test/results/clientpositive/spark/load_dyn_part15.q.out URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/spark/load_dyn_part15.q.out?rev=1622504&view=auto ============================================================================== --- hive/branches/spark/ql/src/test/results/clientpositive/spark/load_dyn_part15.q.out (added) +++ hive/branches/spark/ql/src/test/results/clientpositive/spark/load_dyn_part15.q.out Thu Sep 4 15:49:58 2014 @@ -0,0 +1,41 @@ +PREHOOK: query: create table if not exists load_dyn_part15_test (key string) + partitioned by (part_key string) +PREHOOK: type: CREATETABLE +PREHOOK: Output: database:default +PREHOOK: Output: default@load_dyn_part15_test +POSTHOOK: query: create table if not exists load_dyn_part15_test (key string) + partitioned by (part_key string) +POSTHOOK: type: CREATETABLE +POSTHOOK: Output: database:default +POSTHOOK: Output: default@load_dyn_part15_test +PREHOOK: query: show partitions load_dyn_part15_test +PREHOOK: type: SHOWPARTITIONS +PREHOOK: Input: default@load_dyn_part15_test +POSTHOOK: query: show partitions load_dyn_part15_test +POSTHOOK: type: SHOWPARTITIONS +POSTHOOK: Input: default@load_dyn_part15_test +PREHOOK: query: INSERT OVERWRITE TABLE load_dyn_part15_test PARTITION(part_key) +SELECT key, part_key FROM src LATERAL VIEW explode(array("1","{2","3]")) myTable AS part_key +PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Output: default@load_dyn_part15_test +[Error 30017]: Skipping stats aggregation by error org.apache.hadoop.hive.ql.metadata.HiveException: [Error 30015]: Stats aggregator of type counter cannot be connected to +POSTHOOK: query: INSERT OVERWRITE TABLE load_dyn_part15_test PARTITION(part_key) +SELECT key, part_key FROM src LATERAL VIEW explode(array("1","{2","3]")) myTable AS part_key +POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Output: default@load_dyn_part15_test@part_key=%7B2 +POSTHOOK: Output: default@load_dyn_part15_test@part_key=1 +POSTHOOK: Output: default@load_dyn_part15_test@part_key=3%5D +POSTHOOK: Lineage: load_dyn_part15_test PARTITION(part_key=1).key SCRIPT [] +POSTHOOK: Lineage: load_dyn_part15_test PARTITION(part_key=3]).key SCRIPT [] +POSTHOOK: Lineage: load_dyn_part15_test PARTITION(part_key={2).key SCRIPT [] +PREHOOK: query: show partitions load_dyn_part15_test +PREHOOK: type: SHOWPARTITIONS +PREHOOK: Input: default@load_dyn_part15_test +POSTHOOK: query: show partitions load_dyn_part15_test +POSTHOOK: type: SHOWPARTITIONS +POSTHOOK: Input: default@load_dyn_part15_test +part_key=%7B2 +part_key=1 +part_key=3%5D
