StarRocks / starrocks

The world's fastest open query engine for sub-second analytics both on and off the data lakehouse. With the flexibility to support nearly any scenario, StarRocks provides best-in-class performance for multi-dimensional analytics, real-time analytics, and ad-hoc queries. A Linux Foundation project.
https://starrocks.io
Apache License 2.0
9.26k stars 1.84k forks source link

excluded_trigger_tables and excluded_trigger_tables did not suport mv refresh time #53389

Open bulolo opened 1 day ago

bulolo commented 1 day ago

3.3.6

CREATE MATERIALIZED VIEW dwd_order_mv
REFRESH ASYNC START('2024-10-01 10:00:00') EVERY(INTERVAL 10 MINUTE) 
PARTITION BY date_trunc('day', created)
PROPERTIES(
    "partition_refresh_number" = "30",
        "excluded_trigger_tables" = "dict_mv",
        "excluded_refresh_tables" = "dict_mv"
)
as 
SELECT o.*, d.* FROM ods_order o left join dict_mv d on XXX

so i confused ,is excluded_trigger_tables and excluded_refresh_tables support mv or is a bug?

i write it on https://junyao.tech/posts/ee5c2ad.html

bulolo commented 1 day ago

3.3.6异步物化视图疑问1

经过测试数据验证 https://junyao.tech/posts/ee5c2ad.html

物化视图定时刷新存在分区刷新问题

bulolo commented 1 day ago

3.3.6异步物化视图疑问2

excluded_trigger_tablesexcluded_refresh_tables 支持 物化视图吗?还是一定要是个table? 我自己验证过 excluded_trigger_tables和excluded_refresh_tables不支持mv,想确认一下是否支持?

CREATE MATERIALIZED VIEW dwd_order_mv
REFRESH ASYNC START('2024-10-01 10:00:00') EVERY(INTERVAL 10 MINUTE) 
PARTITION BY date_trunc('day', created)
PROPERTIES(
    "partition_refresh_number" = "30",
        "excluded_trigger_tables" = "dict_mv",
        "excluded_refresh_tables" = "dict_mv"
)
as 
SELECT o.*, d.* FROM ods_order o left join dict_mv d on XXX

如上语句 excluded_trigger_tables 和 excluded_refresh_tables 填写的是一个mv,而非table,会生效吗?