Saving all output to "!!{outputDirectory}!!/udaf_number_format.q.raw". Enter "record" with no arguments to stop it. >>> !run !!{qFileDirectory}!!/udaf_number_format.q >>> >>> EXPLAIN SELECT sum('a'), avg('a'), variance('a'), std('a') FROM src; '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 sum 'a')) (TOK_SELEXPR (TOK_FUNCTION avg 'a')) (TOK_SELEXPR (TOK_FUNCTION variance 'a')) (TOK_SELEXPR (TOK_FUNCTION std 'a')))))' '' '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' ' Group By Operator' ' aggregations:' ' expr: sum('a')' ' expr: avg('a')' ' expr: variance('a')' ' expr: std('a')' ' bucketGroup: false' ' mode: hash' ' outputColumnNames: _col0, _col1, _col2, _col3' ' Reduce Output Operator' ' sort order: ' ' tag: -1' ' value expressions:' ' expr: _col0' ' type: double' ' expr: _col1' ' type: struct' ' expr: _col2' ' type: struct' ' expr: _col3' ' type: struct' ' Reduce Operator Tree:' ' Group By Operator' ' aggregations:' ' expr: sum(VALUE._col0)' ' expr: avg(VALUE._col1)' ' expr: variance(VALUE._col2)' ' expr: std(VALUE._col3)' ' bucketGroup: false' ' mode: mergepartial' ' outputColumnNames: _col0, _col1, _col2, _col3' ' Select Operator' ' expressions:' ' expr: _col0' ' type: double' ' expr: _col1' ' type: double' ' expr: _col2' ' type: double' ' expr: _col3' ' type: double' ' outputColumnNames: _col0, _col1, _col2, _col3' ' 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' '' '' 69 rows selected >>> >>> SELECT sum('a'), avg('a'), variance('a'), std('a') FROM src; '_c0','_c1','_c2','_c3' '0.0','','','' 1 row selected >>> !record