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