Data Lake Compute
- Getting Started
- Operation Guide
- Console Operation Introduction
- Data Development and Exploration
- Data Exploration
- Data Query Task
- Resource Management
- Engine Management
- SuperSQL Engine
- Standard Engine
- Resource Group
- Private Connection
- Storage Configuration
- Ops Management
- Insight Management
- System Management
- User and Permission Management
- Monitoring and Alarms
- Development Guide
- System Restraints
- Client Access
- JDBC Access
- Practical Tutorial
- SQL Statement
- SuperSQL Statement
- Unified Statement
- DDL Statement
- ALTER TABLE
- DML Statement
- DQL Statement
- Iceberg Table Statement
- API Documentation
- Making API Requests
- Data Table APIs
- Task APIs
- Metadata APIs
- Service Configuration APIs
- Permission Management APIs
- Data Source Connection APIs
- Data Optimization APIs
- Data Engine APIs
- General Reference
- Operation Guide on Connecting Third-Party Software to DLC
Materialized View Statement
Last updated: 2025-03-05 16:04:34
Description:
The following statement for materialized views is supported only by Presto and SparkSQL engines. For detailed usage instructions, see the Materialized View documentation.
CREATE MATERIALIZED
Create a materialized view:
CREATE MATERIALIZED VIEW [IF NOT EXISTS] mv_identifier[ENABLE | DISABLE REWRITE][COMMENT mv_comment][WITH META LINK][TBLPROPERTIES (key1=value1, key2=value2,...)][AS] select_query
DROP MATERIALIZED
Delete a materialized view:
DROP MATERIALIZED VIEW [IF EXISTS] mv_identifier
DESCRIBE MATERIALIZED
Describe a materialized view:
[DESCRIBE | DESC] MATERIALIZED VIEW mv_identifier
REFRESH MATERIALIZED
Refresh a materialized view:
REFRESH MATERIALIZED VIEW mv_identifier
SHOW MATERIALIZED VIEW JOBS
Display the execution task list of materialized views, providing insights into the refresh history and status of the materialized view.
SHOW MATERIALIZED VIEW JOBS IN mv_identifier
Was this page helpful?
You can also Contact Sales or Submit a Ticket for help.
Yes
No