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
EXPLAIN
Last updated: 2024-08-07 17:21:18
Description
Supported engines: Presto and SparkSQL
Applicable table: Native and external tables
Purpose: Display logical or physical plan for executing SQL statements.
Statement
Presto
EXPLAIN [ ( option [, ...] ) ] statement-- where option can be one of:-- FORMAT { TEXT | GRAPHVIZ | JSON }-- TYPE { LOGICAL | DISTRIBUTED | VALIDATE | IO }
SparkSQL
EXPLAIN [ EXTENDED | CODEGEN | COST | FORMATTED ] statementEXPLAIN ANALYZEEXPLAIN ANALYZE [VERBOSE] statement
Example
-- prestoEXPLAIN (TYPE VALIDATE) SELECT regionkey, count(*) FROM nation GROUP BY 1;EXPLAIN (TYPE IO, FORMAT JSON) INSERT INTO test_nation SELECT * FROM nation WHERE regionkey = 2;-- EXPLAIN ANALYZEEXPLAIN ANALYZE SELECT count(*), clerk FROM orders WHERE orderdate > date '1995-01-01' GROUP BY clerk;EXPLAIN ANALYZE VERBOSE SELECT count(clerk) OVER() FROM orders WHERE orderdate > date '1995-01-01';
Was this page helpful?
You can also Contact Sales or Submit a Ticket for help.
Yes
No