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

Star table wrongly assigned to materialized view

    XMLWordPrintableJSON

Details

    • Task
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 1.4.0-incubating, 1.3.0-incubating
    • 1.4.0-incubating
    • core
    • None

    Description

      cc: vrajat

      CalciteMaterializer tries to rewrite query relnode with the star table in schema (the first one that fits). Utility function used is RelOptMaterialization::tryUseStar. Utility function should return null when it cannot rewrite relnode using star table, but instead it is returning the same relnode back. This is causing MV being assigned star table even when it is not required.

      Attachments

        Activity

          People

            julianhyde Julian Hyde
            amargoor Amogh Margoor
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: