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