同步视图,没有命中

Viewed 32

show alter table materialized view from

用的官网给的一模一样的例子

3 Answers

本地跑是正常的:image.png

确认下优化器相关参数是否有变更:
SHOW VARIABLES like '%nereids%'

image.png

create table sales_records
(
record_id int,
seller_id int,
store_id int,
sale_date date,
sale_amt bigint
)
distributed by hash(record_id)
properties("replication_num" = "1");

-- 插入数据
insert into sales_records values(1,1,1,'2020-02-02',1);

create materialized view store_amt as
select store_id, sum(sale_amt) from sales_records group by store_id;

desc sales_records all;
show alter table materialized view from test_db;

explain select store_id, sum(sale_amt) from sales_records group by store_id;

我在我本地测试了下,使用的版本是doris-3.0.3-rc04-62a58bff4c,能够命中,方便留下联系方式嘛?可以一起在线看看