Doris版本:2.1.8
create materialized view http_test_view as
select timestamp_min, project, uri, ip,avg(duration),max(duration)
from http_test group by timestamp_min, project, uri, ip;
我创建了上述的物化视图,其中duration字段类型为DECIMAL(18,3)。
然后我sql中查询max(duration)可以匹配物化视图,但是查询avg(duration)无法匹配物化视图。是哪里有问题吗?