[CALCITE-1965] Support outer joins for materialized views

• Type: Improvement
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Component/s: core
• Labels: pull-request-available
• Assignee: Unassigned
• Reporter: Christian Beikov
• Created: 24/Aug/17 13:46
• Updated: 27/Feb/24 22:24

Description

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))

Issue Links

• links to: GitHub Pull Request #526