Re: Re: Code for incremental plan of materialized view upon data change

2022-09-23 Thread Botong Huang
Cool, thx a lot! Best, Botong On Fri, Sep 23, 2022 at 11:46 PM Mingyu Chen wrote: > Currently, Doris does not support multi-table materialized view. > So the mv with join is not supported yet. > > > Doris only support mv for single table, with some certain aggregation such > as sum, min, max, c

Re:Re: Code for incremental plan of materialized view upon data change

2022-09-23 Thread Mingyu Chen
Currently, Doris does not support multi-table materialized view. So the mv with join is not supported yet. Doris only support mv for single table, with some certain aggregation such as sum, min, max, count, count(dinstinct) For example, there is a base table A with column (k1, k2, v1, v2), you c

Re: Code for incremental plan of materialized view upon data change

2022-09-23 Thread Botong Huang
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 vie

Re:Code for incremental plan of materialized view upon data change

2022-09-23 Thread Mingyu Chen
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

Re:failed to find 1 backends for pilicy

2022-09-23 Thread Mingyu Chen
Could you provide any details? -- 此致!Best Regards 陈明雨 Mingyu Chen Email: morning...@apache.org At 2022-09-22 17:11:21, "Boot" <331233...@qq.com.INVALID> wrote: >hi , >    I meet the error when I create olap table ,I do not know HOw to >deal with .could you help me? thanks