[CALCITE-1389] Add rule to perform rewriting of queries using materialized views with joins

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.11.0
• Component/s: core
• Assignee: Michael Mior
• Reporter: Michael Mior
• Created: 27/Sep/16 18:26
• Updated: 27/Feb/24 22:24
• Resolved: 01/Nov/16 22:29

Description

I've been looking into implementing the approach from the following paper. It's very nicely written and easy to follow. It also doesn't require trying different join permutations. I'm starting with several additional restrictions (only equijoins, no aggregations, etc.)

ftp://ftp.cse.buffalo.edu/users/azhang/disc/SIGMOD/pdf-files/331/202-optimizing.pdf

Thanks to jcamachorodriguez for his help in sorting out some issues with the rule so far.

Issue Links

• is superceded by: CALCITE-1731 Rewriting of queries using materialized views with joins and aggregates