maropu commented on a change in pull request #26970: [SPARK-28825][SQL][DOC]
Documentation for Explain Command
URL: https://github.com/apache/spark/pull/26970#discussion_r361433239
##########
File path: docs/sql-ref-syntax-qry-explain.md
##########
@@ -19,4 +19,126 @@ license: |
limitations under the License.
---
-**This page is under construction**
+### Description
+
+The `EXPLAIN` statement provides the execution plan for the statement.
+By default, `EXPLAIN` provides information about the physical plan.
+`EXPLAIN` does not support `DESCRIBE TABLE` statement.
+
+
+### Syntax
+{% highlight sql %}
+EXPLAIN [EXTENDED | CODEGEN | COST | FORMATTED] statement
+{% endhighlight %}
+
+### Parameters
+
+<dl>
+ <dt><code><em>EXTENDED</em></code></dt>
+ <dd>Generates Parsed Logical Plan, Analyzed Logical Plan, Optimized Logical
Plan and Physical Plan.
+ Parsed Logical plan is a unresolved plan that extracted from the query.
+ Analyzed logical plans transforms which translates UnresolvedAttribute and
UnresolvedRelation into fully typed objects.
+ The optimized logical plan transforms through a set of optimization rules,
resulting in the Physical plan.
+ </dd>
+</dl>
+
+<dl>
+ <dt><code><em>CODEGEN</em></code></dt>
+ <dd>Generates code for the statement, if any and a Physical Plan.</dd>
+</dl>
+
+<dl>
+ <dt><code><em>COST</em></code></dt>
+ <dd>If plan node statistics are available, generates a logical plan and the
statistics.</dd>
+</dl>
+
+<dl>
+ <dt><code><em>FORMATTED</em></code></dt>
+ <dd>Generates two sections: a physical plan outline and node details.</dd>
+</dl>
Review comment:
How about just `Specifies a SQL statement to be explained.`
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
[email protected]
With regards,
Apache Git Services
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
