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

    • Bug
    • Status: Resolved
    • Blocker
    • Resolution: Fixed
    • Impala 2.5.0, Impala 2.6.0
    • Impala 2.7.0
    • Frontend

    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

          breaks

          Bug - A problem which impairs or prevents the functions of the product. IMPALA-5689 Query with no right join fails with an error that mentions a right join

          • Major - Major loss of function.
          • Resolved
          relates to

          Bug - A problem which impairs or prevents the functions of the product. IMPALA-3064 thread-resource-mgr.cc:92] Check failed: thread_available_fn_ == __null || fn == __null

          • Major - Major loss of function.
          • Resolved

          Bug - A problem which impairs or prevents the functions of the product. IMPALA-2909 Unable to plan right outer join when select is constant NULL

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Resolved

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved: