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

Support view partial rewriting in join materialized view rewriting

    Details

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

      Description

      Simple extension for AbstractMaterializedViewRule to support case when view contains a subset of the tables of the query and tables are joined in different order in the query and view plans.

      For instance:
      View (m0): (A JOIN B) JOIN C
      Query: (((A JOIN B) JOIN D) JOIN C) JOIN E
      MV rewriting: ((m0 JOIN D) JOIN E)

      Basically, once we have found the missing tables, we add them to the view and view plan. Then the rewriting algorithm works the same way and will enforce any predicate that is in the query and not in the view.

        Issue Links

          Activity

          Show
          jcamachorodriguez Jesus Camacho Rodriguez added a comment - Fixed in http://git-wip-us.apache.org/repos/asf/calcite/commit/6689c75 .
          Hide
          jcamachorodriguez Jesus Camacho Rodriguez added a comment -

          Resolved in release 1.13.0 (2017-06-26).

          Show
          jcamachorodriguez Jesus Camacho Rodriguez added a comment - Resolved in release 1.13.0 (2017-06-26).

            People

            • Assignee:
              jcamachorodriguez Jesus Camacho Rodriguez
              Reporter:
              jcamachorodriguez Jesus Camacho Rodriguez
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Development