PREHOOK: query: EXPLAIN
CREATE TEMPORARY FUNCTION test_translate AS 'org.apache.hadoop.hive.ql.udf.generic.GenericUDFTestTranslate'
PREHOOK: type: CREATEFUNCTION
POSTHOOK: query: EXPLAIN
CREATE TEMPORARY FUNCTION test_translate AS 'org.apache.hadoop.hive.ql.udf.generic.GenericUDFTestTranslate'
POSTHOOK: type: CREATEFUNCTION
STAGE DEPENDENCIES:
  Stage-0 is a root stage

STAGE PLANS:
  Stage: Stage-0

PREHOOK: query: CREATE TEMPORARY FUNCTION test_translate AS 'org.apache.hadoop.hive.ql.udf.generic.GenericUDFTestTranslate'
PREHOOK: type: CREATEFUNCTION
PREHOOK: Output: test_translate
POSTHOOK: query: CREATE TEMPORARY FUNCTION test_translate AS 'org.apache.hadoop.hive.ql.udf.generic.GenericUDFTestTranslate'
POSTHOOK: type: CREATEFUNCTION
POSTHOOK: Output: test_translate
PREHOOK: query: CREATE TABLE dest1(c1 STRING, c2 STRING, c3 STRING, c4 STRING, c5 STRING, c6 STRING, c7 STRING)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
PREHOOK: Output: default@dest1
POSTHOOK: query: CREATE TABLE dest1(c1 STRING, c2 STRING, c3 STRING, c4 STRING, c5 STRING, c6 STRING, c7 STRING)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@dest1
PREHOOK: query: FROM src 
INSERT OVERWRITE TABLE dest1 
SELECT 
    test_translate('abc', 'a', 'b'),
    test_translate('abc', 'ab', 'bc'),
    test_translate(NULL, 'a', 'b'),
    test_translate('a', NULL, 'b'),
    test_translate('a', 'a', NULL),
    test_translate('abc', 'ab', 'b'),
    test_translate('abc', 'a', 'ab')
PREHOOK: type: QUERY
PREHOOK: Input: default@src
PREHOOK: Output: default@dest1
POSTHOOK: query: FROM src 
INSERT OVERWRITE TABLE dest1 
SELECT 
    test_translate('abc', 'a', 'b'),
    test_translate('abc', 'ab', 'bc'),
    test_translate(NULL, 'a', 'b'),
    test_translate('a', NULL, 'b'),
    test_translate('a', 'a', NULL),
    test_translate('abc', 'ab', 'b'),
    test_translate('abc', 'a', 'ab')
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
POSTHOOK: Output: default@dest1
POSTHOOK: Lineage: dest1.c1 EXPRESSION []
POSTHOOK: Lineage: dest1.c2 EXPRESSION []
POSTHOOK: Lineage: dest1.c3 EXPRESSION []
POSTHOOK: Lineage: dest1.c4 EXPRESSION []
POSTHOOK: Lineage: dest1.c5 EXPRESSION []
POSTHOOK: Lineage: dest1.c6 EXPRESSION []
POSTHOOK: Lineage: dest1.c7 EXPRESSION []
PREHOOK: query: SELECT dest1.* FROM dest1 LIMIT 1
PREHOOK: type: QUERY
PREHOOK: Input: default@dest1
#### A masked pattern was here ####
POSTHOOK: query: SELECT dest1.* FROM dest1 LIMIT 1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@dest1
#### A masked pattern was here ####
bbc	bcc	NULL	NULL	NULL	bc	abc
PREHOOK: query: DROP TEMPORARY FUNCTION test_translate
PREHOOK: type: DROPFUNCTION
PREHOOK: Output: test_translate
POSTHOOK: query: DROP TEMPORARY FUNCTION test_translate
POSTHOOK: type: DROPFUNCTION
POSTHOOK: Output: test_translate