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

["Tim Armstrong (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/IMPALA-5689?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Tim Armstrong resolved IMPALA-5689.
-----------------------------------
       Resolution: Fixed
    Fix Version/s: Impala 2.10.0

commit 9bfcd78bdabe41c22d69afc5684e6bc6f73143af
Author: Taras Bobrovytsky <tb...@cloudera.com>
Date:   Thu Jul 20 15:18:02 2017 -0700

    IMPALA-5689: Avoid inverting non-equi left joins
    
    When checking if a join can be inverted, we forgot to also check that
    the resulting join would not be a non-equi right semi-join or a
    non-equi right outer-join. We currently do not support those kinds of
    joins in the backend.
    
    Testing:
    -Added a planner test
    
    Change-Id: I91ba66fe30139fcd44d4615a142f183266800aab
    Reviewed-on: http://gerrit.cloudera.org:8080/7476
    Reviewed-by: Taras Bobrovytsky <tb...@cloudera.com>
    Tested-by: Impala Public Jenkins


> 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
>             Fix For: Impala 2.10.0
>
>
> 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)