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

Extend materialized view rewriting to produce rewritings using Union operators

    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

      Extend join/aggregate materialized rewriting rule to produce rewritings using Union operators, e.g., a given query could be partially answered from the MV (year = 2014) and from the query (not(year=2014)). If the MV is stored e.g. in Druid, this rewriting might be beneficial. As with the other rewritings, decision on whether to finally use the rewriting is cost-based.

        Issue Links

          Activity

          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).
          Hide
          jcamachorodriguez Jesus Camacho Rodriguez added a comment -

          Fixed in http://git-wip-us.apache.org/repos/asf/calcite/commit/1342d4c.

          Includes fix for RexSimplify.processRange discovered while adding tests. In particular, we would get an 'Invalid range' Exception when range had same value for both open bounds, e.g., (20..20] or [20..20) would not throw an Exception, but (20..20) would.

          Show
          jcamachorodriguez Jesus Camacho Rodriguez added a comment - Fixed in http://git-wip-us.apache.org/repos/asf/calcite/commit/1342d4c . Includes fix for RexSimplify.processRange discovered while adding tests. In particular, we would get an 'Invalid range' Exception when range had same value for both open bounds, e.g., (20..20] or [20..20) would not throw an Exception, but (20..20) would.

            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