[
https://issues.apache.org/jira/browse/HIVE-4668?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Jitendra Nath Pandey resolved HIVE-4668.
----------------------------------------
Resolution: Fixed
> wrong results for query with modulo (%) in WHERE clause filter
> --------------------------------------------------------------
>
> Key: HIVE-4668
> URL: https://issues.apache.org/jira/browse/HIVE-4668
> Project: Hive
> Issue Type: Sub-task
> Components: Query Processor
> Affects Versions: vectorization-branch
> Reporter: Eric Hanson
> Assignee: Sarvesh Sakalanaga
>
> select disinternalmsft16431, count(disinternalmsft16431) from
> factsqlengineam_vec_orc where ddate >= "2012-12" and ddate < "2013-02" and
> disinternalmsft16431 % 5 = 0 group by disinternalmsft16431
> Expected result:
> 0 3160232
> 5 33039254
> Actual result:
> 0 8697033
> 6 2706407
> 5 94709959
> There should be no result row for 6 because 6 % 5 != 0.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
