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)