Help Center/ Data Lake Insight/ SQL Syntax Reference (To Be Offline)/ Spark SQL Syntax Reference (Unavailable Soon)/ Viewing the Execution Plan
Updated on 2024-02-07 GMT+08:00
View PDF
Share

Viewing the Execution Plan

Function

This statement returns the logical plan and physical execution plan for the SQL statement.

Syntax

1
 
EXPLAIN [EXTENDED | CODEGEN] statement;

Keywords

EXTENDED: After this keyword is specified, the logical and physical plans are outputted at the same time.

CODEGEN: After this keyword is specified, code generated by using the Codegen is also outputted.

Precautions

None

Example

To return the logical and physical plans of SELECT * FROM test, run the following statement:

1
 
EXPLAIN EXTENDED select * from test;