Re: [PROPOSAL] Materialized view 2.0

2020-04-17 Thread ling miao
If we want to support the expr of key, the different load plan will be need between base and rollup. The key of rollup needs to be transformed by the to_mouth function before the storage engine aggregate the value column. >From the perspective of demand, users only need to be able to store day, mo

Re: Re: [PROPOSAL] Materialized view 2.0

2020-04-17 Thread ling miao
If expressions are supported, the storage engine will changed when the function column is built automatically. Also the mv selector need a expression calculation tool to judge whether mv could be selected for query. After Doris support the count_distinct and count, I will consider this feature. 陈

Re: [PROPOSAL] Materialized view 2.0

2020-04-16 Thread Zhao Chun
Hi Ling Very glad to see this proposal. We can discuss whether to support expression operations. For the case that expressions are applied on the KEY column. For example we can easily get a monthly table through a rollup which is defined by "group by to_month(day_column)". For the case that exp