Uploaded image for project: 'IMPALA'
  1. IMPALA
  2. IMPALA-5689

Query with no right join fails with an error that mentions a right join

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: Impala 2.9.0
    • Fix Version/s: Impala 2.10.0
    • Component/s: Frontend
    • Labels:
      None
    • Epic Color:
      ghx-label-4

      Description

      The following query causes an error:

      SELECT *
      FROM (
        SELECT DISTINCT int_col
        FROM functional.alltypes) t1
      LEFT OUTER JOIN functional.alltypes t2 ON (t2.bigint_col=5)
      

      Error:

      ERROR: NotImplementedException: Error generating a valid execution plan for this query. A RIGHT OUTER JOIN type with no equi-join predicates can only be executed with a single node plan.
      

      It is strange because there is no right join in the query SQL text.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                tarasbob Taras Bobrovytsky
                Reporter:
                tarasbob Taras Bobrovytsky
              • Votes:
                0 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: