[HIVE-4668] wrong results for query with modulo (%) in WHERE clause filter

• Type: Sub-task
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: vectorization-branch
• Fix Version/s: 0.13.0
• Component/s: Query Processor
• Assignee: Sarvesh Sakalanaga
• Reporter: Eric N. Hanson
• Created: 05/Jun/13 22:35
• Updated: 24/Mar/14 20:39
• Resolved: 08/Jun/13 04:51

Description

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.