PREHOOK: query: drop table ba_test PREHOOK: type: DROPTABLE POSTHOOK: query: drop table ba_test POSTHOOK: type: DROPTABLE PREHOOK: query: -- All the test in ba_test1.q + using LazyBinarySerde instead of LazySimpleSerde create table ba_test (ba_key binary, ba_val binary) PREHOOK: type: CREATETABLE POSTHOOK: query: -- All the test in ba_test1.q + using LazyBinarySerde instead of LazySimpleSerde create table ba_test (ba_key binary, ba_val binary) POSTHOOK: type: CREATETABLE POSTHOOK: Output: default@ba_test PREHOOK: query: alter table ba_test set serde 'org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe' PREHOOK: type: ALTERTABLE_SERIALIZER PREHOOK: Input: default@ba_test PREHOOK: Output: default@ba_test POSTHOOK: query: alter table ba_test set serde 'org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe' POSTHOOK: type: ALTERTABLE_SERIALIZER POSTHOOK: Input: default@ba_test 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 from deserializer ba_val binary from deserializer Detailed Table Information Table(tableName:ba_test, dbName:default, owner:ashutosh, createTime:1317402516, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:ba_key, type:binary, comment:from deserializer), FieldSchema(name:ba_val, type:binary, comment:from deserializer)], location:pfile:/home/ashutosh/workspace/hive-2380/build/ql/test/data/warehouse/ba_test, 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.lazybinary.LazyBinarySerDe, parameters:{serialization.format=1}), bucketCols:[], sortCols:[], parameters:{}), partitionKeys:[], parameters:{last_modified_by=ashutosh, last_modified_time=1317402516, transient_lastDdlTime=1317402516}, 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_val limit 10 PREHOOK: type: QUERY PREHOOK: Input: default@ba_test PREHOOK: Output: file:/tmp/ashutosh/hive_2011-09-30_10-08-42_365_6581528803651505411/-mr-10000 POSTHOOK: query: select ba_key, ba_val from ba_test order by ba_val limit 10 POSTHOOK: type: QUERY POSTHOOK: Input: default@ba_test POSTHOOK: Output: file:/tmp/ashutosh/hive_2011-09-30_10-08-42_365_6581528803651505411/-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), ]