Details
-
Bug
-
Status: Resolved
-
Major
-
Resolution: Fixed
-
Impala 2.9.0
-
None
-
ghx-label-4
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.
Attachments
Issue Links
- is broken by
-
IMPALA-3063 NotImplementedException: ... RIGHT OUTER JOIN ... can only be executed with a single node plan
- Resolved