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

    • Sub-task
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • vectorization-branch
    • 0.13.0
    • Query Processor
    • 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

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

              Dates

                Created:
                Updated:
                Resolved: