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