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

NotImplementedException: ... RIGHT OUTER JOIN ... can only be executed with a single node plan

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Blocker
    • Resolution: Fixed
    • Affects Version/s: Impala 2.5.0, Impala 2.6.0
    • Fix Version/s: Impala 2.7.0
    • Component/s: Frontend
    • Labels:

      Description

      Please see below.

      Query: select 1
      FROM alltypes a1
      LEFT JOIN alltypes a2 ON a2.tinyint_col >= 1
      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.
      

      The error message must be referencing some rewritten version of the query? The original query has no RIGHT OUTER JOIN.

      Also the message references "single node plan" which users may not understand.

      What's worse is if you "SET NUM_NODES=1" there is a dcheck. I'll file a separate issue about that.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                alex.behm Alexander Behm
                Reporter:
                caseyc casey
              • Votes:
                0 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: