[jira] [Updated] (HIVE-17240) Function ACOS(2) and ASIN(2) should be null
[ https://issues.apache.org/jira/browse/HIVE-17240?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated HIVE-17240: -- Labels: pull-request-available (was: ) > Function ACOS(2) and ASIN(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 >Assignee: Yuming Wang > Labels: pull-request-available > Fix For: 3.0.0 > > Attachments: HIVE-17240.1.patch, HIVE-17240.2.patch, > HIVE-17240.3.patch, HIVE-17240.4.patch, HIVE-17240.5.patch, HIVE-17240.6.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) and ASIN(2) should be null
[ https://issues.apache.org/jira/browse/HIVE-17240?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ashutosh Chauhan updated HIVE-17240: Resolution: Fixed Fix Version/s: 3.0.0 Status: Resolved (was: Patch Available) Pushed to master. Thanks, Yuming! > Function ACOS(2) and ASIN(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 >Assignee: Yuming Wang > Fix For: 3.0.0 > > Attachments: HIVE-17240.1.patch, HIVE-17240.2.patch, > HIVE-17240.3.patch, HIVE-17240.4.patch, HIVE-17240.5.patch, HIVE-17240.6.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) and ASIN(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.6.patch > Function ACOS(2) and ASIN(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 >Assignee: Yuming Wang > Attachments: HIVE-17240.1.patch, HIVE-17240.2.patch, > HIVE-17240.3.patch, HIVE-17240.4.patch, HIVE-17240.5.patch, HIVE-17240.6.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) and ASIN(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: --- Summary: Function ACOS(2) and ASIN(2) should be null (was: function ACOS(2) and ASIN(2) should be null) > Function ACOS(2) and ASIN(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 >Assignee: Yuming Wang > Attachments: HIVE-17240.1.patch, HIVE-17240.2.patch, > HIVE-17240.3.patch, HIVE-17240.4.patch, HIVE-17240.5.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) and ASIN(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.5.patch > function ACOS(2) and ASIN(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 >Assignee: Yuming Wang > Attachments: HIVE-17240.1.patch, HIVE-17240.2.patch, > HIVE-17240.3.patch, HIVE-17240.4.patch, HIVE-17240.5.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) and ASIN(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.4.patch > function ACOS(2) and ASIN(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 >Assignee: Yuming Wang > Attachments: HIVE-17240.1.patch, HIVE-17240.2.patch, > HIVE-17240.3.patch, HIVE-17240.4.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) and ASIN(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: --- Status: In Progress (was: Patch Available) > function ACOS(2) and ASIN(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, HIVE-17240.2.patch, > HIVE-17240.3.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) and ASIN(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: --- Status: Patch Available (was: In Progress) > function ACOS(2) and ASIN(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, HIVE-17240.2.patch, > HIVE-17240.3.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) and ASIN(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.3.patch > function ACOS(2) and ASIN(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 >Assignee: Yuming Wang > Attachments: HIVE-17240.1.patch, HIVE-17240.2.patch, > HIVE-17240.3.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) and ASIN(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.2.patch > function ACOS(2) and ASIN(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 >Assignee: Yuming Wang > Attachments: HIVE-17240.1.patch, HIVE-17240.2.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) and ASIN(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: --- Summary: function ACOS(2) and ASIN(2) should be null (was: function acos(2) should be null) > function ACOS(2) and ASIN(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 >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)