SHOW CREATE MATERIALIZED VIEW

Description

Shows the definition of a specific asynchronous materialized view.

tip

This operation does not require privileges.

Syntax

SHOW CREATE MATERIALIZED VIEW [database.]<mv_name>

Parameters in brackets [] is optional.

Parameters

Parameter	Required	Description
mv_name	yes	The name of the materialized view to show.

Returns

Return	Description
Materialized View	The name of the materialized view.
Create Materialized View	The definition of the materialized view.

Examples

Example 1: Show the definition of a specific materialized view

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)