异步物化视图是否支持paimon catalog?
另外 物化视图 是否可以写入到external catalog里呢?
异步物化视图是否支持paimon catalog?
另外 物化视图 是否可以写入到external catalog里呢?
物化视图对paimon catalog 的支持
感谢 感谢 我这创建物化视图报了个错误 麻烦帮忙看下
背景:paimon连接正常,use paimon.database_name,select可以正常查询
CREATE MATERIALIZED VIEW view_name_0 REFRESH MANUAL PARTITION BY str2date(stat_date, ‘yyyyMMdd’) AS SELECT stat_date,count(visitor_id) from table_name GROUP BY stat_date;
报错 ERROR 1064 (HY000): Getting analyzing error at line 1, column 26. Detail message: Can not find database:database_name.
use paimon.database_name;
CREATE MATERIALIZED VIEW default_catalog.database_name.view_name_0 REFRESH MANUAL PARTITION BY str2date(stat_date, ‘yyyyMMdd’) AS SELECT stat_date,count(visitor_id) from table_name GROUP BY stat_date;
可以试试这样