PREHOOK: query: create table merge_src as select key, value from srcpart where ds is not null PREHOOK: type: CREATETABLE 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 POSTHOOK: query: create table merge_src as select key, value from srcpart where ds is not null POSTHOOK: type: CREATETABLE 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@merge_src PREHOOK: query: create table merge_src_part (key string, value string) partitioned by (ds string) PREHOOK: type: CREATETABLE POSTHOOK: query: create table merge_src_part (key string, value string) partitioned by (ds string) POSTHOOK: type: CREATETABLE POSTHOOK: Output: default@merge_src_part PREHOOK: query: insert overwrite table merge_src_part partition(ds) select key, value, ds from srcpart where ds is not null PREHOOK: type: QUERY 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 POSTHOOK: query: insert overwrite table merge_src_part partition(ds) select key, value, ds from srcpart where ds is not null POSTHOOK: type: QUERY 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@merge_src_part@ds=2008-04-08 POSTHOOK: Output: default@merge_src_part@ds=2008-04-09 POSTHOOK: Lineage: merge_src_part PARTITION(ds=2008-04-08).key SIMPLE [(srcpart)srcpart.FieldSchema(name:ds, type:string, comment:null), ] POSTHOOK: Lineage: merge_src_part PARTITION(ds=2008-04-08).value SIMPLE [(srcpart)srcpart.FieldSchema(name:hr, type:string, comment:null), ] POSTHOOK: Lineage: merge_src_part PARTITION(ds=2008-04-09).key SIMPLE [(srcpart)srcpart.FieldSchema(name:ds, type:string, comment:null), ] POSTHOOK: Lineage: merge_src_part PARTITION(ds=2008-04-09).value SIMPLE [(srcpart)srcpart.FieldSchema(name:hr, type:string, comment:null), ] PREHOOK: query: explain extended create table merge_src2 as select key, value from merge_src PREHOOK: type: CREATETABLE POSTHOOK: query: explain extended create table merge_src2 as select key, value from merge_src POSTHOOK: type: CREATETABLE POSTHOOK: Lineage: merge_src_part PARTITION(ds=2008-04-08).key SIMPLE [(srcpart)srcpart.FieldSchema(name:ds, type:string, comment:null), ] POSTHOOK: Lineage: merge_src_part PARTITION(ds=2008-04-08).value SIMPLE [(srcpart)srcpart.FieldSchema(name:hr, type:string, comment:null), ] POSTHOOK: Lineage: merge_src_part PARTITION(ds=2008-04-09).key SIMPLE [(srcpart)srcpart.FieldSchema(name:ds, type:string, comment:null), ] POSTHOOK: Lineage: merge_src_part PARTITION(ds=2008-04-09).value SIMPLE [(srcpart)srcpart.FieldSchema(name:hr, type:string, comment:null), ] ABSTRACT SYNTAX TREE: (TOK_CREATETABLE merge_src2 TOK_LIKETABLE (TOK_QUERY (TOK_FROM (TOK_TABREF merge_src)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_TABLE_OR_COL key)) (TOK_SELEXPR (TOK_TABLE_OR_COL value)))))) STAGE DEPENDENCIES: Stage-1 is a root stage Stage-4 depends on stages: Stage-1 , consists of Stage-3, Stage-2 Stage-3 Stage-0 depends on stages: Stage-3, Stage-2 Stage-5 depends on stages: Stage-3, Stage-2 Stage-2 STAGE PLANS: Stage: Stage-1 Map Reduce Alias -> Map Operator Tree: merge_src TableScan alias: merge_src Select Operator expressions: expr: key type: string expr: value type: string outputColumnNames: _col0, _col1 File Output Operator compressed: false GlobalTableId: 0 directory: file:/data/users/nzhang/reviews/0.6/branch-0.6/build/ql/scratchdir/hive_2010-08-21_23-31-02_957_4754883181129906669/10002 NumFilesPerFileSink: 1 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat properties: columns _col0,_col1 columns.types string:string serialization.format 1 TotalFiles: 1 MultiFileSpray: false Needs Tagging: false Path -> Alias: file:/data/users/nzhang/reviews/0.6/branch-0.6/build/ql/test/data/warehouse/merge_src [merge_src] Path -> Partition: file:/data/users/nzhang/reviews/0.6/branch-0.6/build/ql/test/data/warehouse/merge_src Partition base file name: merge_src input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat properties: bucket_count -1 columns key,value columns.types string:string file.inputformat org.apache.hadoop.mapred.TextInputFormat file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat location file:/data/users/nzhang/reviews/0.6/branch-0.6/build/ql/test/data/warehouse/merge_src name merge_src serialization.ddl struct merge_src { string key, string value} serialization.format 1 serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe transient_lastDdlTime 1282458659 serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat properties: bucket_count -1 columns key,value columns.types string:string file.inputformat org.apache.hadoop.mapred.TextInputFormat file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat location file:/data/users/nzhang/reviews/0.6/branch-0.6/build/ql/test/data/warehouse/merge_src name merge_src serialization.ddl struct merge_src { string key, string value} serialization.format 1 serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe transient_lastDdlTime 1282458659 serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe name: merge_src name: merge_src Stage: Stage-4 Conditional Operator Stage: Stage-3 Move Operator files: hdfs directory: true source: file:/data/users/nzhang/reviews/0.6/branch-0.6/build/ql/scratchdir/hive_2010-08-21_23-31-02_957_4754883181129906669/10002 destination: file:/data/users/nzhang/reviews/0.6/branch-0.6/build/ql/scratchdir/hive_2010-08-21_23-31-02_957_4754883181129906669/10001 Stage: Stage-0 Move Operator files: hdfs directory: true source: file:/data/users/nzhang/reviews/0.6/branch-0.6/build/ql/scratchdir/hive_2010-08-21_23-31-02_957_4754883181129906669/10001 destination: file:///data/users/nzhang/reviews/0.6/branch-0.6/build/ql/test/data/warehouse/merge_src2 Stage: Stage-5 Create Table Operator: Create Table columns: key string, value string if not exists: false input format: org.apache.hadoop.mapred.TextInputFormat # buckets: -1 output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat name: merge_src2 isExternal: false Stage: Stage-2 Map Reduce Alias -> Map Operator Tree: file:/data/users/nzhang/reviews/0.6/branch-0.6/build/ql/scratchdir/hive_2010-08-21_23-31-02_957_4754883181129906669/10002 Reduce Output Operator sort order: Map-reduce partition columns: expr: rand() type: double tag: -1 value expressions: expr: _col0 type: string expr: _col1 type: string Needs Tagging: false Path -> Alias: file:/data/users/nzhang/reviews/0.6/branch-0.6/build/ql/scratchdir/hive_2010-08-21_23-31-02_957_4754883181129906669/10002 [file:/data/users/nzhang/reviews/0.6/branch-0.6/build/ql/scratchdir/hive_2010-08-21_23-31-02_957_4754883181129906669/10002] Path -> Partition: file:/data/users/nzhang/reviews/0.6/branch-0.6/build/ql/scratchdir/hive_2010-08-21_23-31-02_957_4754883181129906669/10002 Partition base file name: 10002 input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat properties: columns _col0,_col1 columns.types string:string serialization.format 1 input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat properties: columns _col0,_col1 columns.types string:string serialization.format 1 Reduce Operator Tree: Extract File Output Operator compressed: false GlobalTableId: 0 directory: file:/data/users/nzhang/reviews/0.6/branch-0.6/build/ql/scratchdir/hive_2010-08-21_23-31-02_957_4754883181129906669/10001 NumFilesPerFileSink: 1 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat properties: columns _col0,_col1 columns.types string:string serialization.format 1 TotalFiles: 1 MultiFileSpray: false PREHOOK: query: create table merge_src2 as select key, value from merge_src PREHOOK: type: CREATETABLE PREHOOK: Input: default@merge_src POSTHOOK: query: create table merge_src2 as select key, value from merge_src POSTHOOK: type: CREATETABLE POSTHOOK: Input: default@merge_src POSTHOOK: Output: default@merge_src2 POSTHOOK: Lineage: merge_src_part PARTITION(ds=2008-04-08).key SIMPLE [(srcpart)srcpart.FieldSchema(name:ds, type:string, comment:null), ] POSTHOOK: Lineage: merge_src_part PARTITION(ds=2008-04-08).value SIMPLE [(srcpart)srcpart.FieldSchema(name:hr, type:string, comment:null), ] POSTHOOK: Lineage: merge_src_part PARTITION(ds=2008-04-09).key SIMPLE [(srcpart)srcpart.FieldSchema(name:ds, type:string, comment:null), ] POSTHOOK: Lineage: merge_src_part PARTITION(ds=2008-04-09).value SIMPLE [(srcpart)srcpart.FieldSchema(name:hr, type:string, comment:null), ] PREHOOK: query: select * from merge_src2 PREHOOK: type: QUERY PREHOOK: Input: default@merge_src2 PREHOOK: Output: file:/tmp/nzhang/hive_2010-08-21_23-31-10_592_1023505336710054653/10000 POSTHOOK: query: select * from merge_src2 POSTHOOK: type: QUERY POSTHOOK: Input: default@merge_src2 POSTHOOK: Output: file:/tmp/nzhang/hive_2010-08-21_23-31-10_592_1023505336710054653/10000 POSTHOOK: Lineage: merge_src_part PARTITION(ds=2008-04-08).key SIMPLE [(srcpart)srcpart.FieldSchema(name:ds, type:string, comment:null), ] POSTHOOK: Lineage: merge_src_part PARTITION(ds=2008-04-08).value SIMPLE [(srcpart)srcpart.FieldSchema(name:hr, type:string, comment:null), ] POSTHOOK: Lineage: merge_src_part PARTITION(ds=2008-04-09).key SIMPLE [(srcpart)srcpart.FieldSchema(name:ds, type:string, comment:null), ] POSTHOOK: Lineage: merge_src_part PARTITION(ds=2008-04-09).value SIMPLE [(srcpart)srcpart.FieldSchema(name:hr, type:string, comment:null), ] 128 val_128 288 val_288 191 val_191 5 val_5 244 val_244 438 val_438 401 val_401 467 val_467 432 val_432 202 val_202 316 val_316 229 val_229 469 val_469 463 val_463 280 val_280 239 val_239 216 val_216 367 val_367 344 val_344 167 val_167 274 val_274 219 val_219 480 val_480 485 val_485 116 val_116 223 val_223 256 val_256 263 val_263 70 val_70 487 val_487 113 val_113 406 val_406 105 val_105 257 val_257 406 val_406 409 val_409 190 val_190 53 val_53 401 val_401 114 val_114 258 val_258 90 val_90 203 val_203 262 val_262 348 val_348 2 val_2 193 val_193 35 val_35 283 val_283 331 val_331 235 val_235 80 val_80 44 val_44 483 val_483 321 val_321 335 val_335 104 val_104 466 val_466 366 val_366 175 val_175 403 val_403 424 val_424 11 val_11 395 val_395 58 val_58 35 val_35 336 val_336 95 val_95 317 val_317 168 val_168 34 val_34 229 val_229 233 val_233 143 val_143 472 val_472 322 val_322 498 val_498 401 val_401 327 val_327 242 val_242 369 val_369 392 val_392 272 val_272 331 val_331 396 val_396 242 val_242 452 val_452 177 val_177 226 val_226 5 val_5 497 val_497 402 val_402 296 val_296 76 val_76 138 val_138 453 val_453 30 val_30 209 val_209 64 val_64 468 val_468 228 val_228 74 val_74 342 val_342 69 val_69 230 val_230 33 val_33 368 val_368 103 val_103 160 val_160 458 val_458 195 val_195 42 val_42 321 val_321 430 val_430 119 val_119 489 val_489 218 val_218 78 val_78 76 val_76 41 val_41 223 val_223 492 val_492 149 val_149 449 val_449 389 val_389 492 val_492 67 val_67 384 val_384 379 val_379 18 val_18 462 val_462 134 val_134 100 val_100 298 val_298 9 val_9 341 val_341 498 val_498 146 val_146 458 val_458 362 val_362 189 val_189 214 val_214 462 val_462 233 val_233 406 val_406 133 val_133 175 val_175 26 val_26 454 val_454 375 val_375 401 val_401 421 val_421 407 val_407 384 val_384 256 val_256 172 val_172 222 val_222 348 val_348 307 val_307 194 val_194 414 val_414 477 val_477 152 val_152 126 val_126 90 val_90 169 val_169 403 val_403 400 val_400 200 val_200 97 val_97 186 val_186 281 val_281 285 val_285 348 val_348 167 val_167 18 val_18 273 val_273 183 val_183 448 val_448 344 val_344 97 val_97 469 val_469 315 val_315 84 val_84 28 val_28 37 val_37 12 val_12 255 val_255 397 val_397 480 val_480 291 val_291 24 val_24 351 val_351 70 val_70 104 val_104 70 val_70 163 val_163 438 val_438 119 val_119 414 val_414 200 val_200 491 val_491 478 val_478 396 val_396 201 val_201 217 val_217 164 val_164 431 val_431 454 val_454 5 val_5 298 val_298 125 val_125 431 val_431 164 val_164 424 val_424 187 val_187 382 val_382 353 val_353 493 val_493 478 val_478 178 val_178 468 val_468 310 val_310 317 val_317 333 val_333 230 val_230 460 val_460 207 val_207 249 val_249 265 val_265 480 val_480 83 val_83 136 val_136 237 val_237 199 val_199 439 val_439 360 val_360 248 val_248 479 val_479 305 val_305 417 val_417 277 val_277 444 val_444 120 val_120 429 val_429 169 val_169 443 val_443 323 val_323 325 val_325 238 val_238 311 val_311 203 val_203 339 val_339 0 val_0 455 val_455 128 val_128 155 val_155 316 val_316 57 val_57 302 val_302 205 val_205 149 val_149 438 val_438 345 val_345 129 val_129 439 val_439 162 val_162 377 val_377 397 val_397 309 val_309 365 val_365 266 val_266 113 val_113 342 val_342 367 val_367 325 val_325 167 val_167 195 val_195 475 val_475 17 val_17 489 val_489 386 val_386 399 val_399 169 val_169 382 val_382 498 val_498 125 val_125 356 val_356 437 val_437 469 val_469 192 val_192 286 val_286 187 val_187 176 val_176 54 val_54 170 val_170 111 val_111 20 val_20 489 val_489 157 val_157 378 val_378 221 val_221 92 val_92 208 val_208 47 val_47 72 val_72 4 val_4 280 val_280 35 val_35 427 val_427 277 val_277 459 val_459 429 val_429 66 val_66 128 val_128 213 val_213 146 val_146 406 val_406 369 val_369 374 val_374 152 val_152 469 val_469 145 val_145 495 val_495 37 val_37 327 val_327 281 val_281 278 val_278 86 val_86 311 val_311 27 val_27 165 val_165 409 val_409 255 val_255 224 val_224 98 val_98 484 val_484 265 val_265 193 val_193 401 val_401 150 val_150 273 val_273 417 val_417 207 val_207 394 val_394 237 val_237 482 val_482 174 val_174 413 val_413 494 val_494 459 val_459 199 val_199 466 val_466 208 val_208 174 val_174 399 val_399 396 val_396 247 val_247 277 val_277 430 val_430 209 val_209 15 val_15 82 val_82 403 val_403 166 val_166 417 val_417 446 val_446 252 val_252 292 val_292 219 val_219 287 val_287 153 val_153 193 val_193 338 val_338 309 val_309 457 val_457 308 val_308 95 val_95 196 val_196 288 val_288 481 val_481 468 val_468 98 val_98 282 val_282 197 val_197 187 val_187 318 val_318 318 val_318 409 val_409 470 val_470 205 val_205 418 val_418 96 val_96 26 val_26 165 val_165 327 val_327 230 val_230 469 val_469 120 val_120 131 val_131 51 val_51 404 val_404 43 val_43 436 val_436 156 val_156 191 val_191 307 val_307 238 val_238 419 val_419 15 val_15 118 val_118 72 val_72 90 val_90 138 val_138 19 val_19 435 val_435 10 val_10 277 val_277 273 val_273 306 val_306 224 val_224 137 val_137 0 val_0 369 val_369 316 val_316 169 val_169 413 val_413 85 val_85 77 val_77 282 val_282 490 val_490 87 val_87 364 val_364 179 val_179 118 val_118 134 val_134 395 val_395 51 val_51 12 val_12 241 val_241 83 val_83 333 val_333 180 val_180 284 val_284 137 val_137 230 val_230 181 val_181 67 val_67 260 val_260 404 val_404 384 val_384 489 val_489 353 val_353 278 val_278 138 val_138 103 val_103 239 val_239 213 val_213 216 val_216 430 val_430 275 val_275 176 val_176 289 val_289 221 val_221 65 val_65 318 val_318 332 val_332 311 val_311 199 val_199 0 val_0 172 val_172 42 val_42 129 val_129 158 val_158 119 val_119 496 val_496 179 val_179 322 val_322 197 val_197 468 val_468 393 val_393 454 val_454 100 val_100 298 val_298 373 val_373 58 val_58 272 val_272 138 val_138 217 val_217 84 val_84 348 val_348 466 val_466 431 val_431 8 val_8 411 val_411 230 val_230 208 val_208 348 val_348 24 val_24 463 val_463 128 val_128 288 val_288 191 val_191 5 val_5 244 val_244 438 val_438 401 val_401 467 val_467 432 val_432 202 val_202 316 val_316 229 val_229 469 val_469 463 val_463 280 val_280 239 val_239 216 val_216 367 val_367 344 val_344 167 val_167 274 val_274 219 val_219 480 val_480 485 val_485 116 val_116 223 val_223 256 val_256 263 val_263 70 val_70 487 val_487 113 val_113 406 val_406 105 val_105 257 val_257 406 val_406 409 val_409 190 val_190 53 val_53 401 val_401 114 val_114 258 val_258 90 val_90 203 val_203 262 val_262 348 val_348 2 val_2 193 val_193 35 val_35 283 val_283 331 val_331 235 val_235 80 val_80 44 val_44 483 val_483 321 val_321 335 val_335 104 val_104 466 val_466 366 val_366 175 val_175 403 val_403 424 val_424 11 val_11 395 val_395 58 val_58 35 val_35 336 val_336 95 val_95 317 val_317 168 val_168 34 val_34 229 val_229 233 val_233 143 val_143 472 val_472 322 val_322 498 val_498 401 val_401 327 val_327 242 val_242 369 val_369 392 val_392 272 val_272 331 val_331 396 val_396 242 val_242 452 val_452 177 val_177 226 val_226 5 val_5 497 val_497 402 val_402 296 val_296 76 val_76 138 val_138 453 val_453 30 val_30 209 val_209 64 val_64 468 val_468 228 val_228 74 val_74 342 val_342 69 val_69 230 val_230 33 val_33 368 val_368 103 val_103 160 val_160 458 val_458 195 val_195 42 val_42 321 val_321 430 val_430 119 val_119 489 val_489 218 val_218 78 val_78 76 val_76 41 val_41 223 val_223 492 val_492 149 val_149 449 val_449 389 val_389 492 val_492 67 val_67 384 val_384 379 val_379 18 val_18 462 val_462 134 val_134 100 val_100 298 val_298 9 val_9 341 val_341 498 val_498 146 val_146 458 val_458 362 val_362 189 val_189 214 val_214 462 val_462 233 val_233 406 val_406 133 val_133 175 val_175 26 val_26 454 val_454 375 val_375 401 val_401 421 val_421 407 val_407 384 val_384 256 val_256 172 val_172 222 val_222 348 val_348 307 val_307 194 val_194 414 val_414 477 val_477 152 val_152 126 val_126 90 val_90 169 val_169 403 val_403 400 val_400 200 val_200 97 val_97 186 val_186 281 val_281 285 val_285 348 val_348 167 val_167 18 val_18 273 val_273 183 val_183 448 val_448 344 val_344 97 val_97 469 val_469 315 val_315 84 val_84 28 val_28 37 val_37 12 val_12 255 val_255 397 val_397 480 val_480 291 val_291 24 val_24 351 val_351 70 val_70 104 val_104 70 val_70 163 val_163 438 val_438 119 val_119 414 val_414 200 val_200 491 val_491 478 val_478 396 val_396 201 val_201 217 val_217 164 val_164 431 val_431 454 val_454 5 val_5 298 val_298 125 val_125 431 val_431 164 val_164 424 val_424 187 val_187 382 val_382 353 val_353 493 val_493 478 val_478 178 val_178 468 val_468 310 val_310 317 val_317 333 val_333 230 val_230 460 val_460 207 val_207 249 val_249 265 val_265 480 val_480 83 val_83 136 val_136 237 val_237 199 val_199 439 val_439 360 val_360 248 val_248 479 val_479 305 val_305 417 val_417 277 val_277 444 val_444 120 val_120 429 val_429 169 val_169 443 val_443 323 val_323 325 val_325 238 val_238 311 val_311 203 val_203 339 val_339 0 val_0 455 val_455 128 val_128 155 val_155 316 val_316 57 val_57 302 val_302 205 val_205 149 val_149 438 val_438 345 val_345 129 val_129 439 val_439 162 val_162 377 val_377 397 val_397 309 val_309 365 val_365 266 val_266 113 val_113 342 val_342 367 val_367 325 val_325 167 val_167 195 val_195 475 val_475 17 val_17 489 val_489 386 val_386 399 val_399 169 val_169 382 val_382 498 val_498 125 val_125 356 val_356 437 val_437 469 val_469 192 val_192 286 val_286 187 val_187 176 val_176 54 val_54 170 val_170 111 val_111 20 val_20 489 val_489 157 val_157 378 val_378 221 val_221 92 val_92 208 val_208 47 val_47 72 val_72 4 val_4 280 val_280 35 val_35 427 val_427 277 val_277 459 val_459 429 val_429 66 val_66 128 val_128 213 val_213 146 val_146 406 val_406 369 val_369 374 val_374 152 val_152 469 val_469 145 val_145 495 val_495 37 val_37 327 val_327 281 val_281 278 val_278 86 val_86 311 val_311 27 val_27 165 val_165 409 val_409 255 val_255 224 val_224 98 val_98 484 val_484 265 val_265 193 val_193 401 val_401 150 val_150 273 val_273 417 val_417 207 val_207 394 val_394 237 val_237 482 val_482 174 val_174 413 val_413 494 val_494 459 val_459 199 val_199 466 val_466 208 val_208 174 val_174 399 val_399 396 val_396 247 val_247 277 val_277 430 val_430 209 val_209 15 val_15 82 val_82 403 val_403 166 val_166 417 val_417 446 val_446 252 val_252 292 val_292 219 val_219 287 val_287 153 val_153 193 val_193 338 val_338 309 val_309 457 val_457 308 val_308 95 val_95 196 val_196 288 val_288 481 val_481 468 val_468 98 val_98 282 val_282 197 val_197 187 val_187 318 val_318 318 val_318 409 val_409 470 val_470 205 val_205 418 val_418 96 val_96 26 val_26 165 val_165 327 val_327 230 val_230 469 val_469 120 val_120 131 val_131 51 val_51 404 val_404 43 val_43 436 val_436 156 val_156 191 val_191 307 val_307 238 val_238 419 val_419 15 val_15 118 val_118 72 val_72 90 val_90 138 val_138 19 val_19 435 val_435 10 val_10 277 val_277 273 val_273 306 val_306 224 val_224 137 val_137 0 val_0 369 val_369 316 val_316 169 val_169 413 val_413 85 val_85 77 val_77 282 val_282 490 val_490 87 val_87 364 val_364 179 val_179 118 val_118 134 val_134 395 val_395 51 val_51 12 val_12 241 val_241 83 val_83 333 val_333 180 val_180 284 val_284 137 val_137 230 val_230 181 val_181 67 val_67 260 val_260 404 val_404 384 val_384 489 val_489 353 val_353 278 val_278 138 val_138 103 val_103 239 val_239 213 val_213 216 val_216 430 val_430 275 val_275 176 val_176 289 val_289 221 val_221 65 val_65 318 val_318 332 val_332 311 val_311 199 val_199 0 val_0 172 val_172 42 val_42 129 val_129 158 val_158 119 val_119 496 val_496 179 val_179 322 val_322 197 val_197 468 val_468 393 val_393 454 val_454 100 val_100 298 val_298 373 val_373 58 val_58 272 val_272 138 val_138 217 val_217 84 val_84 348 val_348 466 val_466 431 val_431 8 val_8 411 val_411 230 val_230 208 val_208 348 val_348 24 val_24 463 val_463 128 val_128 288 val_288 191 val_191 5 val_5 244 val_244 438 val_438 401 val_401 467 val_467 432 val_432 202 val_202 316 val_316 229 val_229 469 val_469 463 val_463 280 val_280 239 val_239 216 val_216 367 val_367 344 val_344 167 val_167 274 val_274 219 val_219 480 val_480 485 val_485 116 val_116 223 val_223 256 val_256 263 val_263 70 val_70 487 val_487 113 val_113 406 val_406 105 val_105 257 val_257 406 val_406 409 val_409 190 val_190 53 val_53 401 val_401 114 val_114 258 val_258 90 val_90 203 val_203 262 val_262 348 val_348 2 val_2 193 val_193 35 val_35 283 val_283 331 val_331 235 val_235 80 val_80 44 val_44 483 val_483 321 val_321 335 val_335 104 val_104 466 val_466 366 val_366 175 val_175 403 val_403 424 val_424 11 val_11 395 val_395 58 val_58 35 val_35 336 val_336 95 val_95 317 val_317 168 val_168 34 val_34 229 val_229 233 val_233 143 val_143 472 val_472 322 val_322 498 val_498 401 val_401 327 val_327 242 val_242 369 val_369 392 val_392 272 val_272 331 val_331 396 val_396 242 val_242 452 val_452 177 val_177 226 val_226 5 val_5 497 val_497 402 val_402 296 val_296 76 val_76 138 val_138 453 val_453 30 val_30 209 val_209 64 val_64 468 val_468 228 val_228 74 val_74 342 val_342 69 val_69 230 val_230 33 val_33 368 val_368 103 val_103 160 val_160 458 val_458 195 val_195 42 val_42 321 val_321 430 val_430 119 val_119 489 val_489 218 val_218 78 val_78 76 val_76 41 val_41 223 val_223 492 val_492 149 val_149 449 val_449 389 val_389 492 val_492 67 val_67 384 val_384 379 val_379 18 val_18 462 val_462 134 val_134 100 val_100 298 val_298 9 val_9 341 val_341 498 val_498 146 val_146 458 val_458 362 val_362 189 val_189 214 val_214 462 val_462 233 val_233 406 val_406 133 val_133 175 val_175 26 val_26 454 val_454 375 val_375 401 val_401 421 val_421 407 val_407 384 val_384 256 val_256 172 val_172 222 val_222 348 val_348 307 val_307 194 val_194 414 val_414 477 val_477 152 val_152 126 val_126 90 val_90 169 val_169 403 val_403 400 val_400 200 val_200 97 val_97 186 val_186 281 val_281 285 val_285 348 val_348 167 val_167 18 val_18 273 val_273 183 val_183 448 val_448 344 val_344 97 val_97 469 val_469 315 val_315 84 val_84 28 val_28 37 val_37 12 val_12 255 val_255 397 val_397 480 val_480 291 val_291 24 val_24 351 val_351 70 val_70 104 val_104 70 val_70 163 val_163 438 val_438 119 val_119 414 val_414 200 val_200 491 val_491 478 val_478 396 val_396 201 val_201 217 val_217 164 val_164 431 val_431 454 val_454 5 val_5 298 val_298 125 val_125 431 val_431 164 val_164 424 val_424 187 val_187 382 val_382 353 val_353 493 val_493 478 val_478 178 val_178 468 val_468 310 val_310 317 val_317 333 val_333 230 val_230 460 val_460 207 val_207 249 val_249 265 val_265 480 val_480 83 val_83 136 val_136 237 val_237 199 val_199 439 val_439 360 val_360 248 val_248 479 val_479 305 val_305 417 val_417 277 val_277 444 val_444 120 val_120 429 val_429 169 val_169 443 val_443 323 val_323 325 val_325 238 val_238 311 val_311 203 val_203 339 val_339 0 val_0 455 val_455 128 val_128 155 val_155 316 val_316 57 val_57 302 val_302 205 val_205 149 val_149 438 val_438 345 val_345 129 val_129 439 val_439 162 val_162 377 val_377 397 val_397 309 val_309 365 val_365 266 val_266 113 val_113 342 val_342 367 val_367 325 val_325 167 val_167 195 val_195 475 val_475 17 val_17 489 val_489 386 val_386 399 val_399 169 val_169 382 val_382 498 val_498 125 val_125 356 val_356 437 val_437 469 val_469 192 val_192 286 val_286 187 val_187 176 val_176 54 val_54 170 val_170 111 val_111 20 val_20 489 val_489 157 val_157 378 val_378 221 val_221 92 val_92 208 val_208 47 val_47 72 val_72 4 val_4 280 val_280 35 val_35 427 val_427 277 val_277 459 val_459 429 val_429 66 val_66 128 val_128 213 val_213 146 val_146 406 val_406 369 val_369 374 val_374 152 val_152 469 val_469 145 val_145 495 val_495 37 val_37 327 val_327 281 val_281 278 val_278 86 val_86 311 val_311 27 val_27 165 val_165 409 val_409 255 val_255 224 val_224 98 val_98 484 val_484 265 val_265 193 val_193 401 val_401 150 val_150 273 val_273 417 val_417 207 val_207 394 val_394 237 val_237 482 val_482 174 val_174 413 val_413 494 val_494 459 val_459 199 val_199 466 val_466 208 val_208 174 val_174 399 val_399 396 val_396 247 val_247 277 val_277 430 val_430 209 val_209 15 val_15 82 val_82 403 val_403 166 val_166 417 val_417 446 val_446 252 val_252 292 val_292 219 val_219 287 val_287 153 val_153 193 val_193 338 val_338 309 val_309 457 val_457 308 val_308 95 val_95 196 val_196 288 val_288 481 val_481 468 val_468 98 val_98 282 val_282 197 val_197 187 val_187 318 val_318 318 val_318 409 val_409 470 val_470 205 val_205 418 val_418 96 val_96 26 val_26 165 val_165 327 val_327 230 val_230 469 val_469 120 val_120 131 val_131 51 val_51 404 val_404 43 val_43 436 val_436 156 val_156 191 val_191 307 val_307 238 val_238 419 val_419 15 val_15 118 val_118 72 val_72 90 val_90 138 val_138 19 val_19 435 val_435 10 val_10 277 val_277 273 val_273 306 val_306 224 val_224 137 val_137 0 val_0 369 val_369 316 val_316 169 val_169 413 val_413 85 val_85 77 val_77 282 val_282 490 val_490 87 val_87 364 val_364 179 val_179 118 val_118 134 val_134 395 val_395 51 val_51 12 val_12 241 val_241 83 val_83 333 val_333 180 val_180 284 val_284 137 val_137 230 val_230 181 val_181 67 val_67 260 val_260 404 val_404 384 val_384 489 val_489 353 val_353 278 val_278 138 val_138 103 val_103 239 val_239 213 val_213 216 val_216 430 val_430 275 val_275 176 val_176 289 val_289 221 val_221 65 val_65 318 val_318 332 val_332 311 val_311 199 val_199 0 val_0 172 val_172 42 val_42 129 val_129 158 val_158 119 val_119 496 val_496 179 val_179 322 val_322 197 val_197 468 val_468 393 val_393 454 val_454 100 val_100 298 val_298 373 val_373 58 val_58 272 val_272 138 val_138 217 val_217 84 val_84 348 val_348 466 val_466 431 val_431 8 val_8 411 val_411 230 val_230 208 val_208 348 val_348 24 val_24 463 val_463 128 val_128 288 val_288 191 val_191 5 val_5 244 val_244 438 val_438 401 val_401 467 val_467 432 val_432 202 val_202 316 val_316 229 val_229 469 val_469 463 val_463 280 val_280 239 val_239 216 val_216 367 val_367 344 val_344 167 val_167 274 val_274 219 val_219 480 val_480 485 val_485 116 val_116 223 val_223 256 val_256 263 val_263 70 val_70 487 val_487 113 val_113 406 val_406 105 val_105 257 val_257 406 val_406 409 val_409 190 val_190 53 val_53 401 val_401 114 val_114 258 val_258 90 val_90 203 val_203 262 val_262 348 val_348 2 val_2 193 val_193 35 val_35 283 val_283 331 val_331 235 val_235 80 val_80 44 val_44 483 val_483 321 val_321 335 val_335 104 val_104 466 val_466 366 val_366 175 val_175 403 val_403 424 val_424 11 val_11 395 val_395 58 val_58 35 val_35 336 val_336 95 val_95 317 val_317 168 val_168 34 val_34 229 val_229 233 val_233 143 val_143 472 val_472 322 val_322 498 val_498 401 val_401 327 val_327 242 val_242 369 val_369 392 val_392 272 val_272 331 val_331 396 val_396 242 val_242 452 val_452 177 val_177 226 val_226 5 val_5 497 val_497 402 val_402 296 val_296 76 val_76 138 val_138 453 val_453 30 val_30 209 val_209 64 val_64 468 val_468 228 val_228 74 val_74 342 val_342 69 val_69 230 val_230 33 val_33 368 val_368 103 val_103 160 val_160 458 val_458 195 val_195 42 val_42 321 val_321 430 val_430 119 val_119 489 val_489 218 val_218 78 val_78 76 val_76 41 val_41 223 val_223 492 val_492 149 val_149 449 val_449 389 val_389 492 val_492 67 val_67 384 val_384 379 val_379 18 val_18 462 val_462 134 val_134 100 val_100 298 val_298 9 val_9 341 val_341 498 val_498 146 val_146 458 val_458 362 val_362 189 val_189 214 val_214 462 val_462 233 val_233 406 val_406 133 val_133 175 val_175 26 val_26 454 val_454 375 val_375 401 val_401 421 val_421 407 val_407 384 val_384 256 val_256 172 val_172 222 val_222 348 val_348 307 val_307 194 val_194 414 val_414 477 val_477 152 val_152 126 val_126 90 val_90 169 val_169 403 val_403 400 val_400 200 val_200 97 val_97 186 val_186 281 val_281 285 val_285 348 val_348 167 val_167 18 val_18 273 val_273 183 val_183 448 val_448 344 val_344 97 val_97 469 val_469 315 val_315 84 val_84 28 val_28 37 val_37 12 val_12 255 val_255 397 val_397 480 val_480 291 val_291 24 val_24 351 val_351 70 val_70 104 val_104 70 val_70 163 val_163 438 val_438 119 val_119 414 val_414 200 val_200 491 val_491 478 val_478 396 val_396 201 val_201 217 val_217 164 val_164 431 val_431 454 val_454 5 val_5 298 val_298 125 val_125 431 val_431 164 val_164 424 val_424 187 val_187 382 val_382 353 val_353 493 val_493 478 val_478 178 val_178 468 val_468 310 val_310 317 val_317 333 val_333 230 val_230 460 val_460 207 val_207 249 val_249 265 val_265 480 val_480 83 val_83 136 val_136 237 val_237 199 val_199 439 val_439 360 val_360 248 val_248 479 val_479 305 val_305 417 val_417 277 val_277 444 val_444 120 val_120 429 val_429 169 val_169 443 val_443 323 val_323 325 val_325 238 val_238 311 val_311 203 val_203 339 val_339 0 val_0 455 val_455 128 val_128 155 val_155 316 val_316 57 val_57 302 val_302 205 val_205 149 val_149 438 val_438 345 val_345 129 val_129 439 val_439 162 val_162 377 val_377 397 val_397 309 val_309 365 val_365 266 val_266 113 val_113 342 val_342 367 val_367 325 val_325 167 val_167 195 val_195 475 val_475 17 val_17 489 val_489 386 val_386 399 val_399 169 val_169 382 val_382 498 val_498 125 val_125 356 val_356 437 val_437 469 val_469 192 val_192 286 val_286 187 val_187 176 val_176 54 val_54 170 val_170 111 val_111 20 val_20 489 val_489 157 val_157 378 val_378 221 val_221 92 val_92 208 val_208 47 val_47 72 val_72 4 val_4 280 val_280 35 val_35 427 val_427 277 val_277 459 val_459 429 val_429 66 val_66 128 val_128 213 val_213 146 val_146 406 val_406 369 val_369 374 val_374 152 val_152 469 val_469 145 val_145 495 val_495 37 val_37 327 val_327 281 val_281 278 val_278 86 val_86 311 val_311 27 val_27 165 val_165 409 val_409 255 val_255 224 val_224 98 val_98 484 val_484 265 val_265 193 val_193 401 val_401 150 val_150 273 val_273 417 val_417 207 val_207 394 val_394 237 val_237 482 val_482 174 val_174 413 val_413 494 val_494 459 val_459 199 val_199 466 val_466 208 val_208 174 val_174 399 val_399 396 val_396 247 val_247 277 val_277 430 val_430 209 val_209 15 val_15 82 val_82 403 val_403 166 val_166 417 val_417 446 val_446 252 val_252 292 val_292 219 val_219 287 val_287 153 val_153 193 val_193 338 val_338 309 val_309 457 val_457 308 val_308 95 val_95 196 val_196 288 val_288 481 val_481 468 val_468 98 val_98 282 val_282 197 val_197 187 val_187 318 val_318 318 val_318 409 val_409 470 val_470 205 val_205 418 val_418 96 val_96 26 val_26 165 val_165 327 val_327 230 val_230 469 val_469 120 val_120 131 val_131 51 val_51 404 val_404 43 val_43 436 val_436 156 val_156 191 val_191 307 val_307 238 val_238 419 val_419 15 val_15 118 val_118 72 val_72 90 val_90 138 val_138 19 val_19 435 val_435 10 val_10 277 val_277 273 val_273 306 val_306 224 val_224 137 val_137 0 val_0 369 val_369 316 val_316 169 val_169 413 val_413 85 val_85 77 val_77 282 val_282 490 val_490 87 val_87 364 val_364 179 val_179 118 val_118 134 val_134 395 val_395 51 val_51 12 val_12 241 val_241 83 val_83 333 val_333 180 val_180 284 val_284 137 val_137 230 val_230 181 val_181 67 val_67 260 val_260 404 val_404 384 val_384 489 val_489 353 val_353 278 val_278 138 val_138 103 val_103 239 val_239 213 val_213 216 val_216 430 val_430 275 val_275 176 val_176 289 val_289 221 val_221 65 val_65 318 val_318 332 val_332 311 val_311 199 val_199 0 val_0 172 val_172 42 val_42 129 val_129 158 val_158 119 val_119 496 val_496 179 val_179 322 val_322 197 val_197 468 val_468 393 val_393 454 val_454 100 val_100 298 val_298 373 val_373 58 val_58 272 val_272 138 val_138 217 val_217 84 val_84 348 val_348 466 val_466 431 val_431 8 val_8 411 val_411 230 val_230 208 val_208 348 val_348 24 val_24 463 val_463 PREHOOK: query: create table merge_src_part2 like merge_src_part PREHOOK: type: CREATETABLE POSTHOOK: query: create table merge_src_part2 like merge_src_part POSTHOOK: type: CREATETABLE POSTHOOK: Output: default@merge_src_part2 POSTHOOK: Lineage: merge_src_part PARTITION(ds=2008-04-08).key SIMPLE [(srcpart)srcpart.FieldSchema(name:ds, type:string, comment:null), ] POSTHOOK: Lineage: merge_src_part PARTITION(ds=2008-04-08).value SIMPLE [(srcpart)srcpart.FieldSchema(name:hr, type:string, comment:null), ] POSTHOOK: Lineage: merge_src_part PARTITION(ds=2008-04-09).key SIMPLE [(srcpart)srcpart.FieldSchema(name:ds, type:string, comment:null), ] POSTHOOK: Lineage: merge_src_part PARTITION(ds=2008-04-09).value SIMPLE [(srcpart)srcpart.FieldSchema(name:hr, type:string, comment:null), ] PREHOOK: query: explain extended insert overwrite table merge_src_part2 partition(ds) select key, value, ds from merge_src_part where ds is not null PREHOOK: type: QUERY POSTHOOK: query: explain extended insert overwrite table merge_src_part2 partition(ds) select key, value, ds from merge_src_part where ds is not null POSTHOOK: type: QUERY POSTHOOK: Lineage: merge_src_part PARTITION(ds=2008-04-08).key SIMPLE [(srcpart)srcpart.FieldSchema(name:ds, type:string, comment:null), ] POSTHOOK: Lineage: merge_src_part PARTITION(ds=2008-04-08).value SIMPLE [(srcpart)srcpart.FieldSchema(name:hr, type:string, comment:null), ] POSTHOOK: Lineage: merge_src_part PARTITION(ds=2008-04-09).key SIMPLE [(srcpart)srcpart.FieldSchema(name:ds, type:string, comment:null), ] POSTHOOK: Lineage: merge_src_part PARTITION(ds=2008-04-09).value SIMPLE [(srcpart)srcpart.FieldSchema(name:hr, type:string, comment:null), ] ABSTRACT SYNTAX TREE: (TOK_QUERY (TOK_FROM (TOK_TABREF merge_src_part)) (TOK_INSERT (TOK_DESTINATION (TOK_TAB merge_src_part2 (TOK_PARTSPEC (TOK_PARTVAL ds)))) (TOK_SELECT (TOK_SELEXPR (TOK_TABLE_OR_COL key)) (TOK_SELEXPR (TOK_TABLE_OR_COL value)) (TOK_SELEXPR (TOK_TABLE_OR_COL ds))) (TOK_WHERE (TOK_FUNCTION TOK_ISNOTNULL (TOK_TABLE_OR_COL ds))))) STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 STAGE PLANS: Stage: Stage-1 Map Reduce Alias -> Map Operator Tree: merge_src_part TableScan alias: merge_src_part Filter Operator isSamplingPred: false predicate: expr: ds is not null type: boolean Filter Operator isSamplingPred: false predicate: expr: ds is not null type: boolean Select Operator expressions: expr: key type: string expr: value type: string expr: ds type: string outputColumnNames: _col0, _col1, _col2 File Output Operator compressed: false GlobalTableId: 1 directory: file:/data/users/nzhang/reviews/0.6/branch-0.6/build/ql/scratchdir/hive_2010-08-21_23-31-10_714_4139053116306049881/10000 NumFilesPerFileSink: 1 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat properties: EXTERNAL FALSE bucket_count -1 columns key,value columns.types string:string file.inputformat org.apache.hadoop.mapred.TextInputFormat file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat location file:/data/users/nzhang/reviews/0.6/branch-0.6/build/ql/test/data/warehouse/merge_src_part2 name merge_src_part2 partition_columns ds serialization.ddl struct merge_src_part2 { string key, string value} serialization.format 1 serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe transient_lastDdlTime 1282458670 serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe name: merge_src_part2 TotalFiles: 1 MultiFileSpray: false Needs Tagging: false Path -> Alias: file:/data/users/nzhang/reviews/0.6/branch-0.6/build/ql/test/data/warehouse/merge_src_part/ds=2008-04-08 [merge_src_part] file:/data/users/nzhang/reviews/0.6/branch-0.6/build/ql/test/data/warehouse/merge_src_part/ds=2008-04-09 [merge_src_part] Path -> Partition: file:/data/users/nzhang/reviews/0.6/branch-0.6/build/ql/test/data/warehouse/merge_src_part/ds=2008-04-08 Partition base file name: ds=2008-04-08 input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat partition values: ds 2008-04-08 properties: bucket_count -1 columns key,value columns.types string:string file.inputformat org.apache.hadoop.mapred.TextInputFormat file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat location file:/data/users/nzhang/reviews/0.6/branch-0.6/build/ql/test/data/warehouse/merge_src_part name merge_src_part partition_columns ds serialization.ddl struct merge_src_part { string key, string value} serialization.format 1 serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe transient_lastDdlTime 1282458659 serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat properties: bucket_count -1 columns key,value columns.types string:string file.inputformat org.apache.hadoop.mapred.TextInputFormat file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat location file:/data/users/nzhang/reviews/0.6/branch-0.6/build/ql/test/data/warehouse/merge_src_part name merge_src_part partition_columns ds serialization.ddl struct merge_src_part { string key, string value} serialization.format 1 serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe transient_lastDdlTime 1282458659 serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe name: merge_src_part name: merge_src_part file:/data/users/nzhang/reviews/0.6/branch-0.6/build/ql/test/data/warehouse/merge_src_part/ds=2008-04-09 Partition base file name: ds=2008-04-09 input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat partition values: ds 2008-04-09 properties: bucket_count -1 columns key,value columns.types string:string file.inputformat org.apache.hadoop.mapred.TextInputFormat file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat location file:/data/users/nzhang/reviews/0.6/branch-0.6/build/ql/test/data/warehouse/merge_src_part name merge_src_part partition_columns ds serialization.ddl struct merge_src_part { string key, string value} serialization.format 1 serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe transient_lastDdlTime 1282458659 serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat properties: bucket_count -1 columns key,value columns.types string:string file.inputformat org.apache.hadoop.mapred.TextInputFormat file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat location file:/data/users/nzhang/reviews/0.6/branch-0.6/build/ql/test/data/warehouse/merge_src_part name merge_src_part partition_columns ds serialization.ddl struct merge_src_part { string key, string value} serialization.format 1 serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe transient_lastDdlTime 1282458659 serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe name: merge_src_part name: merge_src_part Stage: Stage-0 Move Operator tables: partition: ds replace: true source: file:/data/users/nzhang/reviews/0.6/branch-0.6/build/ql/scratchdir/hive_2010-08-21_23-31-10_714_4139053116306049881/10000 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat properties: EXTERNAL FALSE bucket_count -1 columns key,value columns.types string:string file.inputformat org.apache.hadoop.mapred.TextInputFormat file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat location file:/data/users/nzhang/reviews/0.6/branch-0.6/build/ql/test/data/warehouse/merge_src_part2 name merge_src_part2 partition_columns ds serialization.ddl struct merge_src_part2 { string key, string value} serialization.format 1 serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe transient_lastDdlTime 1282458670 serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe name: merge_src_part2 tmp directory: file:/data/users/nzhang/reviews/0.6/branch-0.6/build/ql/scratchdir/hive_2010-08-21_23-31-10_714_4139053116306049881/10001 PREHOOK: query: insert overwrite table merge_src_part2 partition(ds) select key, value, ds from merge_src_part where ds is not null PREHOOK: type: QUERY PREHOOK: Input: default@merge_src_part@ds=2008-04-08 PREHOOK: Input: default@merge_src_part@ds=2008-04-09 POSTHOOK: query: insert overwrite table merge_src_part2 partition(ds) select key, value, ds from merge_src_part where ds is not null POSTHOOK: type: QUERY POSTHOOK: Input: default@merge_src_part@ds=2008-04-08 POSTHOOK: Input: default@merge_src_part@ds=2008-04-09 POSTHOOK: Output: default@merge_src_part2@ds=2008-04-08 POSTHOOK: Output: default@merge_src_part2@ds=2008-04-09 POSTHOOK: Lineage: merge_src_part PARTITION(ds=2008-04-08).key SIMPLE [(srcpart)srcpart.FieldSchema(name:ds, type:string, comment:null), ] POSTHOOK: Lineage: merge_src_part PARTITION(ds=2008-04-08).value SIMPLE [(srcpart)srcpart.FieldSchema(name:hr, type:string, comment:null), ] POSTHOOK: Lineage: merge_src_part PARTITION(ds=2008-04-09).key SIMPLE [(srcpart)srcpart.FieldSchema(name:ds, type:string, comment:null), ] POSTHOOK: Lineage: merge_src_part PARTITION(ds=2008-04-09).value SIMPLE [(srcpart)srcpart.FieldSchema(name:hr, type:string, comment:null), ] POSTHOOK: Lineage: merge_src_part2 PARTITION(ds=2008-04-08).key SIMPLE [(merge_src_part)merge_src_part.FieldSchema(name:ds, type:string, comment:null), ] POSTHOOK: Lineage: merge_src_part2 PARTITION(ds=2008-04-08).value SIMPLE [(merge_src_part)merge_src_part.FieldSchema(name:key, type:string, comment:null), ] POSTHOOK: Lineage: merge_src_part2 PARTITION(ds=2008-04-09).key SIMPLE [(merge_src_part)merge_src_part.FieldSchema(name:ds, type:string, comment:null), ] POSTHOOK: Lineage: merge_src_part2 PARTITION(ds=2008-04-09).value SIMPLE [(merge_src_part)merge_src_part.FieldSchema(name:key, type:string, comment:null), ] PREHOOK: query: show partitions merge_src_part2 PREHOOK: type: SHOWPARTITIONS POSTHOOK: query: show partitions merge_src_part2 POSTHOOK: type: SHOWPARTITIONS POSTHOOK: Lineage: merge_src_part PARTITION(ds=2008-04-08).key SIMPLE [(srcpart)srcpart.FieldSchema(name:ds, type:string, comment:null), ] POSTHOOK: Lineage: merge_src_part PARTITION(ds=2008-04-08).value SIMPLE [(srcpart)srcpart.FieldSchema(name:hr, type:string, comment:null), ] POSTHOOK: Lineage: merge_src_part PARTITION(ds=2008-04-09).key SIMPLE [(srcpart)srcpart.FieldSchema(name:ds, type:string, comment:null), ] POSTHOOK: Lineage: merge_src_part PARTITION(ds=2008-04-09).value SIMPLE [(srcpart)srcpart.FieldSchema(name:hr, type:string, comment:null), ] POSTHOOK: Lineage: merge_src_part2 PARTITION(ds=2008-04-08).key SIMPLE [(merge_src_part)merge_src_part.FieldSchema(name:ds, type:string, comment:null), ] POSTHOOK: Lineage: merge_src_part2 PARTITION(ds=2008-04-08).value SIMPLE [(merge_src_part)merge_src_part.FieldSchema(name:key, type:string, comment:null), ] POSTHOOK: Lineage: merge_src_part2 PARTITION(ds=2008-04-09).key SIMPLE [(merge_src_part)merge_src_part.FieldSchema(name:ds, type:string, comment:null), ] POSTHOOK: Lineage: merge_src_part2 PARTITION(ds=2008-04-09).value SIMPLE [(merge_src_part)merge_src_part.FieldSchema(name:key, type:string, comment:null), ] ds=2008-04-08 ds=2008-04-09 PREHOOK: query: select * from merge_src_part2 where ds is not null PREHOOK: type: QUERY PREHOOK: Input: default@merge_src_part2@ds=2008-04-08 PREHOOK: Input: default@merge_src_part2@ds=2008-04-09 PREHOOK: Output: file:/tmp/nzhang/hive_2010-08-21_23-31-14_288_2121207369020168571/10000 POSTHOOK: query: select * from merge_src_part2 where ds is not null POSTHOOK: type: QUERY POSTHOOK: Input: default@merge_src_part2@ds=2008-04-08 POSTHOOK: Input: default@merge_src_part2@ds=2008-04-09 POSTHOOK: Output: file:/tmp/nzhang/hive_2010-08-21_23-31-14_288_2121207369020168571/10000 POSTHOOK: Lineage: merge_src_part PARTITION(ds=2008-04-08).key SIMPLE [(srcpart)srcpart.FieldSchema(name:ds, type:string, comment:null), ] POSTHOOK: Lineage: merge_src_part PARTITION(ds=2008-04-08).value SIMPLE [(srcpart)srcpart.FieldSchema(name:hr, type:string, comment:null), ] POSTHOOK: Lineage: merge_src_part PARTITION(ds=2008-04-09).key SIMPLE [(srcpart)srcpart.FieldSchema(name:ds, type:string, comment:null), ] POSTHOOK: Lineage: merge_src_part PARTITION(ds=2008-04-09).value SIMPLE [(srcpart)srcpart.FieldSchema(name:hr, type:string, comment:null), ] POSTHOOK: Lineage: merge_src_part2 PARTITION(ds=2008-04-08).key SIMPLE [(merge_src_part)merge_src_part.FieldSchema(name:ds, type:string, comment:null), ] POSTHOOK: Lineage: merge_src_part2 PARTITION(ds=2008-04-08).value SIMPLE [(merge_src_part)merge_src_part.FieldSchema(name:key, type:string, comment:null), ] POSTHOOK: Lineage: merge_src_part2 PARTITION(ds=2008-04-09).key SIMPLE [(merge_src_part)merge_src_part.FieldSchema(name:ds, type:string, comment:null), ] POSTHOOK: Lineage: merge_src_part2 PARTITION(ds=2008-04-09).value SIMPLE [(merge_src_part)merge_src_part.FieldSchema(name:key, type:string, comment:null), ] 238 val_238 2008-04-08 86 val_86 2008-04-08 311 val_311 2008-04-08 27 val_27 2008-04-08 165 val_165 2008-04-08 409 val_409 2008-04-08 255 val_255 2008-04-08 278 val_278 2008-04-08 98 val_98 2008-04-08 484 val_484 2008-04-08 265 val_265 2008-04-08 193 val_193 2008-04-08 401 val_401 2008-04-08 150 val_150 2008-04-08 273 val_273 2008-04-08 224 val_224 2008-04-08 369 val_369 2008-04-08 66 val_66 2008-04-08 128 val_128 2008-04-08 213 val_213 2008-04-08 146 val_146 2008-04-08 406 val_406 2008-04-08 429 val_429 2008-04-08 374 val_374 2008-04-08 152 val_152 2008-04-08 469 val_469 2008-04-08 145 val_145 2008-04-08 495 val_495 2008-04-08 37 val_37 2008-04-08 327 val_327 2008-04-08 281 val_281 2008-04-08 277 val_277 2008-04-08 209 val_209 2008-04-08 15 val_15 2008-04-08 82 val_82 2008-04-08 403 val_403 2008-04-08 166 val_166 2008-04-08 417 val_417 2008-04-08 430 val_430 2008-04-08 252 val_252 2008-04-08 292 val_292 2008-04-08 219 val_219 2008-04-08 287 val_287 2008-04-08 153 val_153 2008-04-08 193 val_193 2008-04-08 338 val_338 2008-04-08 446 val_446 2008-04-08 459 val_459 2008-04-08 394 val_394 2008-04-08 237 val_237 2008-04-08 482 val_482 2008-04-08 174 val_174 2008-04-08 413 val_413 2008-04-08 494 val_494 2008-04-08 207 val_207 2008-04-08 199 val_199 2008-04-08 466 val_466 2008-04-08 208 val_208 2008-04-08 174 val_174 2008-04-08 399 val_399 2008-04-08 396 val_396 2008-04-08 247 val_247 2008-04-08 417 val_417 2008-04-08 489 val_489 2008-04-08 162 val_162 2008-04-08 377 val_377 2008-04-08 397 val_397 2008-04-08 309 val_309 2008-04-08 365 val_365 2008-04-08 266 val_266 2008-04-08 439 val_439 2008-04-08 342 val_342 2008-04-08 367 val_367 2008-04-08 325 val_325 2008-04-08 167 val_167 2008-04-08 195 val_195 2008-04-08 475 val_475 2008-04-08 17 val_17 2008-04-08 113 val_113 2008-04-08 155 val_155 2008-04-08 203 val_203 2008-04-08 339 val_339 2008-04-08 0 val_0 2008-04-08 455 val_455 2008-04-08 128 val_128 2008-04-08 311 val_311 2008-04-08 316 val_316 2008-04-08 57 val_57 2008-04-08 302 val_302 2008-04-08 205 val_205 2008-04-08 149 val_149 2008-04-08 438 val_438 2008-04-08 345 val_345 2008-04-08 129 val_129 2008-04-08 170 val_170 2008-04-08 20 val_20 2008-04-08 489 val_489 2008-04-08 157 val_157 2008-04-08 378 val_378 2008-04-08 221 val_221 2008-04-08 92 val_92 2008-04-08 111 val_111 2008-04-08 47 val_47 2008-04-08 72 val_72 2008-04-08 4 val_4 2008-04-08 280 val_280 2008-04-08 35 val_35 2008-04-08 427 val_427 2008-04-08 277 val_277 2008-04-08 208 val_208 2008-04-08 356 val_356 2008-04-08 399 val_399 2008-04-08 169 val_169 2008-04-08 382 val_382 2008-04-08 498 val_498 2008-04-08 125 val_125 2008-04-08 386 val_386 2008-04-08 437 val_437 2008-04-08 469 val_469 2008-04-08 192 val_192 2008-04-08 286 val_286 2008-04-08 187 val_187 2008-04-08 176 val_176 2008-04-08 54 val_54 2008-04-08 459 val_459 2008-04-08 51 val_51 2008-04-08 138 val_138 2008-04-08 103 val_103 2008-04-08 239 val_239 2008-04-08 213 val_213 2008-04-08 216 val_216 2008-04-08 430 val_430 2008-04-08 278 val_278 2008-04-08 176 val_176 2008-04-08 289 val_289 2008-04-08 221 val_221 2008-04-08 65 val_65 2008-04-08 318 val_318 2008-04-08 332 val_332 2008-04-08 311 val_311 2008-04-08 275 val_275 2008-04-08 137 val_137 2008-04-08 241 val_241 2008-04-08 83 val_83 2008-04-08 333 val_333 2008-04-08 180 val_180 2008-04-08 284 val_284 2008-04-08 12 val_12 2008-04-08 230 val_230 2008-04-08 181 val_181 2008-04-08 67 val_67 2008-04-08 260 val_260 2008-04-08 404 val_404 2008-04-08 384 val_384 2008-04-08 489 val_489 2008-04-08 353 val_353 2008-04-08 373 val_373 2008-04-08 272 val_272 2008-04-08 138 val_138 2008-04-08 217 val_217 2008-04-08 84 val_84 2008-04-08 348 val_348 2008-04-08 466 val_466 2008-04-08 58 val_58 2008-04-08 8 val_8 2008-04-08 411 val_411 2008-04-08 230 val_230 2008-04-08 208 val_208 2008-04-08 348 val_348 2008-04-08 24 val_24 2008-04-08 463 val_463 2008-04-08 431 val_431 2008-04-08 179 val_179 2008-04-08 172 val_172 2008-04-08 42 val_42 2008-04-08 129 val_129 2008-04-08 158 val_158 2008-04-08 119 val_119 2008-04-08 496 val_496 2008-04-08 0 val_0 2008-04-08 322 val_322 2008-04-08 197 val_197 2008-04-08 468 val_468 2008-04-08 393 val_393 2008-04-08 454 val_454 2008-04-08 100 val_100 2008-04-08 298 val_298 2008-04-08 199 val_199 2008-04-08 191 val_191 2008-04-08 418 val_418 2008-04-08 96 val_96 2008-04-08 26 val_26 2008-04-08 165 val_165 2008-04-08 327 val_327 2008-04-08 230 val_230 2008-04-08 205 val_205 2008-04-08 120 val_120 2008-04-08 131 val_131 2008-04-08 51 val_51 2008-04-08 404 val_404 2008-04-08 43 val_43 2008-04-08 436 val_436 2008-04-08 156 val_156 2008-04-08 469 val_469 2008-04-08 468 val_468 2008-04-08 308 val_308 2008-04-08 95 val_95 2008-04-08 196 val_196 2008-04-08 288 val_288 2008-04-08 481 val_481 2008-04-08 457 val_457 2008-04-08 98 val_98 2008-04-08 282 val_282 2008-04-08 197 val_197 2008-04-08 187 val_187 2008-04-08 318 val_318 2008-04-08 318 val_318 2008-04-08 409 val_409 2008-04-08 470 val_470 2008-04-08 137 val_137 2008-04-08 369 val_369 2008-04-08 316 val_316 2008-04-08 169 val_169 2008-04-08 413 val_413 2008-04-08 85 val_85 2008-04-08 77 val_77 2008-04-08 0 val_0 2008-04-08 490 val_490 2008-04-08 87 val_87 2008-04-08 364 val_364 2008-04-08 179 val_179 2008-04-08 118 val_118 2008-04-08 134 val_134 2008-04-08 395 val_395 2008-04-08 282 val_282 2008-04-08 138 val_138 2008-04-08 238 val_238 2008-04-08 419 val_419 2008-04-08 15 val_15 2008-04-08 118 val_118 2008-04-08 72 val_72 2008-04-08 90 val_90 2008-04-08 307 val_307 2008-04-08 19 val_19 2008-04-08 435 val_435 2008-04-08 10 val_10 2008-04-08 277 val_277 2008-04-08 273 val_273 2008-04-08 306 val_306 2008-04-08 224 val_224 2008-04-08 309 val_309 2008-04-08 389 val_389 2008-04-08 327 val_327 2008-04-08 242 val_242 2008-04-08 369 val_369 2008-04-08 392 val_392 2008-04-08 272 val_272 2008-04-08 331 val_331 2008-04-08 401 val_401 2008-04-08 242 val_242 2008-04-08 452 val_452 2008-04-08 177 val_177 2008-04-08 226 val_226 2008-04-08 5 val_5 2008-04-08 497 val_497 2008-04-08 402 val_402 2008-04-08 396 val_396 2008-04-08 317 val_317 2008-04-08 395 val_395 2008-04-08 58 val_58 2008-04-08 35 val_35 2008-04-08 336 val_336 2008-04-08 95 val_95 2008-04-08 11 val_11 2008-04-08 168 val_168 2008-04-08 34 val_34 2008-04-08 229 val_229 2008-04-08 233 val_233 2008-04-08 143 val_143 2008-04-08 472 val_472 2008-04-08 322 val_322 2008-04-08 498 val_498 2008-04-08 160 val_160 2008-04-08 195 val_195 2008-04-08 42 val_42 2008-04-08 321 val_321 2008-04-08 430 val_430 2008-04-08 119 val_119 2008-04-08 489 val_489 2008-04-08 458 val_458 2008-04-08 78 val_78 2008-04-08 76 val_76 2008-04-08 41 val_41 2008-04-08 223 val_223 2008-04-08 492 val_492 2008-04-08 149 val_149 2008-04-08 449 val_449 2008-04-08 218 val_218 2008-04-08 228 val_228 2008-04-08 138 val_138 2008-04-08 453 val_453 2008-04-08 30 val_30 2008-04-08 209 val_209 2008-04-08 64 val_64 2008-04-08 468 val_468 2008-04-08 76 val_76 2008-04-08 74 val_74 2008-04-08 342 val_342 2008-04-08 69 val_69 2008-04-08 230 val_230 2008-04-08 33 val_33 2008-04-08 368 val_368 2008-04-08 103 val_103 2008-04-08 296 val_296 2008-04-08 113 val_113 2008-04-08 216 val_216 2008-04-08 367 val_367 2008-04-08 344 val_344 2008-04-08 167 val_167 2008-04-08 274 val_274 2008-04-08 219 val_219 2008-04-08 239 val_239 2008-04-08 485 val_485 2008-04-08 116 val_116 2008-04-08 223 val_223 2008-04-08 256 val_256 2008-04-08 263 val_263 2008-04-08 70 val_70 2008-04-08 487 val_487 2008-04-08 480 val_480 2008-04-08 401 val_401 2008-04-08 288 val_288 2008-04-08 191 val_191 2008-04-08 5 val_5 2008-04-08 244 val_244 2008-04-08 438 val_438 2008-04-08 128 val_128 2008-04-08 467 val_467 2008-04-08 432 val_432 2008-04-08 202 val_202 2008-04-08 316 val_316 2008-04-08 229 val_229 2008-04-08 469 val_469 2008-04-08 463 val_463 2008-04-08 280 val_280 2008-04-08 2 val_2 2008-04-08 35 val_35 2008-04-08 283 val_283 2008-04-08 331 val_331 2008-04-08 235 val_235 2008-04-08 80 val_80 2008-04-08 44 val_44 2008-04-08 193 val_193 2008-04-08 321 val_321 2008-04-08 335 val_335 2008-04-08 104 val_104 2008-04-08 466 val_466 2008-04-08 366 val_366 2008-04-08 175 val_175 2008-04-08 403 val_403 2008-04-08 483 val_483 2008-04-08 53 val_53 2008-04-08 105 val_105 2008-04-08 257 val_257 2008-04-08 406 val_406 2008-04-08 409 val_409 2008-04-08 190 val_190 2008-04-08 406 val_406 2008-04-08 401 val_401 2008-04-08 114 val_114 2008-04-08 258 val_258 2008-04-08 90 val_90 2008-04-08 203 val_203 2008-04-08 262 val_262 2008-04-08 348 val_348 2008-04-08 424 val_424 2008-04-08 12 val_12 2008-04-08 396 val_396 2008-04-08 201 val_201 2008-04-08 217 val_217 2008-04-08 164 val_164 2008-04-08 431 val_431 2008-04-08 454 val_454 2008-04-08 478 val_478 2008-04-08 298 val_298 2008-04-08 125 val_125 2008-04-08 431 val_431 2008-04-08 164 val_164 2008-04-08 424 val_424 2008-04-08 187 val_187 2008-04-08 382 val_382 2008-04-08 5 val_5 2008-04-08 70 val_70 2008-04-08 397 val_397 2008-04-08 480 val_480 2008-04-08 291 val_291 2008-04-08 24 val_24 2008-04-08 351 val_351 2008-04-08 255 val_255 2008-04-08 104 val_104 2008-04-08 70 val_70 2008-04-08 163 val_163 2008-04-08 438 val_438 2008-04-08 119 val_119 2008-04-08 414 val_414 2008-04-08 200 val_200 2008-04-08 491 val_491 2008-04-08 237 val_237 2008-04-08 439 val_439 2008-04-08 360 val_360 2008-04-08 248 val_248 2008-04-08 479 val_479 2008-04-08 305 val_305 2008-04-08 417 val_417 2008-04-08 199 val_199 2008-04-08 444 val_444 2008-04-08 120 val_120 2008-04-08 429 val_429 2008-04-08 169 val_169 2008-04-08 443 val_443 2008-04-08 323 val_323 2008-04-08 325 val_325 2008-04-08 277 val_277 2008-04-08 230 val_230 2008-04-08 478 val_478 2008-04-08 178 val_178 2008-04-08 468 val_468 2008-04-08 310 val_310 2008-04-08 317 val_317 2008-04-08 333 val_333 2008-04-08 493 val_493 2008-04-08 460 val_460 2008-04-08 207 val_207 2008-04-08 249 val_249 2008-04-08 265 val_265 2008-04-08 480 val_480 2008-04-08 83 val_83 2008-04-08 136 val_136 2008-04-08 353 val_353 2008-04-08 172 val_172 2008-04-08 214 val_214 2008-04-08 462 val_462 2008-04-08 233 val_233 2008-04-08 406 val_406 2008-04-08 133 val_133 2008-04-08 175 val_175 2008-04-08 189 val_189 2008-04-08 454 val_454 2008-04-08 375 val_375 2008-04-08 401 val_401 2008-04-08 421 val_421 2008-04-08 407 val_407 2008-04-08 384 val_384 2008-04-08 256 val_256 2008-04-08 26 val_26 2008-04-08 134 val_134 2008-04-08 67 val_67 2008-04-08 384 val_384 2008-04-08 379 val_379 2008-04-08 18 val_18 2008-04-08 462 val_462 2008-04-08 492 val_492 2008-04-08 100 val_100 2008-04-08 298 val_298 2008-04-08 9 val_9 2008-04-08 341 val_341 2008-04-08 498 val_498 2008-04-08 146 val_146 2008-04-08 458 val_458 2008-04-08 362 val_362 2008-04-08 186 val_186 2008-04-08 285 val_285 2008-04-08 348 val_348 2008-04-08 167 val_167 2008-04-08 18 val_18 2008-04-08 273 val_273 2008-04-08 183 val_183 2008-04-08 281 val_281 2008-04-08 344 val_344 2008-04-08 97 val_97 2008-04-08 469 val_469 2008-04-08 315 val_315 2008-04-08 84 val_84 2008-04-08 28 val_28 2008-04-08 37 val_37 2008-04-08 448 val_448 2008-04-08 152 val_152 2008-04-08 348 val_348 2008-04-08 307 val_307 2008-04-08 194 val_194 2008-04-08 414 val_414 2008-04-08 477 val_477 2008-04-08 222 val_222 2008-04-08 126 val_126 2008-04-08 90 val_90 2008-04-08 169 val_169 2008-04-08 403 val_403 2008-04-08 400 val_400 2008-04-08 200 val_200 2008-04-08 97 val_97 2008-04-08 238 val_238 2008-04-08 86 val_86 2008-04-08 311 val_311 2008-04-08 27 val_27 2008-04-08 165 val_165 2008-04-08 409 val_409 2008-04-08 255 val_255 2008-04-08 278 val_278 2008-04-08 98 val_98 2008-04-08 484 val_484 2008-04-08 265 val_265 2008-04-08 193 val_193 2008-04-08 401 val_401 2008-04-08 150 val_150 2008-04-08 273 val_273 2008-04-08 224 val_224 2008-04-08 369 val_369 2008-04-08 66 val_66 2008-04-08 128 val_128 2008-04-08 213 val_213 2008-04-08 146 val_146 2008-04-08 406 val_406 2008-04-08 429 val_429 2008-04-08 374 val_374 2008-04-08 152 val_152 2008-04-08 469 val_469 2008-04-08 145 val_145 2008-04-08 495 val_495 2008-04-08 37 val_37 2008-04-08 327 val_327 2008-04-08 281 val_281 2008-04-08 277 val_277 2008-04-08 209 val_209 2008-04-08 15 val_15 2008-04-08 82 val_82 2008-04-08 403 val_403 2008-04-08 166 val_166 2008-04-08 417 val_417 2008-04-08 430 val_430 2008-04-08 252 val_252 2008-04-08 292 val_292 2008-04-08 219 val_219 2008-04-08 287 val_287 2008-04-08 153 val_153 2008-04-08 193 val_193 2008-04-08 338 val_338 2008-04-08 446 val_446 2008-04-08 459 val_459 2008-04-08 394 val_394 2008-04-08 237 val_237 2008-04-08 482 val_482 2008-04-08 174 val_174 2008-04-08 413 val_413 2008-04-08 494 val_494 2008-04-08 207 val_207 2008-04-08 199 val_199 2008-04-08 466 val_466 2008-04-08 208 val_208 2008-04-08 174 val_174 2008-04-08 399 val_399 2008-04-08 396 val_396 2008-04-08 247 val_247 2008-04-08 417 val_417 2008-04-08 489 val_489 2008-04-08 162 val_162 2008-04-08 377 val_377 2008-04-08 397 val_397 2008-04-08 309 val_309 2008-04-08 365 val_365 2008-04-08 266 val_266 2008-04-08 439 val_439 2008-04-08 342 val_342 2008-04-08 367 val_367 2008-04-08 325 val_325 2008-04-08 167 val_167 2008-04-08 195 val_195 2008-04-08 475 val_475 2008-04-08 17 val_17 2008-04-08 113 val_113 2008-04-08 155 val_155 2008-04-08 203 val_203 2008-04-08 339 val_339 2008-04-08 0 val_0 2008-04-08 455 val_455 2008-04-08 128 val_128 2008-04-08 311 val_311 2008-04-08 316 val_316 2008-04-08 57 val_57 2008-04-08 302 val_302 2008-04-08 205 val_205 2008-04-08 149 val_149 2008-04-08 438 val_438 2008-04-08 345 val_345 2008-04-08 129 val_129 2008-04-08 170 val_170 2008-04-08 20 val_20 2008-04-08 489 val_489 2008-04-08 157 val_157 2008-04-08 378 val_378 2008-04-08 221 val_221 2008-04-08 92 val_92 2008-04-08 111 val_111 2008-04-08 47 val_47 2008-04-08 72 val_72 2008-04-08 4 val_4 2008-04-08 280 val_280 2008-04-08 35 val_35 2008-04-08 427 val_427 2008-04-08 277 val_277 2008-04-08 208 val_208 2008-04-08 356 val_356 2008-04-08 399 val_399 2008-04-08 169 val_169 2008-04-08 382 val_382 2008-04-08 498 val_498 2008-04-08 125 val_125 2008-04-08 386 val_386 2008-04-08 437 val_437 2008-04-08 469 val_469 2008-04-08 192 val_192 2008-04-08 286 val_286 2008-04-08 187 val_187 2008-04-08 176 val_176 2008-04-08 54 val_54 2008-04-08 459 val_459 2008-04-08 51 val_51 2008-04-08 138 val_138 2008-04-08 103 val_103 2008-04-08 239 val_239 2008-04-08 213 val_213 2008-04-08 216 val_216 2008-04-08 430 val_430 2008-04-08 278 val_278 2008-04-08 176 val_176 2008-04-08 289 val_289 2008-04-08 221 val_221 2008-04-08 65 val_65 2008-04-08 318 val_318 2008-04-08 332 val_332 2008-04-08 311 val_311 2008-04-08 275 val_275 2008-04-08 137 val_137 2008-04-08 241 val_241 2008-04-08 83 val_83 2008-04-08 333 val_333 2008-04-08 180 val_180 2008-04-08 284 val_284 2008-04-08 12 val_12 2008-04-08 230 val_230 2008-04-08 181 val_181 2008-04-08 67 val_67 2008-04-08 260 val_260 2008-04-08 404 val_404 2008-04-08 384 val_384 2008-04-08 489 val_489 2008-04-08 353 val_353 2008-04-08 373 val_373 2008-04-08 272 val_272 2008-04-08 138 val_138 2008-04-08 217 val_217 2008-04-08 84 val_84 2008-04-08 348 val_348 2008-04-08 466 val_466 2008-04-08 58 val_58 2008-04-08 8 val_8 2008-04-08 411 val_411 2008-04-08 230 val_230 2008-04-08 208 val_208 2008-04-08 348 val_348 2008-04-08 24 val_24 2008-04-08 463 val_463 2008-04-08 431 val_431 2008-04-08 179 val_179 2008-04-08 172 val_172 2008-04-08 42 val_42 2008-04-08 129 val_129 2008-04-08 158 val_158 2008-04-08 119 val_119 2008-04-08 496 val_496 2008-04-08 0 val_0 2008-04-08 322 val_322 2008-04-08 197 val_197 2008-04-08 468 val_468 2008-04-08 393 val_393 2008-04-08 454 val_454 2008-04-08 100 val_100 2008-04-08 298 val_298 2008-04-08 199 val_199 2008-04-08 191 val_191 2008-04-08 418 val_418 2008-04-08 96 val_96 2008-04-08 26 val_26 2008-04-08 165 val_165 2008-04-08 327 val_327 2008-04-08 230 val_230 2008-04-08 205 val_205 2008-04-08 120 val_120 2008-04-08 131 val_131 2008-04-08 51 val_51 2008-04-08 404 val_404 2008-04-08 43 val_43 2008-04-08 436 val_436 2008-04-08 156 val_156 2008-04-08 469 val_469 2008-04-08 468 val_468 2008-04-08 308 val_308 2008-04-08 95 val_95 2008-04-08 196 val_196 2008-04-08 288 val_288 2008-04-08 481 val_481 2008-04-08 457 val_457 2008-04-08 98 val_98 2008-04-08 282 val_282 2008-04-08 197 val_197 2008-04-08 187 val_187 2008-04-08 318 val_318 2008-04-08 318 val_318 2008-04-08 409 val_409 2008-04-08 470 val_470 2008-04-08 137 val_137 2008-04-08 369 val_369 2008-04-08 316 val_316 2008-04-08 169 val_169 2008-04-08 413 val_413 2008-04-08 85 val_85 2008-04-08 77 val_77 2008-04-08 0 val_0 2008-04-08 490 val_490 2008-04-08 87 val_87 2008-04-08 364 val_364 2008-04-08 179 val_179 2008-04-08 118 val_118 2008-04-08 134 val_134 2008-04-08 395 val_395 2008-04-08 282 val_282 2008-04-08 138 val_138 2008-04-08 238 val_238 2008-04-08 419 val_419 2008-04-08 15 val_15 2008-04-08 118 val_118 2008-04-08 72 val_72 2008-04-08 90 val_90 2008-04-08 307 val_307 2008-04-08 19 val_19 2008-04-08 435 val_435 2008-04-08 10 val_10 2008-04-08 277 val_277 2008-04-08 273 val_273 2008-04-08 306 val_306 2008-04-08 224 val_224 2008-04-08 309 val_309 2008-04-08 389 val_389 2008-04-08 327 val_327 2008-04-08 242 val_242 2008-04-08 369 val_369 2008-04-08 392 val_392 2008-04-08 272 val_272 2008-04-08 331 val_331 2008-04-08 401 val_401 2008-04-08 242 val_242 2008-04-08 452 val_452 2008-04-08 177 val_177 2008-04-08 226 val_226 2008-04-08 5 val_5 2008-04-08 497 val_497 2008-04-08 402 val_402 2008-04-08 396 val_396 2008-04-08 317 val_317 2008-04-08 395 val_395 2008-04-08 58 val_58 2008-04-08 35 val_35 2008-04-08 336 val_336 2008-04-08 95 val_95 2008-04-08 11 val_11 2008-04-08 168 val_168 2008-04-08 34 val_34 2008-04-08 229 val_229 2008-04-08 233 val_233 2008-04-08 143 val_143 2008-04-08 472 val_472 2008-04-08 322 val_322 2008-04-08 498 val_498 2008-04-08 160 val_160 2008-04-08 195 val_195 2008-04-08 42 val_42 2008-04-08 321 val_321 2008-04-08 430 val_430 2008-04-08 119 val_119 2008-04-08 489 val_489 2008-04-08 458 val_458 2008-04-08 78 val_78 2008-04-08 76 val_76 2008-04-08 41 val_41 2008-04-08 223 val_223 2008-04-08 492 val_492 2008-04-08 149 val_149 2008-04-08 449 val_449 2008-04-08 218 val_218 2008-04-08 228 val_228 2008-04-08 138 val_138 2008-04-08 453 val_453 2008-04-08 30 val_30 2008-04-08 209 val_209 2008-04-08 64 val_64 2008-04-08 468 val_468 2008-04-08 76 val_76 2008-04-08 74 val_74 2008-04-08 342 val_342 2008-04-08 69 val_69 2008-04-08 230 val_230 2008-04-08 33 val_33 2008-04-08 368 val_368 2008-04-08 103 val_103 2008-04-08 296 val_296 2008-04-08 113 val_113 2008-04-08 216 val_216 2008-04-08 367 val_367 2008-04-08 344 val_344 2008-04-08 167 val_167 2008-04-08 274 val_274 2008-04-08 219 val_219 2008-04-08 239 val_239 2008-04-08 485 val_485 2008-04-08 116 val_116 2008-04-08 223 val_223 2008-04-08 256 val_256 2008-04-08 263 val_263 2008-04-08 70 val_70 2008-04-08 487 val_487 2008-04-08 480 val_480 2008-04-08 401 val_401 2008-04-08 288 val_288 2008-04-08 191 val_191 2008-04-08 5 val_5 2008-04-08 244 val_244 2008-04-08 438 val_438 2008-04-08 128 val_128 2008-04-08 467 val_467 2008-04-08 432 val_432 2008-04-08 202 val_202 2008-04-08 316 val_316 2008-04-08 229 val_229 2008-04-08 469 val_469 2008-04-08 463 val_463 2008-04-08 280 val_280 2008-04-08 2 val_2 2008-04-08 35 val_35 2008-04-08 283 val_283 2008-04-08 331 val_331 2008-04-08 235 val_235 2008-04-08 80 val_80 2008-04-08 44 val_44 2008-04-08 193 val_193 2008-04-08 321 val_321 2008-04-08 335 val_335 2008-04-08 104 val_104 2008-04-08 466 val_466 2008-04-08 366 val_366 2008-04-08 175 val_175 2008-04-08 403 val_403 2008-04-08 483 val_483 2008-04-08 53 val_53 2008-04-08 105 val_105 2008-04-08 257 val_257 2008-04-08 406 val_406 2008-04-08 409 val_409 2008-04-08 190 val_190 2008-04-08 406 val_406 2008-04-08 401 val_401 2008-04-08 114 val_114 2008-04-08 258 val_258 2008-04-08 90 val_90 2008-04-08 203 val_203 2008-04-08 262 val_262 2008-04-08 348 val_348 2008-04-08 424 val_424 2008-04-08 12 val_12 2008-04-08 396 val_396 2008-04-08 201 val_201 2008-04-08 217 val_217 2008-04-08 164 val_164 2008-04-08 431 val_431 2008-04-08 454 val_454 2008-04-08 478 val_478 2008-04-08 298 val_298 2008-04-08 125 val_125 2008-04-08 431 val_431 2008-04-08 164 val_164 2008-04-08 424 val_424 2008-04-08 187 val_187 2008-04-08 382 val_382 2008-04-08 5 val_5 2008-04-08 70 val_70 2008-04-08 397 val_397 2008-04-08 480 val_480 2008-04-08 291 val_291 2008-04-08 24 val_24 2008-04-08 351 val_351 2008-04-08 255 val_255 2008-04-08 104 val_104 2008-04-08 70 val_70 2008-04-08 163 val_163 2008-04-08 438 val_438 2008-04-08 119 val_119 2008-04-08 414 val_414 2008-04-08 200 val_200 2008-04-08 491 val_491 2008-04-08 237 val_237 2008-04-08 439 val_439 2008-04-08 360 val_360 2008-04-08 248 val_248 2008-04-08 479 val_479 2008-04-08 305 val_305 2008-04-08 417 val_417 2008-04-08 199 val_199 2008-04-08 444 val_444 2008-04-08 120 val_120 2008-04-08 429 val_429 2008-04-08 169 val_169 2008-04-08 443 val_443 2008-04-08 323 val_323 2008-04-08 325 val_325 2008-04-08 277 val_277 2008-04-08 230 val_230 2008-04-08 478 val_478 2008-04-08 178 val_178 2008-04-08 468 val_468 2008-04-08 310 val_310 2008-04-08 317 val_317 2008-04-08 333 val_333 2008-04-08 493 val_493 2008-04-08 460 val_460 2008-04-08 207 val_207 2008-04-08 249 val_249 2008-04-08 265 val_265 2008-04-08 480 val_480 2008-04-08 83 val_83 2008-04-08 136 val_136 2008-04-08 353 val_353 2008-04-08 172 val_172 2008-04-08 214 val_214 2008-04-08 462 val_462 2008-04-08 233 val_233 2008-04-08 406 val_406 2008-04-08 133 val_133 2008-04-08 175 val_175 2008-04-08 189 val_189 2008-04-08 454 val_454 2008-04-08 375 val_375 2008-04-08 401 val_401 2008-04-08 421 val_421 2008-04-08 407 val_407 2008-04-08 384 val_384 2008-04-08 256 val_256 2008-04-08 26 val_26 2008-04-08 134 val_134 2008-04-08 67 val_67 2008-04-08 384 val_384 2008-04-08 379 val_379 2008-04-08 18 val_18 2008-04-08 462 val_462 2008-04-08 492 val_492 2008-04-08 100 val_100 2008-04-08 298 val_298 2008-04-08 9 val_9 2008-04-08 341 val_341 2008-04-08 498 val_498 2008-04-08 146 val_146 2008-04-08 458 val_458 2008-04-08 362 val_362 2008-04-08 186 val_186 2008-04-08 285 val_285 2008-04-08 348 val_348 2008-04-08 167 val_167 2008-04-08 18 val_18 2008-04-08 273 val_273 2008-04-08 183 val_183 2008-04-08 281 val_281 2008-04-08 344 val_344 2008-04-08 97 val_97 2008-04-08 469 val_469 2008-04-08 315 val_315 2008-04-08 84 val_84 2008-04-08 28 val_28 2008-04-08 37 val_37 2008-04-08 448 val_448 2008-04-08 152 val_152 2008-04-08 348 val_348 2008-04-08 307 val_307 2008-04-08 194 val_194 2008-04-08 414 val_414 2008-04-08 477 val_477 2008-04-08 222 val_222 2008-04-08 126 val_126 2008-04-08 90 val_90 2008-04-08 169 val_169 2008-04-08 403 val_403 2008-04-08 400 val_400 2008-04-08 200 val_200 2008-04-08 97 val_97 2008-04-08 238 val_238 2008-04-09 86 val_86 2008-04-09 311 val_311 2008-04-09 27 val_27 2008-04-09 165 val_165 2008-04-09 409 val_409 2008-04-09 255 val_255 2008-04-09 278 val_278 2008-04-09 98 val_98 2008-04-09 484 val_484 2008-04-09 265 val_265 2008-04-09 193 val_193 2008-04-09 401 val_401 2008-04-09 150 val_150 2008-04-09 273 val_273 2008-04-09 224 val_224 2008-04-09 369 val_369 2008-04-09 66 val_66 2008-04-09 128 val_128 2008-04-09 213 val_213 2008-04-09 146 val_146 2008-04-09 406 val_406 2008-04-09 429 val_429 2008-04-09 374 val_374 2008-04-09 152 val_152 2008-04-09 469 val_469 2008-04-09 145 val_145 2008-04-09 495 val_495 2008-04-09 37 val_37 2008-04-09 327 val_327 2008-04-09 281 val_281 2008-04-09 277 val_277 2008-04-09 209 val_209 2008-04-09 15 val_15 2008-04-09 82 val_82 2008-04-09 403 val_403 2008-04-09 166 val_166 2008-04-09 417 val_417 2008-04-09 430 val_430 2008-04-09 252 val_252 2008-04-09 292 val_292 2008-04-09 219 val_219 2008-04-09 287 val_287 2008-04-09 153 val_153 2008-04-09 193 val_193 2008-04-09 338 val_338 2008-04-09 446 val_446 2008-04-09 459 val_459 2008-04-09 394 val_394 2008-04-09 237 val_237 2008-04-09 482 val_482 2008-04-09 174 val_174 2008-04-09 413 val_413 2008-04-09 494 val_494 2008-04-09 207 val_207 2008-04-09 199 val_199 2008-04-09 466 val_466 2008-04-09 208 val_208 2008-04-09 174 val_174 2008-04-09 399 val_399 2008-04-09 396 val_396 2008-04-09 247 val_247 2008-04-09 417 val_417 2008-04-09 489 val_489 2008-04-09 162 val_162 2008-04-09 377 val_377 2008-04-09 397 val_397 2008-04-09 309 val_309 2008-04-09 365 val_365 2008-04-09 266 val_266 2008-04-09 439 val_439 2008-04-09 342 val_342 2008-04-09 367 val_367 2008-04-09 325 val_325 2008-04-09 167 val_167 2008-04-09 195 val_195 2008-04-09 475 val_475 2008-04-09 17 val_17 2008-04-09 113 val_113 2008-04-09 155 val_155 2008-04-09 203 val_203 2008-04-09 339 val_339 2008-04-09 0 val_0 2008-04-09 455 val_455 2008-04-09 128 val_128 2008-04-09 311 val_311 2008-04-09 316 val_316 2008-04-09 57 val_57 2008-04-09 302 val_302 2008-04-09 205 val_205 2008-04-09 149 val_149 2008-04-09 438 val_438 2008-04-09 345 val_345 2008-04-09 129 val_129 2008-04-09 170 val_170 2008-04-09 20 val_20 2008-04-09 489 val_489 2008-04-09 157 val_157 2008-04-09 378 val_378 2008-04-09 221 val_221 2008-04-09 92 val_92 2008-04-09 111 val_111 2008-04-09 47 val_47 2008-04-09 72 val_72 2008-04-09 4 val_4 2008-04-09 280 val_280 2008-04-09 35 val_35 2008-04-09 427 val_427 2008-04-09 277 val_277 2008-04-09 208 val_208 2008-04-09 356 val_356 2008-04-09 399 val_399 2008-04-09 169 val_169 2008-04-09 382 val_382 2008-04-09 498 val_498 2008-04-09 125 val_125 2008-04-09 386 val_386 2008-04-09 437 val_437 2008-04-09 469 val_469 2008-04-09 192 val_192 2008-04-09 286 val_286 2008-04-09 187 val_187 2008-04-09 176 val_176 2008-04-09 54 val_54 2008-04-09 459 val_459 2008-04-09 51 val_51 2008-04-09 138 val_138 2008-04-09 103 val_103 2008-04-09 239 val_239 2008-04-09 213 val_213 2008-04-09 216 val_216 2008-04-09 430 val_430 2008-04-09 278 val_278 2008-04-09 176 val_176 2008-04-09 289 val_289 2008-04-09 221 val_221 2008-04-09 65 val_65 2008-04-09 318 val_318 2008-04-09 332 val_332 2008-04-09 311 val_311 2008-04-09 275 val_275 2008-04-09 137 val_137 2008-04-09 241 val_241 2008-04-09 83 val_83 2008-04-09 333 val_333 2008-04-09 180 val_180 2008-04-09 284 val_284 2008-04-09 12 val_12 2008-04-09 230 val_230 2008-04-09 181 val_181 2008-04-09 67 val_67 2008-04-09 260 val_260 2008-04-09 404 val_404 2008-04-09 384 val_384 2008-04-09 489 val_489 2008-04-09 353 val_353 2008-04-09 373 val_373 2008-04-09 272 val_272 2008-04-09 138 val_138 2008-04-09 217 val_217 2008-04-09 84 val_84 2008-04-09 348 val_348 2008-04-09 466 val_466 2008-04-09 58 val_58 2008-04-09 8 val_8 2008-04-09 411 val_411 2008-04-09 230 val_230 2008-04-09 208 val_208 2008-04-09 348 val_348 2008-04-09 24 val_24 2008-04-09 463 val_463 2008-04-09 431 val_431 2008-04-09 179 val_179 2008-04-09 172 val_172 2008-04-09 42 val_42 2008-04-09 129 val_129 2008-04-09 158 val_158 2008-04-09 119 val_119 2008-04-09 496 val_496 2008-04-09 0 val_0 2008-04-09 322 val_322 2008-04-09 197 val_197 2008-04-09 468 val_468 2008-04-09 393 val_393 2008-04-09 454 val_454 2008-04-09 100 val_100 2008-04-09 298 val_298 2008-04-09 199 val_199 2008-04-09 191 val_191 2008-04-09 418 val_418 2008-04-09 96 val_96 2008-04-09 26 val_26 2008-04-09 165 val_165 2008-04-09 327 val_327 2008-04-09 230 val_230 2008-04-09 205 val_205 2008-04-09 120 val_120 2008-04-09 131 val_131 2008-04-09 51 val_51 2008-04-09 404 val_404 2008-04-09 43 val_43 2008-04-09 436 val_436 2008-04-09 156 val_156 2008-04-09 469 val_469 2008-04-09 468 val_468 2008-04-09 308 val_308 2008-04-09 95 val_95 2008-04-09 196 val_196 2008-04-09 288 val_288 2008-04-09 481 val_481 2008-04-09 457 val_457 2008-04-09 98 val_98 2008-04-09 282 val_282 2008-04-09 197 val_197 2008-04-09 187 val_187 2008-04-09 318 val_318 2008-04-09 318 val_318 2008-04-09 409 val_409 2008-04-09 470 val_470 2008-04-09 137 val_137 2008-04-09 369 val_369 2008-04-09 316 val_316 2008-04-09 169 val_169 2008-04-09 413 val_413 2008-04-09 85 val_85 2008-04-09 77 val_77 2008-04-09 0 val_0 2008-04-09 490 val_490 2008-04-09 87 val_87 2008-04-09 364 val_364 2008-04-09 179 val_179 2008-04-09 118 val_118 2008-04-09 134 val_134 2008-04-09 395 val_395 2008-04-09 282 val_282 2008-04-09 138 val_138 2008-04-09 238 val_238 2008-04-09 419 val_419 2008-04-09 15 val_15 2008-04-09 118 val_118 2008-04-09 72 val_72 2008-04-09 90 val_90 2008-04-09 307 val_307 2008-04-09 19 val_19 2008-04-09 435 val_435 2008-04-09 10 val_10 2008-04-09 277 val_277 2008-04-09 273 val_273 2008-04-09 306 val_306 2008-04-09 224 val_224 2008-04-09 309 val_309 2008-04-09 389 val_389 2008-04-09 327 val_327 2008-04-09 242 val_242 2008-04-09 369 val_369 2008-04-09 392 val_392 2008-04-09 272 val_272 2008-04-09 331 val_331 2008-04-09 401 val_401 2008-04-09 242 val_242 2008-04-09 452 val_452 2008-04-09 177 val_177 2008-04-09 226 val_226 2008-04-09 5 val_5 2008-04-09 497 val_497 2008-04-09 402 val_402 2008-04-09 396 val_396 2008-04-09 317 val_317 2008-04-09 395 val_395 2008-04-09 58 val_58 2008-04-09 35 val_35 2008-04-09 336 val_336 2008-04-09 95 val_95 2008-04-09 11 val_11 2008-04-09 168 val_168 2008-04-09 34 val_34 2008-04-09 229 val_229 2008-04-09 233 val_233 2008-04-09 143 val_143 2008-04-09 472 val_472 2008-04-09 322 val_322 2008-04-09 498 val_498 2008-04-09 160 val_160 2008-04-09 195 val_195 2008-04-09 42 val_42 2008-04-09 321 val_321 2008-04-09 430 val_430 2008-04-09 119 val_119 2008-04-09 489 val_489 2008-04-09 458 val_458 2008-04-09 78 val_78 2008-04-09 76 val_76 2008-04-09 41 val_41 2008-04-09 223 val_223 2008-04-09 492 val_492 2008-04-09 149 val_149 2008-04-09 449 val_449 2008-04-09 218 val_218 2008-04-09 228 val_228 2008-04-09 138 val_138 2008-04-09 453 val_453 2008-04-09 30 val_30 2008-04-09 209 val_209 2008-04-09 64 val_64 2008-04-09 468 val_468 2008-04-09 76 val_76 2008-04-09 74 val_74 2008-04-09 342 val_342 2008-04-09 69 val_69 2008-04-09 230 val_230 2008-04-09 33 val_33 2008-04-09 368 val_368 2008-04-09 103 val_103 2008-04-09 296 val_296 2008-04-09 113 val_113 2008-04-09 216 val_216 2008-04-09 367 val_367 2008-04-09 344 val_344 2008-04-09 167 val_167 2008-04-09 274 val_274 2008-04-09 219 val_219 2008-04-09 239 val_239 2008-04-09 485 val_485 2008-04-09 116 val_116 2008-04-09 223 val_223 2008-04-09 256 val_256 2008-04-09 263 val_263 2008-04-09 70 val_70 2008-04-09 487 val_487 2008-04-09 480 val_480 2008-04-09 401 val_401 2008-04-09 288 val_288 2008-04-09 191 val_191 2008-04-09 5 val_5 2008-04-09 244 val_244 2008-04-09 438 val_438 2008-04-09 128 val_128 2008-04-09 467 val_467 2008-04-09 432 val_432 2008-04-09 202 val_202 2008-04-09 316 val_316 2008-04-09 229 val_229 2008-04-09 469 val_469 2008-04-09 463 val_463 2008-04-09 280 val_280 2008-04-09 2 val_2 2008-04-09 35 val_35 2008-04-09 283 val_283 2008-04-09 331 val_331 2008-04-09 235 val_235 2008-04-09 80 val_80 2008-04-09 44 val_44 2008-04-09 193 val_193 2008-04-09 321 val_321 2008-04-09 335 val_335 2008-04-09 104 val_104 2008-04-09 466 val_466 2008-04-09 366 val_366 2008-04-09 175 val_175 2008-04-09 403 val_403 2008-04-09 483 val_483 2008-04-09 53 val_53 2008-04-09 105 val_105 2008-04-09 257 val_257 2008-04-09 406 val_406 2008-04-09 409 val_409 2008-04-09 190 val_190 2008-04-09 406 val_406 2008-04-09 401 val_401 2008-04-09 114 val_114 2008-04-09 258 val_258 2008-04-09 90 val_90 2008-04-09 203 val_203 2008-04-09 262 val_262 2008-04-09 348 val_348 2008-04-09 424 val_424 2008-04-09 12 val_12 2008-04-09 396 val_396 2008-04-09 201 val_201 2008-04-09 217 val_217 2008-04-09 164 val_164 2008-04-09 431 val_431 2008-04-09 454 val_454 2008-04-09 478 val_478 2008-04-09 298 val_298 2008-04-09 125 val_125 2008-04-09 431 val_431 2008-04-09 164 val_164 2008-04-09 424 val_424 2008-04-09 187 val_187 2008-04-09 382 val_382 2008-04-09 5 val_5 2008-04-09 70 val_70 2008-04-09 397 val_397 2008-04-09 480 val_480 2008-04-09 291 val_291 2008-04-09 24 val_24 2008-04-09 351 val_351 2008-04-09 255 val_255 2008-04-09 104 val_104 2008-04-09 70 val_70 2008-04-09 163 val_163 2008-04-09 438 val_438 2008-04-09 119 val_119 2008-04-09 414 val_414 2008-04-09 200 val_200 2008-04-09 491 val_491 2008-04-09 237 val_237 2008-04-09 439 val_439 2008-04-09 360 val_360 2008-04-09 248 val_248 2008-04-09 479 val_479 2008-04-09 305 val_305 2008-04-09 417 val_417 2008-04-09 199 val_199 2008-04-09 444 val_444 2008-04-09 120 val_120 2008-04-09 429 val_429 2008-04-09 169 val_169 2008-04-09 443 val_443 2008-04-09 323 val_323 2008-04-09 325 val_325 2008-04-09 277 val_277 2008-04-09 230 val_230 2008-04-09 478 val_478 2008-04-09 178 val_178 2008-04-09 468 val_468 2008-04-09 310 val_310 2008-04-09 317 val_317 2008-04-09 333 val_333 2008-04-09 493 val_493 2008-04-09 460 val_460 2008-04-09 207 val_207 2008-04-09 249 val_249 2008-04-09 265 val_265 2008-04-09 480 val_480 2008-04-09 83 val_83 2008-04-09 136 val_136 2008-04-09 353 val_353 2008-04-09 172 val_172 2008-04-09 214 val_214 2008-04-09 462 val_462 2008-04-09 233 val_233 2008-04-09 406 val_406 2008-04-09 133 val_133 2008-04-09 175 val_175 2008-04-09 189 val_189 2008-04-09 454 val_454 2008-04-09 375 val_375 2008-04-09 401 val_401 2008-04-09 421 val_421 2008-04-09 407 val_407 2008-04-09 384 val_384 2008-04-09 256 val_256 2008-04-09 26 val_26 2008-04-09 134 val_134 2008-04-09 67 val_67 2008-04-09 384 val_384 2008-04-09 379 val_379 2008-04-09 18 val_18 2008-04-09 462 val_462 2008-04-09 492 val_492 2008-04-09 100 val_100 2008-04-09 298 val_298 2008-04-09 9 val_9 2008-04-09 341 val_341 2008-04-09 498 val_498 2008-04-09 146 val_146 2008-04-09 458 val_458 2008-04-09 362 val_362 2008-04-09 186 val_186 2008-04-09 285 val_285 2008-04-09 348 val_348 2008-04-09 167 val_167 2008-04-09 18 val_18 2008-04-09 273 val_273 2008-04-09 183 val_183 2008-04-09 281 val_281 2008-04-09 344 val_344 2008-04-09 97 val_97 2008-04-09 469 val_469 2008-04-09 315 val_315 2008-04-09 84 val_84 2008-04-09 28 val_28 2008-04-09 37 val_37 2008-04-09 448 val_448 2008-04-09 152 val_152 2008-04-09 348 val_348 2008-04-09 307 val_307 2008-04-09 194 val_194 2008-04-09 414 val_414 2008-04-09 477 val_477 2008-04-09 222 val_222 2008-04-09 126 val_126 2008-04-09 90 val_90 2008-04-09 169 val_169 2008-04-09 403 val_403 2008-04-09 400 val_400 2008-04-09 200 val_200 2008-04-09 97 val_97 2008-04-09 238 val_238 2008-04-09 86 val_86 2008-04-09 311 val_311 2008-04-09 27 val_27 2008-04-09 165 val_165 2008-04-09 409 val_409 2008-04-09 255 val_255 2008-04-09 278 val_278 2008-04-09 98 val_98 2008-04-09 484 val_484 2008-04-09 265 val_265 2008-04-09 193 val_193 2008-04-09 401 val_401 2008-04-09 150 val_150 2008-04-09 273 val_273 2008-04-09 224 val_224 2008-04-09 369 val_369 2008-04-09 66 val_66 2008-04-09 128 val_128 2008-04-09 213 val_213 2008-04-09 146 val_146 2008-04-09 406 val_406 2008-04-09 429 val_429 2008-04-09 374 val_374 2008-04-09 152 val_152 2008-04-09 469 val_469 2008-04-09 145 val_145 2008-04-09 495 val_495 2008-04-09 37 val_37 2008-04-09 327 val_327 2008-04-09 281 val_281 2008-04-09 277 val_277 2008-04-09 209 val_209 2008-04-09 15 val_15 2008-04-09 82 val_82 2008-04-09 403 val_403 2008-04-09 166 val_166 2008-04-09 417 val_417 2008-04-09 430 val_430 2008-04-09 252 val_252 2008-04-09 292 val_292 2008-04-09 219 val_219 2008-04-09 287 val_287 2008-04-09 153 val_153 2008-04-09 193 val_193 2008-04-09 338 val_338 2008-04-09 446 val_446 2008-04-09 459 val_459 2008-04-09 394 val_394 2008-04-09 237 val_237 2008-04-09 482 val_482 2008-04-09 174 val_174 2008-04-09 413 val_413 2008-04-09 494 val_494 2008-04-09 207 val_207 2008-04-09 199 val_199 2008-04-09 466 val_466 2008-04-09 208 val_208 2008-04-09 174 val_174 2008-04-09 399 val_399 2008-04-09 396 val_396 2008-04-09 247 val_247 2008-04-09 417 val_417 2008-04-09 489 val_489 2008-04-09 162 val_162 2008-04-09 377 val_377 2008-04-09 397 val_397 2008-04-09 309 val_309 2008-04-09 365 val_365 2008-04-09 266 val_266 2008-04-09 439 val_439 2008-04-09 342 val_342 2008-04-09 367 val_367 2008-04-09 325 val_325 2008-04-09 167 val_167 2008-04-09 195 val_195 2008-04-09 475 val_475 2008-04-09 17 val_17 2008-04-09 113 val_113 2008-04-09 155 val_155 2008-04-09 203 val_203 2008-04-09 339 val_339 2008-04-09 0 val_0 2008-04-09 455 val_455 2008-04-09 128 val_128 2008-04-09 311 val_311 2008-04-09 316 val_316 2008-04-09 57 val_57 2008-04-09 302 val_302 2008-04-09 205 val_205 2008-04-09 149 val_149 2008-04-09 438 val_438 2008-04-09 345 val_345 2008-04-09 129 val_129 2008-04-09 170 val_170 2008-04-09 20 val_20 2008-04-09 489 val_489 2008-04-09 157 val_157 2008-04-09 378 val_378 2008-04-09 221 val_221 2008-04-09 92 val_92 2008-04-09 111 val_111 2008-04-09 47 val_47 2008-04-09 72 val_72 2008-04-09 4 val_4 2008-04-09 280 val_280 2008-04-09 35 val_35 2008-04-09 427 val_427 2008-04-09 277 val_277 2008-04-09 208 val_208 2008-04-09 356 val_356 2008-04-09 399 val_399 2008-04-09 169 val_169 2008-04-09 382 val_382 2008-04-09 498 val_498 2008-04-09 125 val_125 2008-04-09 386 val_386 2008-04-09 437 val_437 2008-04-09 469 val_469 2008-04-09 192 val_192 2008-04-09 286 val_286 2008-04-09 187 val_187 2008-04-09 176 val_176 2008-04-09 54 val_54 2008-04-09 459 val_459 2008-04-09 51 val_51 2008-04-09 138 val_138 2008-04-09 103 val_103 2008-04-09 239 val_239 2008-04-09 213 val_213 2008-04-09 216 val_216 2008-04-09 430 val_430 2008-04-09 278 val_278 2008-04-09 176 val_176 2008-04-09 289 val_289 2008-04-09 221 val_221 2008-04-09 65 val_65 2008-04-09 318 val_318 2008-04-09 332 val_332 2008-04-09 311 val_311 2008-04-09 275 val_275 2008-04-09 137 val_137 2008-04-09 241 val_241 2008-04-09 83 val_83 2008-04-09 333 val_333 2008-04-09 180 val_180 2008-04-09 284 val_284 2008-04-09 12 val_12 2008-04-09 230 val_230 2008-04-09 181 val_181 2008-04-09 67 val_67 2008-04-09 260 val_260 2008-04-09 404 val_404 2008-04-09 384 val_384 2008-04-09 489 val_489 2008-04-09 353 val_353 2008-04-09 373 val_373 2008-04-09 272 val_272 2008-04-09 138 val_138 2008-04-09 217 val_217 2008-04-09 84 val_84 2008-04-09 348 val_348 2008-04-09 466 val_466 2008-04-09 58 val_58 2008-04-09 8 val_8 2008-04-09 411 val_411 2008-04-09 230 val_230 2008-04-09 208 val_208 2008-04-09 348 val_348 2008-04-09 24 val_24 2008-04-09 463 val_463 2008-04-09 431 val_431 2008-04-09 179 val_179 2008-04-09 172 val_172 2008-04-09 42 val_42 2008-04-09 129 val_129 2008-04-09 158 val_158 2008-04-09 119 val_119 2008-04-09 496 val_496 2008-04-09 0 val_0 2008-04-09 322 val_322 2008-04-09 197 val_197 2008-04-09 468 val_468 2008-04-09 393 val_393 2008-04-09 454 val_454 2008-04-09 100 val_100 2008-04-09 298 val_298 2008-04-09 199 val_199 2008-04-09 191 val_191 2008-04-09 418 val_418 2008-04-09 96 val_96 2008-04-09 26 val_26 2008-04-09 165 val_165 2008-04-09 327 val_327 2008-04-09 230 val_230 2008-04-09 205 val_205 2008-04-09 120 val_120 2008-04-09 131 val_131 2008-04-09 51 val_51 2008-04-09 404 val_404 2008-04-09 43 val_43 2008-04-09 436 val_436 2008-04-09 156 val_156 2008-04-09 469 val_469 2008-04-09 468 val_468 2008-04-09 308 val_308 2008-04-09 95 val_95 2008-04-09 196 val_196 2008-04-09 288 val_288 2008-04-09 481 val_481 2008-04-09 457 val_457 2008-04-09 98 val_98 2008-04-09 282 val_282 2008-04-09 197 val_197 2008-04-09 187 val_187 2008-04-09 318 val_318 2008-04-09 318 val_318 2008-04-09 409 val_409 2008-04-09 470 val_470 2008-04-09 137 val_137 2008-04-09 369 val_369 2008-04-09 316 val_316 2008-04-09 169 val_169 2008-04-09 413 val_413 2008-04-09 85 val_85 2008-04-09 77 val_77 2008-04-09 0 val_0 2008-04-09 490 val_490 2008-04-09 87 val_87 2008-04-09 364 val_364 2008-04-09 179 val_179 2008-04-09 118 val_118 2008-04-09 134 val_134 2008-04-09 395 val_395 2008-04-09 282 val_282 2008-04-09 138 val_138 2008-04-09 238 val_238 2008-04-09 419 val_419 2008-04-09 15 val_15 2008-04-09 118 val_118 2008-04-09 72 val_72 2008-04-09 90 val_90 2008-04-09 307 val_307 2008-04-09 19 val_19 2008-04-09 435 val_435 2008-04-09 10 val_10 2008-04-09 277 val_277 2008-04-09 273 val_273 2008-04-09 306 val_306 2008-04-09 224 val_224 2008-04-09 309 val_309 2008-04-09 389 val_389 2008-04-09 327 val_327 2008-04-09 242 val_242 2008-04-09 369 val_369 2008-04-09 392 val_392 2008-04-09 272 val_272 2008-04-09 331 val_331 2008-04-09 401 val_401 2008-04-09 242 val_242 2008-04-09 452 val_452 2008-04-09 177 val_177 2008-04-09 226 val_226 2008-04-09 5 val_5 2008-04-09 497 val_497 2008-04-09 402 val_402 2008-04-09 396 val_396 2008-04-09 317 val_317 2008-04-09 395 val_395 2008-04-09 58 val_58 2008-04-09 35 val_35 2008-04-09 336 val_336 2008-04-09 95 val_95 2008-04-09 11 val_11 2008-04-09 168 val_168 2008-04-09 34 val_34 2008-04-09 229 val_229 2008-04-09 233 val_233 2008-04-09 143 val_143 2008-04-09 472 val_472 2008-04-09 322 val_322 2008-04-09 498 val_498 2008-04-09 160 val_160 2008-04-09 195 val_195 2008-04-09 42 val_42 2008-04-09 321 val_321 2008-04-09 430 val_430 2008-04-09 119 val_119 2008-04-09 489 val_489 2008-04-09 458 val_458 2008-04-09 78 val_78 2008-04-09 76 val_76 2008-04-09 41 val_41 2008-04-09 223 val_223 2008-04-09 492 val_492 2008-04-09 149 val_149 2008-04-09 449 val_449 2008-04-09 218 val_218 2008-04-09 228 val_228 2008-04-09 138 val_138 2008-04-09 453 val_453 2008-04-09 30 val_30 2008-04-09 209 val_209 2008-04-09 64 val_64 2008-04-09 468 val_468 2008-04-09 76 val_76 2008-04-09 74 val_74 2008-04-09 342 val_342 2008-04-09 69 val_69 2008-04-09 230 val_230 2008-04-09 33 val_33 2008-04-09 368 val_368 2008-04-09 103 val_103 2008-04-09 296 val_296 2008-04-09 113 val_113 2008-04-09 216 val_216 2008-04-09 367 val_367 2008-04-09 344 val_344 2008-04-09 167 val_167 2008-04-09 274 val_274 2008-04-09 219 val_219 2008-04-09 239 val_239 2008-04-09 485 val_485 2008-04-09 116 val_116 2008-04-09 223 val_223 2008-04-09 256 val_256 2008-04-09 263 val_263 2008-04-09 70 val_70 2008-04-09 487 val_487 2008-04-09 480 val_480 2008-04-09 401 val_401 2008-04-09 288 val_288 2008-04-09 191 val_191 2008-04-09 5 val_5 2008-04-09 244 val_244 2008-04-09 438 val_438 2008-04-09 128 val_128 2008-04-09 467 val_467 2008-04-09 432 val_432 2008-04-09 202 val_202 2008-04-09 316 val_316 2008-04-09 229 val_229 2008-04-09 469 val_469 2008-04-09 463 val_463 2008-04-09 280 val_280 2008-04-09 2 val_2 2008-04-09 35 val_35 2008-04-09 283 val_283 2008-04-09 331 val_331 2008-04-09 235 val_235 2008-04-09 80 val_80 2008-04-09 44 val_44 2008-04-09 193 val_193 2008-04-09 321 val_321 2008-04-09 335 val_335 2008-04-09 104 val_104 2008-04-09 466 val_466 2008-04-09 366 val_366 2008-04-09 175 val_175 2008-04-09 403 val_403 2008-04-09 483 val_483 2008-04-09 53 val_53 2008-04-09 105 val_105 2008-04-09 257 val_257 2008-04-09 406 val_406 2008-04-09 409 val_409 2008-04-09 190 val_190 2008-04-09 406 val_406 2008-04-09 401 val_401 2008-04-09 114 val_114 2008-04-09 258 val_258 2008-04-09 90 val_90 2008-04-09 203 val_203 2008-04-09 262 val_262 2008-04-09 348 val_348 2008-04-09 424 val_424 2008-04-09 12 val_12 2008-04-09 396 val_396 2008-04-09 201 val_201 2008-04-09 217 val_217 2008-04-09 164 val_164 2008-04-09 431 val_431 2008-04-09 454 val_454 2008-04-09 478 val_478 2008-04-09 298 val_298 2008-04-09 125 val_125 2008-04-09 431 val_431 2008-04-09 164 val_164 2008-04-09 424 val_424 2008-04-09 187 val_187 2008-04-09 382 val_382 2008-04-09 5 val_5 2008-04-09 70 val_70 2008-04-09 397 val_397 2008-04-09 480 val_480 2008-04-09 291 val_291 2008-04-09 24 val_24 2008-04-09 351 val_351 2008-04-09 255 val_255 2008-04-09 104 val_104 2008-04-09 70 val_70 2008-04-09 163 val_163 2008-04-09 438 val_438 2008-04-09 119 val_119 2008-04-09 414 val_414 2008-04-09 200 val_200 2008-04-09 491 val_491 2008-04-09 237 val_237 2008-04-09 439 val_439 2008-04-09 360 val_360 2008-04-09 248 val_248 2008-04-09 479 val_479 2008-04-09 305 val_305 2008-04-09 417 val_417 2008-04-09 199 val_199 2008-04-09 444 val_444 2008-04-09 120 val_120 2008-04-09 429 val_429 2008-04-09 169 val_169 2008-04-09 443 val_443 2008-04-09 323 val_323 2008-04-09 325 val_325 2008-04-09 277 val_277 2008-04-09 230 val_230 2008-04-09 478 val_478 2008-04-09 178 val_178 2008-04-09 468 val_468 2008-04-09 310 val_310 2008-04-09 317 val_317 2008-04-09 333 val_333 2008-04-09 493 val_493 2008-04-09 460 val_460 2008-04-09 207 val_207 2008-04-09 249 val_249 2008-04-09 265 val_265 2008-04-09 480 val_480 2008-04-09 83 val_83 2008-04-09 136 val_136 2008-04-09 353 val_353 2008-04-09 172 val_172 2008-04-09 214 val_214 2008-04-09 462 val_462 2008-04-09 233 val_233 2008-04-09 406 val_406 2008-04-09 133 val_133 2008-04-09 175 val_175 2008-04-09 189 val_189 2008-04-09 454 val_454 2008-04-09 375 val_375 2008-04-09 401 val_401 2008-04-09 421 val_421 2008-04-09 407 val_407 2008-04-09 384 val_384 2008-04-09 256 val_256 2008-04-09 26 val_26 2008-04-09 134 val_134 2008-04-09 67 val_67 2008-04-09 384 val_384 2008-04-09 379 val_379 2008-04-09 18 val_18 2008-04-09 462 val_462 2008-04-09 492 val_492 2008-04-09 100 val_100 2008-04-09 298 val_298 2008-04-09 9 val_9 2008-04-09 341 val_341 2008-04-09 498 val_498 2008-04-09 146 val_146 2008-04-09 458 val_458 2008-04-09 362 val_362 2008-04-09 186 val_186 2008-04-09 285 val_285 2008-04-09 348 val_348 2008-04-09 167 val_167 2008-04-09 18 val_18 2008-04-09 273 val_273 2008-04-09 183 val_183 2008-04-09 281 val_281 2008-04-09 344 val_344 2008-04-09 97 val_97 2008-04-09 469 val_469 2008-04-09 315 val_315 2008-04-09 84 val_84 2008-04-09 28 val_28 2008-04-09 37 val_37 2008-04-09 448 val_448 2008-04-09 152 val_152 2008-04-09 348 val_348 2008-04-09 307 val_307 2008-04-09 194 val_194 2008-04-09 414 val_414 2008-04-09 477 val_477 2008-04-09 222 val_222 2008-04-09 126 val_126 2008-04-09 90 val_90 2008-04-09 169 val_169 2008-04-09 403 val_403 2008-04-09 400 val_400 2008-04-09 200 val_200 2008-04-09 97 val_97 2008-04-09