PREHOOK: query: explain select sign(0) FROM src tablesample (1 rows) PREHOOK: type: QUERY POSTHOOK: query: explain select sign(0) FROM src tablesample (1 rows) POSTHOOK: type: QUERY STAGE DEPENDENCIES: Stage-0 is a root stage STAGE PLANS: Stage: Stage-0 Fetch Operator limit: -1 Processor Tree: TableScan alias: src Row Limit Per Split: 1 Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: COMPLETE Select Operator expressions: 0.0 (type: double) outputColumnNames: _col0 Statistics: Num rows: 500 Data size: 4000 Basic stats: COMPLETE Column stats: COMPLETE ListSink PREHOOK: query: select sign(0) FROM src tablesample (1 rows) PREHOOK: type: QUERY PREHOOK: Input: default@src #### A masked pattern was here #### POSTHOOK: query: select sign(0) FROM src tablesample (1 rows) POSTHOOK: type: QUERY POSTHOOK: Input: default@src #### A masked pattern was here #### 0.0 PREHOOK: query: select sign(-45) FROM src tablesample (1 rows) PREHOOK: type: QUERY PREHOOK: Input: default@src #### A masked pattern was here #### POSTHOOK: query: select sign(-45) FROM src tablesample (1 rows) POSTHOOK: type: QUERY POSTHOOK: Input: default@src #### A masked pattern was here #### -1.0 PREHOOK: query: select sign(46) FROM src tablesample (1 rows) PREHOOK: type: QUERY PREHOOK: Input: default@src #### A masked pattern was here #### POSTHOOK: query: select sign(46) FROM src tablesample (1 rows) POSTHOOK: type: QUERY POSTHOOK: Input: default@src #### A masked pattern was here #### 1.0 PREHOOK: query: DESCRIBE FUNCTION sign PREHOOK: type: DESCFUNCTION POSTHOOK: query: DESCRIBE FUNCTION sign POSTHOOK: type: DESCFUNCTION sign(x) - returns the sign of x ) PREHOOK: query: DESCRIBE FUNCTION EXTENDED sign PREHOOK: type: DESCFUNCTION POSTHOOK: query: DESCRIBE FUNCTION EXTENDED sign POSTHOOK: type: DESCFUNCTION sign(x) - returns the sign of x ) Example: > SELECT sign(40) FROM src LIMIT 1; 1 PREHOOK: query: explain select sign(0) FROM src tablesample (1 rows) PREHOOK: type: QUERY POSTHOOK: query: explain select sign(0) FROM src tablesample (1 rows) POSTHOOK: type: QUERY STAGE DEPENDENCIES: Stage-0 is a root stage STAGE PLANS: Stage: Stage-0 Fetch Operator limit: -1 Processor Tree: TableScan alias: src Row Limit Per Split: 1 Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: COMPLETE Select Operator expressions: 0.0 (type: double) outputColumnNames: _col0 Statistics: Num rows: 500 Data size: 4000 Basic stats: COMPLETE Column stats: COMPLETE ListSink PREHOOK: query: select sign(0) FROM src tablesample (1 rows) PREHOOK: type: QUERY PREHOOK: Input: default@src #### A masked pattern was here #### POSTHOOK: query: select sign(0) FROM src tablesample (1 rows) POSTHOOK: type: QUERY POSTHOOK: Input: default@src #### A masked pattern was here #### 0.0 PREHOOK: query: select sign(-45) FROM src tablesample (1 rows) PREHOOK: type: QUERY PREHOOK: Input: default@src #### A masked pattern was here #### POSTHOOK: query: select sign(-45) FROM src tablesample (1 rows) POSTHOOK: type: QUERY POSTHOOK: Input: default@src #### A masked pattern was here #### -1.0 PREHOOK: query: select sign(46) FROM src tablesample (1 rows) PREHOOK: type: QUERY PREHOOK: Input: default@src #### A masked pattern was here #### POSTHOOK: query: select sign(46) FROM src tablesample (1 rows) POSTHOOK: type: QUERY POSTHOOK: Input: default@src #### A masked pattern was here #### 1.0 PREHOOK: query: DESCRIBE FUNCTION sign PREHOOK: type: DESCFUNCTION POSTHOOK: query: DESCRIBE FUNCTION sign POSTHOOK: type: DESCFUNCTION sign(x) - returns the sign of x ) PREHOOK: query: DESCRIBE FUNCTION EXTENDED sign PREHOOK: type: DESCFUNCTION POSTHOOK: query: DESCRIBE FUNCTION EXTENDED sign POSTHOOK: type: DESCFUNCTION sign(x) - returns the sign of x ) Example: > SELECT sign(40) FROM src LIMIT 1; 1