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