[ https://issues.apache.org/jira/browse/IMPALA-6202?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16508865#comment-16508865 ]
Taras Bobrovytsky commented on IMPALA-6202: ------------------------------------------- Ideally, it would be best to fix it in my opinion. It's weird that mod() and % do not behave identically. This could be a good ramp up task for new contributors trying to get familiar with Impala. > fmod and mod and % are not equivalent > ------------------------------------- > > Key: IMPALA-6202 > URL: https://issues.apache.org/jira/browse/IMPALA-6202 > Project: IMPALA > Issue Type: Bug > Components: Docs > Affects Versions: Impala 2.11.0 > Reporter: Jim Apple > Assignee: Alex Rodoni > Priority: Major > > The docs say: > "mod(numeric_type a, same_type b) Purpose: Returns the modulus of a number. > Equivalent to the % arithmetic operator." > and > "fmod(double a, double b), fmod(float a, float b) Purpose: Returns the > modulus of a floating-point number. Equivalent to the % arithmetic operator." > But these can't both be true: > {noformat} > [localhost:21000] > select typeof(9.9 % 3), typeof(mod(9.9, 3)), > typeof(fmod(9.9, 3)); > +-----------------+---------------------+----------------------+ > | typeof(9.9 % 3) | typeof(mod(9.9, 3)) | typeof(fmod(9.9, 3)) | > +-----------------+---------------------+----------------------+ > | DECIMAL(2,1) | DECIMAL(4,1) | FLOAT | > +-----------------+---------------------+----------------------+ > {noformat} -- 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