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

Match materialized views when predicates contain strings and ranges

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 1.5.0
    • Component/s: None
    • Labels:
      None

      Description

      This is in continuation of CALCITE-786 where queries are optimized using materialized views. Earlier we were not supporting predicates that were specifying ranges over a variable, for e.g., x < 90 and x > 30. No we would be able to optimize even when such predicates are used either in query or to specify a view.

      Also adding support for strings for the same optimization.

        Activity

        Hide
        amargoor Amogh Margoor added a comment - - edited

        Hi Julian Hyde

        I raised a PR for the same: https://github.com/apache/incubator-calcite/pull/156
        Testing: Travis build successful on qubole's fork of master branch: https://travis-ci.org/qubole/incubator-calcite/builds/86120945. This fork's master is same as the latest master under apache.

        Can you please review it and merge it if suitable ?

        Regards,
        Amogh

        Show
        amargoor Amogh Margoor added a comment - - edited Hi Julian Hyde I raised a PR for the same: https://github.com/apache/incubator-calcite/pull/156 Testing: Travis build successful on qubole's fork of master branch: https://travis-ci.org/qubole/incubator-calcite/builds/86120945 . This fork's master is same as the latest master under apache. Can you please review it and merge it if suitable ? Regards, Amogh
        Hide
        julianhyde Julian Hyde added a comment -

        I'm at an off-site today. I'll take a look tomorrow.

        Show
        julianhyde Julian Hyde added a comment - I'm at an off-site today. I'll take a look tomorrow.
        Show
        julianhyde Julian Hyde added a comment - Fixed in http://git-wip-us.apache.org/repos/asf/incubator-calcite/commit/9db3b023 . Amogh Margoor , Thanks for the PR!
        Hide
        jcamachorodriguez Jesus Camacho Rodriguez added a comment -

        Resolved in release 1.5.0 (2015-11-10)

        Show
        jcamachorodriguez Jesus Camacho Rodriguez added a comment - Resolved in release 1.5.0 (2015-11-10)

          People

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

            Dates

            • Created:
              Updated:
              Resolved:

              Development