PREHOOK: query: CREATE TABLE mytable(key binary, value int) ROW FORMAT DELIMITED FIELDS TERMINATED BY '9' STORED AS TEXTFILE PREHOOK: type: CREATETABLE POSTHOOK: query: CREATE TABLE mytable(key binary, value int) ROW FORMAT DELIMITED FIELDS TERMINATED BY '9' STORED AS TEXTFILE POSTHOOK: type: CREATETABLE POSTHOOK: Output: default@mytable PREHOOK: query: -- this query loads native binary data, stores in a table and then queries it. Note that string.txt contains binary data. Also uses transform clause and then length udf. LOAD DATA LOCAL INPATH '../data/files/string.txt' INTO TABLE mytable PREHOOK: type: LOAD PREHOOK: Output: default@mytable POSTHOOK: query: -- this query loads native binary data, stores in a table and then queries it. Note that string.txt contains binary data. Also uses transform clause and then length udf. LOAD DATA LOCAL INPATH '../data/files/string.txt' INTO TABLE mytable POSTHOOK: type: LOAD POSTHOOK: Output: default@mytable PREHOOK: query: create table dest1 (key binary, value int) PREHOOK: type: CREATETABLE POSTHOOK: query: create table dest1 (key binary, value int) POSTHOOK: type: CREATETABLE POSTHOOK: Output: default@dest1 PREHOOK: query: insert overwrite table dest1 select transform(*) using 'cat' as key binary, value int from mytable PREHOOK: type: QUERY PREHOOK: Input: default@mytable PREHOOK: Output: default@dest1 POSTHOOK: query: insert overwrite table dest1 select transform(*) using 'cat' as key binary, value int from mytable POSTHOOK: type: QUERY POSTHOOK: Input: default@mytable POSTHOOK: Output: default@dest1 POSTHOOK: Lineage: dest1.key SCRIPT [(mytable)mytable.FieldSchema(name:key, type:binary, comment:null), (mytable)mytable.FieldSchema(name:value, type:int, comment:null), ] POSTHOOK: Lineage: dest1.value SCRIPT [(mytable)mytable.FieldSchema(name:key, type:binary, comment:null), (mytable)mytable.FieldSchema(name:value, type:int, comment:null), ] PREHOOK: query: select key, value, length (key) from dest1 PREHOOK: type: QUERY PREHOOK: Input: default@dest1 #### A masked pattern was here #### POSTHOOK: query: select key, value, length (key) from dest1 POSTHOOK: type: QUERY POSTHOOK: Input: default@dest1 #### A masked pattern was here #### POSTHOOK: Lineage: dest1.key SCRIPT [(mytable)mytable.FieldSchema(name:key, type:binary, comment:null), (mytable)mytable.FieldSchema(name:value, type:int, comment:null), ] POSTHOOK: Lineage: dest1.value SCRIPT [(mytable)mytable.FieldSchema(name:key, type:binary, comment:null), (mytable)mytable.FieldSchema(name:value, type:int, comment:null), ] abc 1 8 test 2 6 test 3 6 testtest 4 9 testtest 5 9 testtest 6 12 7 3  8 3  9 3  10 3