Saving all output to "!!{outputDirectory}!!/udf_E.q.raw". Enter "record" with no arguments to stop it. >>> !run !!{qFileDirectory}!!/udf_E.q >>> explain select E() FROM src LIMIT 1; 'Explain' 'ABSTRACT SYNTAX TREE:' ' (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME src))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION E))) (TOK_LIMIT 1)))' '' 'STAGE DEPENDENCIES:' ' Stage-1 is a root stage' ' Stage-0 is a root stage' '' 'STAGE PLANS:' ' Stage: Stage-1' ' Map Reduce' ' Alias -> Map Operator Tree:' ' src ' ' TableScan' ' alias: src' ' Select Operator' ' expressions:' ' expr: e()' ' type: double' ' outputColumnNames: _col0' ' Limit' ' File Output Operator' ' compressed: false' ' GlobalTableId: 0' ' table:' ' input format: org.apache.hadoop.mapred.TextInputFormat' ' output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat' '' ' Stage: Stage-0' ' Fetch Operator' ' limit: 1' '' '' 32 rows selected >>> >>> select E() FROM src LIMIT 1; '_c0' '2.718281828459045' 1 row selected >>> >>> DESCRIBE FUNCTION E; 'tab_name' 'E() - returns E ' 1 row selected >>> DESCRIBE FUNCTION EXTENDED E; 'tab_name' 'E() - returns E ' 'Synonyms: e' 'Example:' ' > SELECT E() FROM src LIMIT 1;' ' 2.718281828459045' 5 rows selected >>> explain select E() FROM src LIMIT 1; 'Explain' 'ABSTRACT SYNTAX TREE:' ' (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME src))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION E))) (TOK_LIMIT 1)))' '' 'STAGE DEPENDENCIES:' ' Stage-1 is a root stage' ' Stage-0 is a root stage' '' 'STAGE PLANS:' ' Stage: Stage-1' ' Map Reduce' ' Alias -> Map Operator Tree:' ' src ' ' TableScan' ' alias: src' ' Select Operator' ' expressions:' ' expr: e()' ' type: double' ' outputColumnNames: _col0' ' Limit' ' File Output Operator' ' compressed: false' ' GlobalTableId: 0' ' table:' ' input format: org.apache.hadoop.mapred.TextInputFormat' ' output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat' '' ' Stage: Stage-0' ' Fetch Operator' ' limit: 1' '' '' 32 rows selected >>> >>> select E() FROM src LIMIT 1; '_c0' '2.718281828459045' 1 row selected >>> >>> DESCRIBE FUNCTION E; 'tab_name' 'E() - returns E ' 1 row selected >>> DESCRIBE FUNCTION EXTENDED E; 'tab_name' 'E() - returns E ' 'Synonyms: e' 'Example:' ' > SELECT E() FROM src LIMIT 1;' ' 2.718281828459045' 5 rows selected >>> !record