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
ABSTRACT SYNTAX TREE:
  (TOK_CREATEFUNCTION test_translate 'org.apache.hadoop.hive.ql.udf.generic.GenericUDFTestTranslate')

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
POSTHOOK: query: CREATE TEMPORARY FUNCTION test_translate AS 'org.apache.hadoop.hive.ql.udf.generic.GenericUDFTestTranslate'
POSTHOOK: type: CREATEFUNCTION
PREHOOK: query: CREATE TABLE dest1(c1 STRING, c2 STRING, c3 STRING, c4 STRING, c5 STRING, c6 STRING, c7 STRING)
PREHOOK: type: CREATETABLE
POSTHOOK: query: CREATE TABLE dest1(c1 STRING, c2 STRING, c3 STRING, c4 STRING, c5 STRING, c6 STRING, c7 STRING)
POSTHOOK: type: CREATETABLE
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
PREHOOK: Output: file:/data/users/athusoo/apache_workspaces/hive_trunk_ws1/.ptest_1/build/ql/scratchdir/hive_2010-04-05_18-07-45_069_5108835452683223960/10000
POSTHOOK: query: SELECT dest1.* FROM dest1 LIMIT 1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@dest1
POSTHOOK: Output: file:/data/users/athusoo/apache_workspaces/hive_trunk_ws1/.ptest_1/build/ql/scratchdir/hive_2010-04-05_18-07-45_069_5108835452683223960/10000
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 []
bbc	bcc	NULL	NULL	NULL	bc	abc
PREHOOK: query: DROP TEMPORARY FUNCTION test_translate
PREHOOK: type: DROPFUNCTION
POSTHOOK: query: DROP TEMPORARY FUNCTION test_translate
POSTHOOK: type: DROPFUNCTION
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 []