calcite-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Christian Beikov (JIRA)" <j...@apache.org>
Subject [jira] [Created] (CALCITE-1965) Support outer joins for materialized views
Date Thu, 24 Aug 2017 13:47:00 GMT
Christian Beikov created CALCITE-1965:
-----------------------------------------

             Summary: Support outer joins for materialized views
                 Key: CALCITE-1965
                 URL: https://issues.apache.org/jira/browse/CALCITE-1965
             Project: Calcite
          Issue Type: Improvement
          Components: core
            Reporter: Christian Beikov
            Assignee: Julian Hyde


Currently, only inner joins are supported for materialized view substitutions. The support
for outer joins involves creating new pulled up predicates in case of outer joins that represent
semantics of the join. For a join predicate like "a.id = b.id" the inner join just pulls up
that predicate. When having a left join like e.g. {{select * from a left join b on a.id =
b.id}}, the actual pulled up predicate would be {{OR(=(a.id, b.id),ISNULL(b.id))}}. For a
right join it would be  {{OR(=(a.id, b.id),ISNULL(a.id))}} and for a full outer join it would
be  {{OR(=(a.id, b.id),ISNULL(a.id),ISNULL(b.id))}}



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)

Mime
View raw message