PREHOOK: query: DESCRIBE FUNCTION acos PREHOOK: type: DESCFUNCTION POSTHOOK: query: DESCRIBE FUNCTION acos POSTHOOK: type: DESCFUNCTION acos(x) - returns the arc cosine of x if -1<=x<=1 or NULL otherwise PREHOOK: query: DESCRIBE FUNCTION EXTENDED acos PREHOOK: type: DESCFUNCTION POSTHOOK: query: DESCRIBE FUNCTION EXTENDED acos POSTHOOK: type: DESCFUNCTION acos(x) - returns the arc cosine of x if -1<=x<=1 or NULL otherwise Example: > SELECT acos(1) FROM src LIMIT 1; 0 > SELECT acos(2) FROM src LIMIT 1; NULL PREHOOK: query: SELECT acos(null) FROM src LIMIT 1 PREHOOK: type: QUERY PREHOOK: Input: default@src #### A masked pattern was here #### POSTHOOK: query: SELECT acos(null) FROM src LIMIT 1 POSTHOOK: type: QUERY POSTHOOK: Input: default@src #### A masked pattern was here #### NULL PREHOOK: query: SELECT acos(0) FROM src LIMIT 1 PREHOOK: type: QUERY PREHOOK: Input: default@src #### A masked pattern was here #### POSTHOOK: query: SELECT acos(0) FROM src LIMIT 1 POSTHOOK: type: QUERY POSTHOOK: Input: default@src #### A masked pattern was here #### 1.5707963267948966 PREHOOK: query: SELECT acos(-0.5), asin(0.66) FROM src LIMIT 1 PREHOOK: type: QUERY PREHOOK: Input: default@src #### A masked pattern was here #### POSTHOOK: query: SELECT acos(-0.5), asin(0.66) FROM src LIMIT 1 POSTHOOK: type: QUERY POSTHOOK: Input: default@src #### A masked pattern was here #### 2.0943951023931957 0.7208187608700897 PREHOOK: query: SELECT acos(2) FROM src LIMIT 1 PREHOOK: type: QUERY PREHOOK: Input: default@src #### A masked pattern was here #### POSTHOOK: query: SELECT acos(2) FROM src LIMIT 1 POSTHOOK: type: QUERY POSTHOOK: Input: default@src #### A masked pattern was here #### NaN