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

Throw unsupported error message in case of inequality join

    XMLWordPrintableJSON

    Details

      Description

      Since we don't support inequality join, the whole class of queries will throw huge page long "Can't plan exception"
      This is a request to throw a nice error message that we throw in case of cartesian join in these cases as well.

       
      select * from t1 left outer join t2  on (t1.a1 = t2.a2 and t1.b2 <> t2.b2);
      select * from t1 right outer join t2 on (t1.a1 = t2.a2 and t1.b2 <> t2.b2);
      

      Example of an exception:

      0: jdbc:drill:schema=dfs> select * from t1 inner join t2 on(t1.b1 <> t2.b2);
      Query failed: UnsupportedRelOperatorException: This query cannot be planned possibly due to either a cartesian join or an inequality join
      Error: exception while executing query: Failure while executing query. (state=,code=0)
      

        Attachments

        1. DRILL-2441.1.patch
          3 kB
          Sean Hsuan-Yi Chu

          Activity

            People

            • Assignee:
              amansinha100 Aman Sinha
              Reporter:
              vicky Victoria Markman
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: