Uploaded image for project: 'Apache Drill'
  1. Apache Drill
  2. DRILL-4794

Regression: Wrong result for query with disjunctive partition filters

    XMLWordPrintableJSON

    Details

      Description

      For a query that contains certain types of disjunctive filter conditions such as 'dir0=x OR dir1=y' we get wrong result when metadata caching is used. This is a regression due to DRILL-4530.

      Note that the filter involves OR of 2 different directory levels. For the normal case of OR condition at the same level the problem does not occur.

      Correct result (without metadata cache)

      0: jdbc:drill:zk=local> select count(*) from dfs.`orders` where dir0=1994 or dir1='Q3' ;
      +---------+
      | EXPR$0  |
      +---------+
      | 60      |
      +---------+
      

      Wrong result (with metadata cache):

      0: jdbc:drill:zk=local> select count(*) from dfs.`orders` where dir0=1994 or dir1='Q3' ;
      +---------+
      | EXPR$0  |
      +---------+
      | 50      |
      +---------+
      

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                amansinha100 Aman Sinha
                Reporter:
                amansinha100 Aman Sinha
                Reviewer:
                Rahul Kumar Challapalli
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: