异步物化视图不能透明改写

Viewed 14

doris版本: 3.0.6/3.1.1

创建 paimon catalog paimon_s3_dh;
创建物化视图:
create materialized view mv_dwd_agg_3 BUILD IMMEDIATE REFRESH COMPLETE ON SCHEDULE EVERY 1 hour as select id,sum(a) as a from paimon_s3_dh.test.dwd_15m group by id;

设置外部透明改写参数:
SET materialized_view_rewrite_enable_contain_external_table = true;
查询计划中没有任何物化视图相关信息:
explain select id,sum(a) as a from paimon_s3_dh.test.dwd_15m group by id;

物化视图状态:
image.png
image.png

2 Answers

SelectDB Studio 和 内置的web页面 设置session级别的参数有问题

SET materialized_view_rewrite_enable_contain_external_table = true;
没有生效,设置完成之后结果还是false

show variables like 'materialized_view_rewrite%'
image.png

试了下设置其他参数也不能生效