PREHOOK: query: drop table ba_test PREHOOK: type: DROPTABLE POSTHOOK: query: drop table ba_test POSTHOOK: type: DROPTABLE PREHOOK: query: -- Everything in ba_table1.q + columnar serde in RCFILE. create table ba_test (ba_key binary, ba_val binary) stored as rcfile PREHOOK: type: CREATETABLE POSTHOOK: query: -- Everything in ba_table1.q + columnar serde in RCFILE. create table ba_test (ba_key binary, ba_val binary) stored as rcfile POSTHOOK: type: CREATETABLE POSTHOOK: Output: default@ba_test PREHOOK: query: describe extended ba_test PREHOOK: type: DESCTABLE POSTHOOK: query: describe extended ba_test POSTHOOK: type: DESCTABLE ba_key binary ba_val binary Detailed Table Information Table(tableName:ba_test, dbName:default, owner:ashutosh, createTime:1317402958, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:ba_key, type:binary, comment:null), FieldSchema(name:ba_val, type:binary, comment:null)], location:pfile:/home/ashutosh/workspace/hive-2380/build/ql/test/data/warehouse/ba_test, inputFormat:org.apache.hadoop.hive.ql.io.RCFileInputFormat, outputFormat:org.apache.hadoop.hive.ql.io.RCFileOutputFormat, compressed:false, numBuckets:-1, serdeInfo:SerDeInfo(name:null, serializationLib:org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe, parameters:{serialization.format=1}), bucketCols:[], sortCols:[], parameters:{}), partitionKeys:[], parameters:{transient_lastDdlTime=1317402958}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE) PREHOOK: query: from src insert overwrite table ba_test select cast (src.key as binary), cast (src.value as binary) PREHOOK: type: QUERY PREHOOK: Input: default@src PREHOOK: Output: default@ba_test POSTHOOK: query: from src insert overwrite table ba_test select cast (src.key as binary), cast (src.value as binary) POSTHOOK: type: QUERY POSTHOOK: Input: default@src POSTHOOK: Output: default@ba_test POSTHOOK: Lineage: ba_test.ba_key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ] POSTHOOK: Lineage: ba_test.ba_val EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ] PREHOOK: query: select ba_key, ba_val from ba_test order by ba_key limit 10 PREHOOK: type: QUERY PREHOOK: Input: default@ba_test PREHOOK: Output: file:/tmp/ashutosh/hive_2011-09-30_10-16-04_286_2345242167033968925/-mr-10000 POSTHOOK: query: select ba_key, ba_val from ba_test order by ba_key limit 10 POSTHOOK: type: QUERY POSTHOOK: Input: default@ba_test POSTHOOK: Output: file:/tmp/ashutosh/hive_2011-09-30_10-16-04_286_2345242167033968925/-mr-10000 POSTHOOK: Lineage: ba_test.ba_key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ] POSTHOOK: Lineage: ba_test.ba_val EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ] 0 val_0 0 val_0 0 val_0 10 val_10 100 val_100 100 val_100 103 val_103 103 val_103 104 val_104 104 val_104 PREHOOK: query: drop table ba_test PREHOOK: type: DROPTABLE PREHOOK: Input: default@ba_test PREHOOK: Output: default@ba_test POSTHOOK: query: drop table ba_test POSTHOOK: type: DROPTABLE POSTHOOK: Input: default@ba_test POSTHOOK: Output: default@ba_test POSTHOOK: Lineage: ba_test.ba_key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ] POSTHOOK: Lineage: ba_test.ba_val EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]