SHOW CREATE MATERIALIZED VIEW

SHOW CREATE MATERIALIZED VIEW 显示特定异步物化视图的定义。

提示

此操作不需要任何权限。

语法

SHOW CREATE MATERIALIZED VIEW [database.]<mv_name>

中括号 [] 中的参数是可选的。

参数

参数	必需	描述
mv_name	是	要显示的物化视图的名称。

返回值

返回	描述
物化视图	物化视图的名称。
Create Materialized View	物化视图的定义。

示例

示例 1：显示特定物化视图的定义

MySQL > SHOW CREATE MATERIALIZED VIEW lo_mv1\G
*************************** 1. row ***************************
       Materialized View: lo_mv1
Create Materialized View: CREATE MATERIALIZED VIEW `lo_mv1`
COMMENT "MATERIALIZED_VIEW"
DISTRIBUTED BY HASH(`lo_orderkey`) 
REFRESH ASYNC
PROPERTIES (
"replication_num" = "3",
"storage_medium" = "HDD"
)
AS SELECT `wlc_test`.`lineorder`.`lo_orderkey` AS `lo_orderkey`, `wlc_test`.`lineorder`.`lo_custkey` AS `lo_custkey`, sum(`wlc_test`.`lineorder`.`lo_quantity`) AS `total_quantity`, sum(`wlc_test`.`lineorder`.`lo_revenue`) AS `total_revenue`, count(`wlc_test`.`lineorder`.`lo_shipmode`) AS `shipmode_count` FROM `wlc_test`.`lineorder` GROUP BY `wlc_test`.`lineorder`.`lo_orderkey`, `wlc_test`.`lineorder`.`lo_custkey` ORDER BY `wlc_test`.`lineorder`.`lo_orderkey` ASC ;
1 row in set (0.01 sec)