[IMPALA-5689] Query with no right join fails with an error that mentions a right join

• 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
• Epic Color: ghx-label-4
• Assignee: Taras Bobrovytsky
• Reporter: Taras Bobrovytsky
• Created: 20/Jul/17 21:46
• Updated: 23/Aug/17 05:42
• Resolved: 23/Aug/17 05:42

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.

Issue Links

• is broken by: IMPALA-3063 NotImplementedException: ... RIGHT OUTER JOIN ... can only be executed with a single node plan