Taras Bobrovytsky created IMPALA-5689:
-----------------------------------------
Summary: Query with no right join fails with an error that
mentions a right join
Key: IMPALA-5689
URL: https://issues.apache.org/jira/browse/IMPALA-5689
Project: IMPALA
Issue Type: Bug
Components: Frontend
Affects Versions: Impala 2.9.0
Reporter: Taras Bobrovytsky
Assignee: Taras Bobrovytsky
The following query causes an error:
{code}
SELECT *
FROM (
SELECT DISTINCT int_col
FROM functional.alltypes) t1
LEFT OUTER JOIN functional.alltypes t2 ON (t2.bigint_col=5)
{code}
Error:
{code}
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.
{code}
It is strange because there is no right join in the query SQL text.
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
