questions about materialization view with windowing function

[徐保荣]

hello,
     I have a question about the materialization view with windowing function.
Like the following，can the unifyRule and the MaterializedViewRule match？
 My understanding is that，
     materialization view with windowing function must not exist filter and 
select items must can be expressed from view select item expressions
     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


    I really want to know that Is my understanding right ? 


    materialization view with windowing function case:
 SELECT
   ds,workspace_name,
   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 hearing from you very much
thanks





 rules transformation
Permalink