mysqldump: Couldn't execute 'show create table xdr_source_ct_alarm': errCode = 2, detailMessage = not support async materialized view, please use show create materialized view (1105)
mysqldump导出库的表结构会报物化视图不支持的问题，怎么解决
Viewed 19
1 Answers
mysqldump 内部使用 SHOW CREATE TABLE 来获取 DDL，Doris async materialized view 是 SHOW CREATE MATERIALIZED VIEW ，所以不支持。
写一个脚本用 SHOW CREATE MATERIALIZED VIEW 取一下就行。
Related Questions
使用doris物化视图做数仓分层，哪种策略好
1 answers
在doris 3.1.4 版本通过pycharm64登录，建异步物化视图报错，[S1009] Statement,executeQuery( cannot issue statements that do not produce result sets.
1 answers
mysqldump导出库的表结构会报物化视图不支持的问题，怎么解决
1 answers
集群涉及到物理视图的元信息出现异常 doris4.0.6-rs02
2 answers
materialized（MATERIALIZED）大小写是否有区别
1 answers
物化视图刷新时区突然不生效问题
1 answers