Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-4160 Vectorized Query Execution in Hive
  3. HIVE-4668

wrong results for query with modulo (%) in WHERE clause filter

    XMLWordPrintableJSON

    Details

    • Type: Sub-task
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: vectorization-branch
    • Fix Version/s: 0.13.0
    • Component/s: Query Processor
    • Labels:
      None

      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.

        Attachments

          Activity

            People

            • Assignee:
              sarvesh.sn Sarvesh Sakalanaga
              Reporter:
              ehans Eric N. Hanson
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: