文档首页/
MapReduce服务 MRS/
组件操作指南（LTS版）/
使用HetuEngine/
HetuEngine常见SQL语法说明/
HetuEngine DDL SQL语法说明/
SHOW CREATE MATERIALIZED VIEW
更新时间：2024-07-02 GMT+08:00
SHOW CREATE MATERIALIZED VIEW
语法
SHOW CREATE MATERIALIZED VIEW materialized_view_name
描述
显示用于创建物化视图的SQL语句。
示例
显示创建物化视图的SQL语句。
hetuengine:tpcds_2gb> show create materialized view mv.tpcds.test;
Create Materialized View
---------------------------------------------------
CREATE MATERIALIZED VIEW mv.tpcds.test ( c1, id )
WITH (
storage_table = 'mppdb.tpcds.test'
) AS
SELECT
c1
, id
FROM
t1
WHERE (id < 7)
