Thanks for the reply! I do understand from doc that the incremental update of MV is triggered upon base table change.
But I cannot find the actual code in Doris code base that does the update, specifically the actual incremental plan (tree of operator generated by the optimizer) to update the view result. For example, if the view is "Select * from A inner join B". Then for each new line in A, it needs to join all rows in B to get the correct updates to the view. Or if the view is "Select avg(score) from A", then I assume the plan for the update should be something like "Select sum(score), count(score) from \delta A". Thanks, Botong On Fri, Sep 23, 2022 at 9:46 PM Mingyu Chen <morning...@163.com> wrote: > It controls by load process. > After a mv is built, all following load task will generate many copies of > import data to base table and all materialized views. > So the incremental update happens on every load task. > > > > > -- > > 此致！Best Regards > 陈明雨 Mingyu Chen > > Email: > morning...@apache.org > > > > > > 在 2022-09-21 15:59:17，"Botong Huang" <pku...@gmail.com> 写道： > >Hi all, > > > >Does anyone know where the code is for generating the incremental plan for > >updating the materialized view when the base table receives new data? Many > >thanks! > > > >想知道物化视图的增量维护的plan生成的代码在哪里，谢谢！ > > > >Best, > >Botong >
