ACOS(2) and ASIN(2) return NULL
A change in the result of ACOS(2) and ASIN(2) occurred between CDH and CDP.
Before Upgrade to CDP
The ACOS(2) and ASIN(2) functions returned NAN as shown in the following example:
select acos(2);
NaN
After Upgrade to CDP
HIVE-17240 makes the ACOS(2) and ASIN(2) functions return NULL, consistent with SQL standards.
select acos(2);
NULL