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

Add support for Null Equality Joins

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Closed
    • Major
    • Resolution: Duplicate
    • 1.8.0
    • None
    • None

    Description

      Join with an equality condition which allows null=null fails. For example, if we use some of this queries:

      select ... FROM t1, t2 WHERE t1.c1 = t2.c2 OR (t1.c1 IS NULL AND t2.c2 IS NULL);
      
      select ... FROM t1 INNER JOIN  t2 ON  t1.c1 = t2.c2 OR (t1.c1 IS NULL AND t2.c2 IS NULL);
      

      we got "UNSUPPORTED_OPERATION ERROR". We should add support of this option.

      Attachments

        Issue Links

          Activity

            People

              RomanKulyk Roman Kulyk
              RomanKulyk Roman Kulyk
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: