[jira] [Assigned] (IMPALA-1880) pmod() sometimes returns negative values

["Tim Armstrong (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/IMPALA-1880?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Tim Armstrong reassigned IMPALA-1880:
-------------------------------------

    Assignee:     (was: Zuo Wang)

> pmod() sometimes returns negative values
> ----------------------------------------
>
>                 Key: IMPALA-1880
>                 URL: https://issues.apache.org/jira/browse/IMPALA-1880
>             Project: IMPALA
>          Issue Type: Bug
>          Components: Backend
>    Affects Versions: Impala 2.2
>            Reporter: John Russell
>            Priority: Minor
>              Labels: sql-language, supportability
>
> I noticed when constructing examples to compare/contrast fmod(), pmod(), and the new mod() function that pmod() sometimes returns a negative value, despite its being stated to be the "positive" modulus:
> {code}
> [localhost:21000] > select pmod(5,-2);
> +-------------+
> | pmod(5, -2) |
> +-------------+
> | -1          |
> +-------------+
> {code}
> I see that's the same return value as Hive:
> {code}
> hive> select pmod(5,-2) from t1 limit 1;
> Total MapReduce jobs = 1
> ...
> OK
> -1
> Time taken: 29.269 seconds
> {code}
> This seems to be the origin of the Hive pmod() function, it isn't spec'ed out in detail: https://issues.apache.org/jira/browse/HIVE-656
> I thought we should verify that our behavior is working as intended, and if so let's firm up the explanation of the function a big. ("Returns the positive modulus except if second argument negative", or something like that.)



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-all-unsubscribe@impala.apache.org
For additional commands, e-mail: issues-all-help@impala.apache.org