Saving all output to "!!{outputDirectory}!!/create_genericudf.q.raw". Enter "record" with no arguments to stop it.
>>>  !run !!{qFileDirectory}!!/create_genericudf.q
>>>  EXPLAIN 
CREATE TEMPORARY FUNCTION test_translate AS 'org.apache.hadoop.hive.ql.udf.generic.GenericUDFTestTranslate';
'Explain'
'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'
''
''
10 rows selected 
>>>  
>>>  CREATE TEMPORARY FUNCTION test_translate AS 'org.apache.hadoop.hive.ql.udf.generic.GenericUDFTestTranslate';
No rows affected 
>>>  
>>>  CREATE TABLE dest1(c1 STRING, c2 STRING, c3 STRING, c4 STRING, c5 STRING, c6 STRING, c7 STRING);
No rows affected 
>>>  
>>>  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');
'_c0','_c1','_c2','_c3','_c4','_c5','_c6'
No rows selected 
>>>  
>>>  SELECT dest1.* FROM dest1 LIMIT 1;
'c1','c2','c3','c4','c5','c6','c7'
'bbc','bcc','','','','bc','abc'
1 row selected 
>>>  
>>>  DROP TEMPORARY FUNCTION test_translate;
No rows affected 
>>>  !record