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

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

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Closed
    • Major
    • Resolution: Fixed
    • None
    • 1.11.0
    • core
    • 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 jcamachorodriguez for his help in sorting out some issues with the rule so far.

      Attachments

        Issue Links

          is superceded by

          New Feature - A new feature of the product, which has yet to be developed. CALCITE-1731 Rewriting of queries using materialized views with joins and aggregates

          • Major - Major loss of function.
          • Closed

          Activity

            People

              mmior Michael Mior
              mmior Michael Mior
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: