Dear Sir
     I am a Chinese Engineer,  the project in my company use calcite 
materialized views for query acceleration,there are some questions about that
     frist, i find 
org.apache.calcite.rel.rules.materialize.MaterializedViewJoinRule class only 
support inner join type.but for us, when we run star query, we
usually use left join. when we run usual  join query sush as without foreign 
key and unique key,we also use left join query.the question is that now why not 
support left join rewrite in MaterializedViewJoinRule  and in the future,will 
calcite support left join MaterializedViewJoinRule rewrite
    second, There are several different ways to exploit materialized views in 
Calcite. one is Substitution via rules transformation which use UnifyRules, 
another is Rewriting using plan structural information which use 
materializedView. in the future will UnifyRules be discard and then focus on 
MaterializedViewRule?
thanks for all
          Best Regards

Reply via email to