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

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

Agile BoardAttach filesAttach ScreenshotVotersWatch issueWatchersCreate sub-taskLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • Impala 2.9.0
    • Impala 2.10.0
    • Frontend
    • None
    • 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

          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

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

            Dates

              Created:
              Updated:
              Resolved:

              Issue deployment