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