Eric Hanson created HIVE-4668:
---------------------------------

             Summary: 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


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

Reply via email to