Apache Drill
  1. Apache Drill
  2. DRILL-485

Support non-equijoins as long as there is at least 1 equijoin condition between the same 2 tables

    Details

      Description

      Currently, if the query has a non-equijoin between tables t1, t2 we throw an error that it is unsupported. However, if there is at least one equijoin between the tables t1, t2 in addition to the non-equijoin, then we should perform the join and then do a filter on top using the non-equijoin condition.
      example queries where this could be applicable:
      SELECT a1 FROM t1, t2 WHERE b1 = b2 AND c1 < c2;
      SELECT a1 FROM t1, t2 WHERE b1 = b2 AND (c1 = c2 OR d1 = d2);

        Activity

          People

          • Assignee:
            DrillCommitter
            Reporter:
            Aman Sinha
          • Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development