[ https://issues.apache.org/jira/browse/IMPALA-1880?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Tim Armstrong updated IMPALA-1880: ---------------------------------- Labels: sql-language (was: sql-language supportability) > 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 > > 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-unsubscr...@impala.apache.org For additional commands, e-mail: issues-all-h...@impala.apache.org