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

second clause of AND, OR filter not applied for vectorized execution

    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

      Query

      select ddate, dnumbertables23008 from factsqlengineam_vec_orc where ddate = "2013-01-08 00:00:00" and dnumbertables23008 = 1052436;

      returns rows where dnumbertables23008 != 1052436.

      Actual results:

      636087 rows

      Sample:

      ...
      2013-01-08 00:00:00 0
      2013-01-08 00:00:00 0
      2013-01-08 00:00:00 108
      2013-01-08 00:00:00 0
      2013-01-08 00:00:00 0
      2013-01-08 00:00:00 1625
      2013-01-08 00:00:00 210
      2013-01-08 00:00:00 0
      2013-01-08 00:00:00 209
      2013-01-08 00:00:00 0
      ...

      Expected results:

      Either no rows returned, or all rows have 1052436 in second column.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                jnp Jitendra Nath Pandey
                Reporter:
                ehans Eric N. Hanson
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: