[jira] [Updated] (HIVE-17240) function acos(2) should be null
[ https://issues.apache.org/jira/browse/HIVE-17240?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Yuming Wang updated HIVE-17240: --- Attachment: HIVE-17240.1.patch > function acos(2) should be null > --- > > Key: HIVE-17240 > URL: https://issues.apache.org/jira/browse/HIVE-17240 > Project: Hive > Issue Type: Bug > Components: UDF >Affects Versions: 1.1.1, 1.2.2, 2.2.0 >Reporter: Yuming Wang > Attachments: HIVE-17240.1.patch > > > {{acos(2)}} should be null, same as MySQL: > {code:sql} > 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) > {code} > {code:sql} > mysql> select acos(2); > +-+ > | acos(2) | > +-+ > |NULL | > +-+ > 1 row in set (0.00 sec) > {code} -- This message was sent by Atlassian JIRA (v6.4.14#64029)
[jira] [Updated] (HIVE-17240) function acos(2) should be null
[ https://issues.apache.org/jira/browse/HIVE-17240?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Yuming Wang updated HIVE-17240: --- Assignee: Yuming Wang Status: Patch Available (was: Open) > function acos(2) should be null > --- > > Key: HIVE-17240 > URL: https://issues.apache.org/jira/browse/HIVE-17240 > Project: Hive > Issue Type: Bug > Components: UDF >Affects Versions: 2.2.0, 1.2.2, 1.1.1 >Reporter: Yuming Wang >Assignee: Yuming Wang > Attachments: HIVE-17240.1.patch > > > {{acos(2)}} should be null, same as MySQL: > {code:sql} > 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) > {code} > {code:sql} > mysql> select acos(2); > +-+ > | acos(2) | > +-+ > |NULL | > +-+ > 1 row in set (0.00 sec) > {code} -- This message was sent by Atlassian JIRA (v6.4.14#64029)