Saving all output to "!!{outputDirectory}!!/udf_degrees.q.raw". Enter "record" with no arguments to stop it. >>> !run !!{qFileDirectory}!!/udf_degrees.q >>> explain select degrees(PI()) 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 degrees (TOK_FUNCTION PI)))) (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: degrees(pi())' ' 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 degrees(PI()) FROM src LIMIT 1; '_c0' '180.0' 1 row selected >>> >>> DESCRIBE FUNCTION degrees; 'tab_name' 'degrees(x) - Converts radians to degrees' 1 row selected >>> DESCRIBE FUNCTION EXTENDED degrees; 'tab_name' 'degrees(x) - Converts radians to degrees' 'Example:' ' > SELECT degrees(30) FROM src LIMIT 1;' ' -1' '' 5 rows selected >>> explain select degrees(PI()) 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 degrees (TOK_FUNCTION PI)))) (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: degrees(pi())' ' 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 degrees(PI()) FROM src LIMIT 1; '_c0' '180.0' 1 row selected >>> >>> DESCRIBE FUNCTION degrees; 'tab_name' 'degrees(x) - Converts radians to degrees' 1 row selected >>> DESCRIBE FUNCTION EXTENDED degrees; 'tab_name' 'degrees(x) - Converts radians to degrees' 'Example:' ' > SELECT degrees(30) FROM src LIMIT 1;' ' -1' '' 5 rows selected >>> !record