[HIVE-17240] Function ACOS(2) and ASIN(2) should be null

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.1.1, 1.2.2, 2.2.0
• Fix Version/s: 3.0.0
• Component/s: UDF
• Labels: pull-request-available
• Assignee: Yuming Wang
• Reporter: Yuming Wang
• Created: 03/Aug/17 09:38
• Updated: 22/May/18 23:59
• Resolved: 21/Oct/17 00:14

Description

acos(2) should be null, same as MySQL:

hive> desc function extended acos;
OK
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
Time taken: 0.009 seconds, Fetched: 6 row(s)
hive> select acos(2);
OK
NaN
Time taken: 0.437 seconds, Fetched: 1 row(s)

mysql>  select acos(2);
+---------+
| acos(2) |
+---------+
|    NULL |
+---------+
1 row in set (0.00 sec)

Issue Links

• is related to: SPARK-21635 ACOS(2) and ASIN(2) should be null
• links to: GitHub Pull Request #221