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 5
1 Answers
mysqldump 内部使用 SHOW CREATE TABLE 来获取 DDL，Doris async materialized view 是 SHOW CREATE MATERIALIZED VIEW ，所以不支持。
写一个脚本用 SHOW CREATE MATERIALIZED VIEW 取一下就行。
