Uploaded image for project: 'Calcite'
  1. Calcite
  2. CALCITE-2275

Do not push down NOT condition in JOIN

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 1.16.0
    • 1.17.0
    • core
    • None

    Description

      Using logical NOT operator in Join condition leads to mistakenly push down this condition. Then LogicalProject is created with RexCall expression. It prevents for further inferring predicates (by using JoinPushTransitivePredicatesRule, for instance).

      Query example:

      select * from sales.emp d join sales.emp e on e.deptno = d.deptno and d.deptno not in (4, 6)

      Attachments

        Issue Links

          Is contained by

          Improvement - An improvement or enhancement to an existing feature or task. DRILL-6350 Umbrella jira which tracks issues connected to Transitive Closure Inference

          • Major - Major loss of function.
          • Open
          relates to

          Improvement - An improvement or enhancement to an existing feature or task. DRILL-6173 Support transitive closure during filter push down and partition pruning

          • Major - Major loss of function.
          • Resolved
          links to

          Web Link PR-675

          Activity

            People

              vitalii Vitalii Diravka
              vitalii Vitalii Diravka
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: