Questions With Materialized Views

2022-01-20 Thread
hello, This problems keeps making me puzzled. question1: what is the differences between the two implemenrations of view-based query rewriting?Advantages and disadvantages based on view substitution( SubstitutionVisitor、rules:unifyrule) Rewriting using plan structural information(rules:Ma

Some questions With code reading about Materialized Views

2022-02-08 Thread
hello, I'm reading code anout materialized views , up to now,I have accumulated a lot of problems ,These problems keeps making me puzzled. question1: what is the schema for query it‘s related materialized views(MaterializationService.query(CalciteSchema rootSchema)),I d

Some questions With code reading about Materialized Views

2022-02-08 Thread
hello, I'm reading code anout materialized views , This problems keeps making me puzzled. In the UnifyRule , what does SlotCount mean? can you give some examples? I look forward to hearing from you very much thanks rules transformation Permalink

Some questions With code reading about MaerialViewRule

2022-02-09 Thread
hello, I'm reading code anout materialized views , This problems keeps making me puzzled. how can I test the rule of AggregateProjectStarTableRule? I want to lean about Lattice in materialView, but I can't find any test case for that. I look forward to hearing from you very much t

Some questions about lattices

2022-02-14 Thread
hello, I'm reading code about star materialized views ,These problems keeps making me puzzled. can you tell me some information about the lattice and star-materialization-view ? from the code ,I find two place about star-materialization-view: 1. before use materialization by UnifyRule p

questions about materialization view with windowing function

2022-02-15 Thread
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 f