You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@calcite.apache.org by 武思 <wu...@163.com> on 2022/04/04 02:14:06 UTC

Some Questions For Calcite MaterializedViewJoinRule and UnifyRules

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