Uploaded image for project: 'Calcite'
  1. Calcite
  2. CALCITE-1389

Add rule to perform rewriting of queries using materialized views with joins

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 1.11.0
    • Component/s: core
    • Labels:
      None

      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 Jesus Camacho Rodriguez for his help in sorting out some issues with the rule so far.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                michaelmior Michael Mior
                Reporter:
                michaelmior Michael Mior
              • Votes:
                0 Vote for this issue
                Watchers:
                5 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: