starrocks基于paimon构建异步物化视图

CREATE MATERIALIZED VIEW mv_users_by_date
REFRESH ASYNC EVERY(INTERVAL 30 MINUTE)
PROPERTIES ("replication_num" = "1")
AS
SELECT
    registration_date,
    COUNT(*) AS user_count,
    COUNT(email) AS email_filled_count
FROM `paimon_minio_catalog`.`default`.`users1`
GROUP BY registration_date;

-- 查看 MV 状态
SHOW MATERIALIZED VIEWS LIKE 'mv_users_by_date';

-- 手动刷新（可选）
REFRESH MATERIALIZED VIEW mv_users_by_date;

-- 查询结果
SELECT * FROM mv_users_by_date;

集群只有1个backend节点，显式指定 replication_num = 1