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

second clause of OR filter not applied in vectorized query execution

    XMLWordPrintableJSON

    Details

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

      Description

      query:

      select ddate, count(*) from factsqlengineam_vec_orc where ddate = "2012-05-19 00:00:00" OR ddate = "2012-05-20 00:00:00" group by ddate;

      Actual result:

      OK
      2012-05-19 00:00:00 528741

      Expected result:

      There would be two rows, one for each day in the OR clause in the query.

      This query actually returns a row, so there is data there for 2012-05-20.

      select ddate, count(*) from factsqlengineam_vec_orc where ddate = "2012-05-20 00:00:00" group by ddate;

        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: