You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@calcite.apache.org by "Julian Hyde (Jira)" <ji...@apache.org> on 2022/11/02 23:10:00 UTC

[jira] [Created] (CALCITE-5364) In materialized view substitution, use custom time frames

Julian Hyde created CALCITE-5364:
------------------------------------

             Summary: In materialized view substitution, use custom time frames
                 Key: CALCITE-5364
                 URL: https://issues.apache.org/jira/browse/CALCITE-5364
             Project: Calcite
          Issue Type: Bug
            Reporter: Julian Hyde


Custom time frames were added in CALCITE-5155, and part of the definition of a custom time frame is the time frames it rolls up to. Materialized view substitution should use this information, so that you can create materialized views on custom time frames such as '15 minutes' or '21 days' and have them roll up.

Also you should be able to use materialized views (on custom and regular time frames) to answer queries with custom time frames (e.g. {{FLOOR(orderDate TO month6)}}).



--
This message was sent by Atlassian Jira
(v8.20.10#820010)