PREHOOK: query: drop table hive_test_src PREHOOK: type: DROPTABLE POSTHOOK: query: drop table hive_test_src POSTHOOK: type: DROPTABLE PREHOOK: query: drop table hive_test_dst PREHOOK: type: DROPTABLE POSTHOOK: query: drop table hive_test_dst POSTHOOK: type: DROPTABLE PREHOOK: query: create table hive_test_src ( col1 string ) stored as textfile PREHOOK: type: CREATETABLE POSTHOOK: query: create table hive_test_src ( col1 string ) stored as textfile POSTHOOK: type: CREATETABLE POSTHOOK: Output: default@hive_test_src PREHOOK: query: load data local inpath '../data/files/test.dat' overwrite into table hive_test_src PREHOOK: type: LOAD POSTHOOK: query: load data local inpath '../data/files/test.dat' overwrite into table hive_test_src POSTHOOK: type: LOAD POSTHOOK: Output: default@hive_test_src PREHOOK: query: create table hive_test_dst ( col1 string ) partitioned by ( pcol1 string , pcol2 string) stored as sequencefile PREHOOK: type: CREATETABLE POSTHOOK: query: create table hive_test_dst ( col1 string ) partitioned by ( pcol1 string , pcol2 string) stored as sequencefile POSTHOOK: type: CREATETABLE POSTHOOK: Output: default@hive_test_dst PREHOOK: query: insert overwrite table hive_test_dst partition ( pcol1='test_part', pCol2='test_Part') select col1 from hive_test_src PREHOOK: type: QUERY PREHOOK: Input: default@hive_test_src PREHOOK: Output: default@hive_test_dst@pcol1=test_part/pcol2=test_Part POSTHOOK: query: insert overwrite table hive_test_dst partition ( pcol1='test_part', pCol2='test_Part') select col1 from hive_test_src POSTHOOK: type: QUERY POSTHOOK: Input: default@hive_test_src POSTHOOK: Output: default@hive_test_dst@pcol1=test_part/pcol2=test_Part POSTHOOK: Lineage: hive_test_dst PARTITION(pcol1=test_part,pcol2=test_Part).col1 SIMPLE [(hive_test_src)hive_test_src.FieldSchema(name:col1, type:string, comment:null), ] PREHOOK: query: select * from hive_test_dst where pcol1='test_part' and pcol2='test_Part' PREHOOK: type: QUERY PREHOOK: Input: default@hive_test_dst@pcol1=test_part/pcol2=test_Part PREHOOK: Output: file:/tmp/thiruvel/hive_2010-10-11_12-44-05_659_2221029887224696014/-mr-10000 POSTHOOK: query: select * from hive_test_dst where pcol1='test_part' and pcol2='test_Part' POSTHOOK: type: QUERY POSTHOOK: Input: default@hive_test_dst@pcol1=test_part/pcol2=test_Part POSTHOOK: Output: file:/tmp/thiruvel/hive_2010-10-11_12-44-05_659_2221029887224696014/-mr-10000 POSTHOOK: Lineage: hive_test_dst PARTITION(pcol1=test_part,pcol2=test_Part).col1 SIMPLE [(hive_test_src)hive_test_src.FieldSchema(name:col1, type:string, comment:null), ] 1 test_part test_Part 2 test_part test_Part 3 test_part test_Part 4 test_part test_Part 5 test_part test_Part 6 test_part test_Part PREHOOK: query: select count(1) from hive_test_dst PREHOOK: type: QUERY PREHOOK: Input: default@hive_test_dst@pcol1=test_part/pcol2=test_Part PREHOOK: Output: file:/tmp/thiruvel/hive_2010-10-11_12-44-05_953_2557790695855173848/-mr-10000 POSTHOOK: query: select count(1) from hive_test_dst POSTHOOK: type: QUERY POSTHOOK: Input: default@hive_test_dst@pcol1=test_part/pcol2=test_Part POSTHOOK: Output: file:/tmp/thiruvel/hive_2010-10-11_12-44-05_953_2557790695855173848/-mr-10000 POSTHOOK: Lineage: hive_test_dst PARTITION(pcol1=test_part,pcol2=test_Part).col1 SIMPLE [(hive_test_src)hive_test_src.FieldSchema(name:col1, type:string, comment:null), ] 6 PREHOOK: query: insert overwrite table hive_test_dst partition ( pCol1='test_part', pcol2='test_Part') select col1 from hive_test_src PREHOOK: type: QUERY PREHOOK: Input: default@hive_test_src PREHOOK: Output: default@hive_test_dst@pcol1=test_part/pcol2=test_Part POSTHOOK: query: insert overwrite table hive_test_dst partition ( pCol1='test_part', pcol2='test_Part') select col1 from hive_test_src POSTHOOK: type: QUERY POSTHOOK: Input: default@hive_test_src POSTHOOK: Output: default@hive_test_dst@pcol1=test_part/pcol2=test_Part POSTHOOK: Lineage: hive_test_dst PARTITION(pcol1=test_part,pcol2=test_Part).col1 SIMPLE [(hive_test_src)hive_test_src.FieldSchema(name:col1, type:string, comment:null), ] POSTHOOK: Lineage: hive_test_dst PARTITION(pcol1=test_part,pcol2=test_Part).col1 SIMPLE [(hive_test_src)hive_test_src.FieldSchema(name:col1, type:string, comment:null), ] PREHOOK: query: select * from hive_test_dst where pcol1='test_part' and pcol2='test_part' PREHOOK: type: QUERY PREHOOK: Output: file:/tmp/thiruvel/hive_2010-10-11_12-44-12_148_1009430033459434884/-mr-10000 POSTHOOK: query: select * from hive_test_dst where pcol1='test_part' and pcol2='test_part' POSTHOOK: type: QUERY POSTHOOK: Output: file:/tmp/thiruvel/hive_2010-10-11_12-44-12_148_1009430033459434884/-mr-10000 POSTHOOK: Lineage: hive_test_dst PARTITION(pcol1=test_part,pcol2=test_Part).col1 SIMPLE [(hive_test_src)hive_test_src.FieldSchema(name:col1, type:string, comment:null), ] POSTHOOK: Lineage: hive_test_dst PARTITION(pcol1=test_part,pcol2=test_Part).col1 SIMPLE [(hive_test_src)hive_test_src.FieldSchema(name:col1, type:string, comment:null), ] PREHOOK: query: select count(1) from hive_test_dst PREHOOK: type: QUERY PREHOOK: Input: default@hive_test_dst@pcol1=test_part/pcol2=test_Part PREHOOK: Output: file:/tmp/thiruvel/hive_2010-10-11_12-44-12_203_7564156689753325528/-mr-10000 POSTHOOK: query: select count(1) from hive_test_dst POSTHOOK: type: QUERY POSTHOOK: Input: default@hive_test_dst@pcol1=test_part/pcol2=test_Part POSTHOOK: Output: file:/tmp/thiruvel/hive_2010-10-11_12-44-12_203_7564156689753325528/-mr-10000 POSTHOOK: Lineage: hive_test_dst PARTITION(pcol1=test_part,pcol2=test_Part).col1 SIMPLE [(hive_test_src)hive_test_src.FieldSchema(name:col1, type:string, comment:null), ] POSTHOOK: Lineage: hive_test_dst PARTITION(pcol1=test_part,pcol2=test_Part).col1 SIMPLE [(hive_test_src)hive_test_src.FieldSchema(name:col1, type:string, comment:null), ] 6 PREHOOK: query: select * from hive_test_dst where pcol1='test_part' PREHOOK: type: QUERY PREHOOK: Input: default@hive_test_dst@pcol1=test_part/pcol2=test_Part PREHOOK: Output: file:/tmp/thiruvel/hive_2010-10-11_12-44-14_501_1219457432996411183/-mr-10000 POSTHOOK: query: select * from hive_test_dst where pcol1='test_part' POSTHOOK: type: QUERY POSTHOOK: Input: default@hive_test_dst@pcol1=test_part/pcol2=test_Part POSTHOOK: Output: file:/tmp/thiruvel/hive_2010-10-11_12-44-14_501_1219457432996411183/-mr-10000 POSTHOOK: Lineage: hive_test_dst PARTITION(pcol1=test_part,pcol2=test_Part).col1 SIMPLE [(hive_test_src)hive_test_src.FieldSchema(name:col1, type:string, comment:null), ] POSTHOOK: Lineage: hive_test_dst PARTITION(pcol1=test_part,pcol2=test_Part).col1 SIMPLE [(hive_test_src)hive_test_src.FieldSchema(name:col1, type:string, comment:null), ] 1 test_part test_Part 2 test_part test_Part 3 test_part test_Part 4 test_part test_Part 5 test_part test_Part 6 test_part test_Part PREHOOK: query: select * from hive_test_dst where pcol1='test_part' and pcol2='test_part' PREHOOK: type: QUERY PREHOOK: Output: file:/tmp/thiruvel/hive_2010-10-11_12-44-14_632_4106385047710132007/-mr-10000 POSTHOOK: query: select * from hive_test_dst where pcol1='test_part' and pcol2='test_part' POSTHOOK: type: QUERY POSTHOOK: Output: file:/tmp/thiruvel/hive_2010-10-11_12-44-14_632_4106385047710132007/-mr-10000 POSTHOOK: Lineage: hive_test_dst PARTITION(pcol1=test_part,pcol2=test_Part).col1 SIMPLE [(hive_test_src)hive_test_src.FieldSchema(name:col1, type:string, comment:null), ] POSTHOOK: Lineage: hive_test_dst PARTITION(pcol1=test_part,pcol2=test_Part).col1 SIMPLE [(hive_test_src)hive_test_src.FieldSchema(name:col1, type:string, comment:null), ] PREHOOK: query: select * from hive_test_dst where pcol1='test_Part' PREHOOK: type: QUERY PREHOOK: Output: file:/tmp/thiruvel/hive_2010-10-11_12-44-14_678_6099443731469838470/-mr-10000 POSTHOOK: query: select * from hive_test_dst where pcol1='test_Part' POSTHOOK: type: QUERY POSTHOOK: Output: file:/tmp/thiruvel/hive_2010-10-11_12-44-14_678_6099443731469838470/-mr-10000 POSTHOOK: Lineage: hive_test_dst PARTITION(pcol1=test_part,pcol2=test_Part).col1 SIMPLE [(hive_test_src)hive_test_src.FieldSchema(name:col1, type:string, comment:null), ] POSTHOOK: Lineage: hive_test_dst PARTITION(pcol1=test_part,pcol2=test_Part).col1 SIMPLE [(hive_test_src)hive_test_src.FieldSchema(name:col1, type:string, comment:null), ] PREHOOK: query: describe extended hive_test_dst PREHOOK: type: DESCTABLE POSTHOOK: query: describe extended hive_test_dst POSTHOOK: type: DESCTABLE POSTHOOK: Lineage: hive_test_dst PARTITION(pcol1=test_part,pcol2=test_Part).col1 SIMPLE [(hive_test_src)hive_test_src.FieldSchema(name:col1, type:string, comment:null), ] POSTHOOK: Lineage: hive_test_dst PARTITION(pcol1=test_part,pcol2=test_Part).col1 SIMPLE [(hive_test_src)hive_test_src.FieldSchema(name:col1, type:string, comment:null), ] col1 string pcol1 string pcol2 string Detailed Table Information Table(tableName:hive_test_dst, dbName:default, owner:thiruvel, createTime:1286826241, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:col1, type:string, comment:null), FieldSchema(name:pcol1, type:string, comment:null), FieldSchema(name:pcol2, type:string, comment:null)], location:pfile:/home/thiruvel/projects/hive/hive.unsecure/build/ql/test/data/warehouse/hive_test_dst, inputFormat:org.apache.hadoop.mapred.SequenceFileInputFormat, outputFormat:org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat, 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:pcol1, type:string, comment:null), FieldSchema(name:pcol2, type:string, comment:null)], parameters:{numPartitions=1, numFiles=1, transient_lastDdlTime=1286826252, numRows=6, totalSize=171}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE) PREHOOK: query: drop table hive_test_src PREHOOK: type: DROPTABLE PREHOOK: Input: default@hive_test_src PREHOOK: Output: default@hive_test_src POSTHOOK: query: drop table hive_test_src POSTHOOK: type: DROPTABLE POSTHOOK: Input: default@hive_test_src POSTHOOK: Output: default@hive_test_src POSTHOOK: Lineage: hive_test_dst PARTITION(pcol1=test_part,pcol2=test_Part).col1 SIMPLE [(hive_test_src)hive_test_src.FieldSchema(name:col1, type:string, comment:null), ] POSTHOOK: Lineage: hive_test_dst PARTITION(pcol1=test_part,pcol2=test_Part).col1 SIMPLE [(hive_test_src)hive_test_src.FieldSchema(name:col1, type:string, comment:null), ] PREHOOK: query: drop table hive_test_dst PREHOOK: type: DROPTABLE PREHOOK: Input: default@hive_test_dst PREHOOK: Output: default@hive_test_dst POSTHOOK: query: drop table hive_test_dst POSTHOOK: type: DROPTABLE POSTHOOK: Input: default@hive_test_dst POSTHOOK: Output: default@hive_test_dst POSTHOOK: Lineage: hive_test_dst PARTITION(pcol1=test_part,pcol2=test_Part).col1 SIMPLE [(hive_test_src)hive_test_src.FieldSchema(name:col1, type:string, comment:null), ] POSTHOOK: Lineage: hive_test_dst PARTITION(pcol1=test_part,pcol2=test_Part).col1 SIMPLE [(hive_test_src)hive_test_src.FieldSchema(name:col1, type:string, comment:null), ]