You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by xu...@apache.org on 2014/09/04 17:49:59 UTC
svn commit: r1622504 [3/7] - in /hive/branches/spark:
itests/src/test/resources/ ql/src/test/results/clientpositive/spark/
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