doris版本3.1.1
paimon版本1.1.1
CREATE MATERIALIZED VIEW IF NOT EXISTS paimon.test_db.tmp
BUILD IMMEDIATE
REFRESH AUTO ON
SCHEDULE EVERY 10 hour
AS
select
rn,
space_id,
max(status_rate) status_rate
from
paimon.test_db.tmp
group by
rn,
space_id;
doris版本3.1.1
paimon版本1.1.1
CREATE MATERIALIZED VIEW IF NOT EXISTS paimon.test_db.tmp
BUILD IMMEDIATE
REFRESH AUTO ON
SCHEDULE EVERY 10 hour
AS
select
rn,
space_id,
max(status_rate) status_rate
from
paimon.test_db.tmp
group by
rn,
space_id;