PREHOOK: query: drop table ba_test
PREHOOK: type: DROPTABLE
POSTHOOK: query: drop table ba_test
POSTHOOK: type: DROPTABLE
PREHOOK: query: -- This query tests a) binary type works correctly in grammar b) string can be cast into binary c) binary can be stored in a table d) binary data can be loaded back again and queried d) order-by on a binary key 

create table ba_test (ba_key binary, ba_val binary)
PREHOOK: type: CREATETABLE
POSTHOOK: query: -- This query tests a) binary type works correctly in grammar b) string can be cast into binary c) binary can be stored in a table d) binary data can be loaded back again and queried d) order-by on a binary key 

create table ba_test (ba_key binary, ba_val binary)
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:1317402000, 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.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:[], parameters:{transient_lastDdlTime=1317402000}, 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-00-06_375_2774786055437967041/-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-00-06_375_2774786055437967041/-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), ]