[
https://issues.apache.org/jira/browse/IMPALA-15268?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Steve Carlin reassigned IMPALA-15268:
-------------------------------------
Assignee: Steve Carlin
> Calcite Planner: Fix failure with no equality join condition
> ------------------------------------------------------------
>
> Key: IMPALA-15268
> URL: https://issues.apache.org/jira/browse/IMPALA-15268
> Project: IMPALA
> Issue Type: Sub-task
> Reporter: Steve Carlin
> Assignee: Steve Carlin
> Priority: Major
>
> The following query fails after upgrading to 1.41:
>
> select a.id, b.id, c.id, a.day, b.day, c.month, a.month, b.month
> from alltypesagg a join alltypesagg b on
> (a.id = b.id and a.month = b.day and b.month = 1 and b.month = b.day and
> a.day = b.day)
> left outer join alltypessmall c on
> (c.id = a.id and a.month = c.id and a.month=c.month)
> where a.id < 10;
>
> when running test
> query_test.test_join_queries.TestJoinQueries.test_outer_joins
>
> The reason is because a join condition contains =($0,$1), and both are on
> the
> same side. It cannot be pushed because JOIN_CONDITION_PUSH does not allow
> the push to the left side. So we need to skip over putting this into the
> equality constraints
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
