paimon外表catalog没法创建异步物化视图 Only support creating asynchronous materialized views in internal catalog

Viewed 10

image.png
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;
1 Answers

已解决。
在 internal catalog 内创建物化视图读外表catalog的数据。

CREATE MATERIALIZED VIEW IF NOT EXISTS internal.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;