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)
