Help Center/ MapReduce Service/ Component Operation Guide (LTS)/ Using HetuEngine/ Common HetuEngine SQL Syntax/ HetuEngine DDL SQL Syntax/ SHOW CREATE MATERIALIZED VIEW
Updated on 2025-03-17 GMT+08:00
SHOW CREATE MATERIALIZED VIEW
Syntax
SHOW CREATE MATERIALIZED VIEW materialized_view_name
Description
This statement is used to display the SQL statements that can be used to create a materialized view.
Example
Displays the SQL statements for creating the materialized view.
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) Parent topic: HetuEngine DDL SQL Syntax
What is your overall rating for this page?
0
1
2
3
4
5
6
7
8
9
10
Very dissatisfiedVery satisfied
Thank you very much for your feedback. We will continue working to improve the documentation.
The system is busy. Please try again later.
