[CALCITE-5364] In materialized view substitution, use custom time frames

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Assignee: Unassigned
• Reporter: Julian Hyde
• Created: 02/Nov/22 23:09
• Updated: 02/Nov/22 23:14

Description

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)).

Issue Links

• is related to: CALCITE-5155 Custom time frames
• is related to: CALCITE-5240 Enhance MaterializedViewRule so that it applies to rollup view for queries that contain a predicate on the rollup column