PREHOOK: query: DESCRIBE FUNCTION abs PREHOOK: type: DESCFUNCTION POSTHOOK: query: DESCRIBE FUNCTION abs POSTHOOK: type: DESCFUNCTION abs(x) - returns the absolute value of x PREHOOK: query: DESCRIBE FUNCTION EXTENDED abs PREHOOK: type: DESCFUNCTION POSTHOOK: query: DESCRIBE FUNCTION EXTENDED abs POSTHOOK: type: DESCFUNCTION abs(x) - returns the absolute value of x Example: > SELECT abs(0) FROM src LIMIT 1; 0 > SELECT abs(-5) FROM src LIMIT 1; 5 PREHOOK: query: EXPLAIN SELECT abs(0), abs(-1), abs(123), abs(-9223372036854775807), abs(9223372036854775807) FROM src LIMIT 1 PREHOOK: type: QUERY POSTHOOK: query: EXPLAIN SELECT abs(0), abs(-1), abs(123), abs(-9223372036854775807), abs(9223372036854775807) FROM src LIMIT 1 POSTHOOK: type: QUERY 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 abs 0)) (TOK_SELEXPR (TOK_FUNCTION abs (- 1))) (TOK_SELEXPR (TOK_FUNCTION abs 123)) (TOK_SELEXPR (TOK_FUNCTION abs (- 9223372036854775807))) (TOK_SELEXPR (TOK_FUNCTION abs 9223372036854775807))) (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: abs(0) type: int expr: abs((- 1)) type: int expr: abs(123) type: int expr: abs((- 9223372036854775807)) type: bigint expr: abs(9223372036854775807) type: bigint outputColumnNames: _col0, _col1, _col2, _col3, _col4 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 PREHOOK: query: SELECT abs(0), abs(-1), abs(123), abs(-9223372036854775807), abs(9223372036854775807) FROM src LIMIT 1 PREHOOK: type: QUERY PREHOOK: Input: default@src PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-29-52_151_715923862412024109/-mr-10000 POSTHOOK: query: SELECT abs(0), abs(-1), abs(123), abs(-9223372036854775807), abs(9223372036854775807) FROM src LIMIT 1 POSTHOOK: type: QUERY POSTHOOK: Input: default@src POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-29-52_151_715923862412024109/-mr-10000 0 1 123 9223372036854775807 9223372036854775807 PREHOOK: query: EXPLAIN SELECT abs(0.0), abs(-3.14159265), abs(3.14159265) FROM src LIMIT 1 PREHOOK: type: QUERY POSTHOOK: query: EXPLAIN SELECT abs(0.0), abs(-3.14159265), abs(3.14159265) FROM src LIMIT 1 POSTHOOK: type: QUERY 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 abs 0.0)) (TOK_SELEXPR (TOK_FUNCTION abs (- 3.14159265))) (TOK_SELEXPR (TOK_FUNCTION abs 3.14159265))) (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: abs(0.0) type: double expr: abs((- 3.14159265)) type: double expr: abs(3.14159265) type: double outputColumnNames: _col0, _col1, _col2 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 PREHOOK: query: SELECT abs(0.0), abs(-3.14159265), abs(3.14159265) FROM src LIMIT 1 PREHOOK: type: QUERY PREHOOK: Input: default@src PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-29-55_573_7334704443549400495/-mr-10000 POSTHOOK: query: SELECT abs(0.0), abs(-3.14159265), abs(3.14159265) FROM src LIMIT 1 POSTHOOK: type: QUERY POSTHOOK: Input: default@src POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-29-55_573_7334704443549400495/-mr-10000 0.0 3.14159265 3.14159265