I have a question about the reflection（is also materialization view） with windowing function.
My understanding is that，
Relecitions with windowing function must not exist filter and select items must can be expressed from view select item expressions
in the calcite：
the unifyRule focus on part pattern，so it can’t match.
the MaterializedViewRule can’t match too, I can’t find any code adout that sofa. but if I want to match, I should extend it in MaterializedViewRule but not unifyRule
Is my understanding right ?
is dremio match this case? if matched, how does it do?
reflection with windowing function example:
sum(1) over(PARTITIONby ds,workspace_name orderby ds asc) as sum_cnt,
sum(1) over(PARTITIONby ds orderby ds asc) as sum_cnt
from dwd_airengine_query_pattern_delta_ht ;
I look forward to learn from you very much