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