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 PREHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/959577580/10000 POSTHOOK: query: SELECT acos(null) FROM src LIMIT 1 POSTHOOK: type: QUERY POSTHOOK: Input: default@src POSTHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/959577580/10000 NULL PREHOOK: query: SELECT acos(0) FROM src LIMIT 1 PREHOOK: type: QUERY PREHOOK: Input: default@src PREHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/227674626/10000 POSTHOOK: query: SELECT acos(0) FROM src LIMIT 1 POSTHOOK: type: QUERY POSTHOOK: Input: default@src POSTHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/227674626/10000 1.5707963267948966 PREHOOK: query: SELECT acos(-0.5), asin(0.66) FROM src LIMIT 1 PREHOOK: type: QUERY PREHOOK: Input: default@src PREHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/1521007936/10000 POSTHOOK: query: SELECT acos(-0.5), asin(0.66) FROM src LIMIT 1 POSTHOOK: type: QUERY POSTHOOK: Input: default@src POSTHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/1521007936/10000 2.0943951023931957 0.7208187608700897 PREHOOK: query: SELECT acos(2) FROM src LIMIT 1 PREHOOK: type: QUERY PREHOOK: Input: default@src PREHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/325299096/10000 POSTHOOK: query: SELECT acos(2) FROM src LIMIT 1 POSTHOOK: type: QUERY POSTHOOK: Input: default@src POSTHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/325299096/10000 NaN