[IMPALA-3063] NotImplementedException: ... RIGHT OUTER JOIN ... can only be executed with a single node plan

• 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: regression
• Target Version: Impala 2.7.0
• Assignee: Alexander Behm
• Reporter: casey
• Created: 23/Feb/16 20:39
• Updated: 03/May/18 01:33
• Resolved: 18/Aug/16 03:27

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.

Issue Links

• breaks: IMPALA-5689 Query with no right join fails with an error that mentions a right join
• relates to: IMPALA-3064 thread-resource-mgr.cc:92] Check failed: thread_available_fn_ == __null || fn == __null
• relates to: IMPALA-2909 Unable to plan right outer join when select is constant NULL