| PREHOOK: query: create function lookup as 'org.apache.hadoop.hive.ql.udf.UDFFileLookup' using file 'hdfs://### HDFS PATH ###' |
| PREHOOK: type: CREATEFUNCTION |
| PREHOOK: Output: database:default |
| PREHOOK: Output: default.lookup |
| PREHOOK: Output: hdfs://### HDFS PATH ### |
| POSTHOOK: query: create function lookup as 'org.apache.hadoop.hive.ql.udf.UDFFileLookup' using file 'hdfs://### HDFS PATH ###' |
| POSTHOOK: type: CREATEFUNCTION |
| POSTHOOK: Output: database:default |
| POSTHOOK: Output: default.lookup |
| POSTHOOK: Output: hdfs://### HDFS PATH ### |
| PREHOOK: query: create table udf_using (c1 string) |
| PREHOOK: type: CREATETABLE |
| PREHOOK: Output: database:default |
| PREHOOK: Output: default@udf_using |
| POSTHOOK: query: create table udf_using (c1 string) |
| POSTHOOK: type: CREATETABLE |
| POSTHOOK: Output: database:default |
| POSTHOOK: Output: default@udf_using |
| PREHOOK: query: insert overwrite table udf_using select 'Joe' from src limit 2 |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@src |
| PREHOOK: Output: default@udf_using |
| POSTHOOK: query: insert overwrite table udf_using select 'Joe' from src limit 2 |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@src |
| POSTHOOK: Output: default@udf_using |
| POSTHOOK: Lineage: udf_using.c1 SIMPLE [] |
| PREHOOK: query: select c1, lookup(c1) from udf_using |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@udf_using |
| PREHOOK: Output: hdfs://### HDFS PATH ### |
| POSTHOOK: query: select c1, lookup(c1) from udf_using |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@udf_using |
| POSTHOOK: Output: hdfs://### HDFS PATH ### |
| Joe 2 |
| Joe 2 |
| PREHOOK: query: drop table udf_using |
| PREHOOK: type: DROPTABLE |
| PREHOOK: Input: default@udf_using |
| PREHOOK: Output: default@udf_using |
| POSTHOOK: query: drop table udf_using |
| POSTHOOK: type: DROPTABLE |
| POSTHOOK: Input: default@udf_using |
| POSTHOOK: Output: default@udf_using |
| PREHOOK: query: drop function lookup |
| PREHOOK: type: DROPFUNCTION |
| PREHOOK: Output: database:default |
| PREHOOK: Output: default.lookup |
| POSTHOOK: query: drop function lookup |
| POSTHOOK: type: DROPFUNCTION |
| POSTHOOK: Output: database:default |
| POSTHOOK: Output: default.lookup |
| #### A masked pattern was here #### |