You are viewing a plain text version of this content. The canonical link for it is here.
Posted to reviews@spark.apache.org by GitBox <gi...@apache.org> on 2019/12/20 15:54:34 UTC

[GitHub] [spark] PavithraRamachandran opened a new pull request #26970: [SPARK-28825][SQL][DOC] Documentation for Explain Command

PavithraRamachandran opened a new pull request #26970: [SPARK-28825][SQL][DOC] Documentation for Explain Command
URL: https://github.com/apache/spark/pull/26970
 
 
   What changes were proposed in this pull request?
   Document Explain statement in SQL Reference Guide.
   
   Why are the changes needed?
   Adding documentation for SQL reference.
   
   Does this PR introduce any user-facing change?
   yes
   
   Before:
   There was no documentation for this.
   After:
   ![image (15)](https://user-images.githubusercontent.com/51401130/71266718-fdd21600-236e-11ea-801d-698fbcdc2e71.png)
   ![image (14)](https://user-images.githubusercontent.com/51401130/71266720-fe6aac80-236e-11ea-86e9-777a594c9004.png)
   ![image (13)](https://user-images.githubusercontent.com/51401130/71266721-fe6aac80-236e-11ea-9454-65fbfc70c455.png)
   ![image (12)](https://user-images.githubusercontent.com/51401130/71266722-fe6aac80-236e-11ea-84e3-1a2431228b23.png)
   ![image (11)](https://user-images.githubusercontent.com/51401130/71266724-ff034300-236e-11ea-9095-e5e0115c5d75.png)
   
   How was this patch tested?
   Used jekyll build and serve to verify.
   
   
   
   

----------------------------------------------------------------
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:
users@infra.apache.org


With regards,
Apache Git Services

---------------------------------------------------------------------
To unsubscribe, e-mail: reviews-unsubscribe@spark.apache.org
For additional commands, e-mail: reviews-help@spark.apache.org

[GitHub] [spark] maropu commented on a change in pull request #26970: [SPARK-28825][SQL][DOC] Documentation for Explain Command

Posted by GitBox <gi...@apache.org>.
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_r361027978
 
 

 ##########
 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.
 
 Review comment:
   What does this statement mean? We can accept `EXPLAIN DESCRIBE TABLE`;
   ```
   scala> sql("explain describe table gstest_empty").show(1, false)
   +---------------------------------------------------------------------------------------------------+
   |plan                                                                                               |
   +---------------------------------------------------------------------------------------------------+
   |== Physical Plan ==
   Execute DescribeTableCommand
      +- DescribeTableCommand `gstest_empty`, false
   
   |
   +---------------------------------------------------------------------------------------------------+
   ```

----------------------------------------------------------------
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:
users@infra.apache.org


With regards,
Apache Git Services

---------------------------------------------------------------------
To unsubscribe, e-mail: reviews-unsubscribe@spark.apache.org
For additional commands, e-mail: reviews-help@spark.apache.org

[GitHub] [spark] maropu commented on a change in pull request #26970: [SPARK-28825][SQL][DOC] Documentation for Explain Command

Posted by GitBox <gi...@apache.org>.
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_r361028462
 
 

 ##########
 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.
 
 Review comment:
   nit: By default, this clause provides information about a physical plan only.

----------------------------------------------------------------
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:
users@infra.apache.org


With regards,
Apache Git Services

---------------------------------------------------------------------
To unsubscribe, e-mail: reviews-unsubscribe@spark.apache.org
For additional commands, e-mail: reviews-help@spark.apache.org

[GitHub] [spark] maropu commented on issue #26970: [SPARK-28825][SQL][DOC] Documentation for Explain Command

Posted by GitBox <gi...@apache.org>.
maropu commented on issue #26970: [SPARK-28825][SQL][DOC] Documentation for Explain Command
URL: https://github.com/apache/spark/pull/26970#issuecomment-571830062
 
 
   ok to test

----------------------------------------------------------------
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:
users@infra.apache.org


With regards,
Apache Git Services

---------------------------------------------------------------------
To unsubscribe, e-mail: reviews-unsubscribe@spark.apache.org
For additional commands, e-mail: reviews-help@spark.apache.org

[GitHub] [spark] maropu commented on issue #26970: [SPARK-28825][SQL][DOC] Documentation for Explain Command

Posted by GitBox <gi...@apache.org>.
maropu commented on issue #26970: [SPARK-28825][SQL][DOC] Documentation for Explain Command
URL: https://github.com/apache/spark/pull/26970#issuecomment-568811723
 
 
   Can you update the screenshot in the PR description, too?

----------------------------------------------------------------
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:
users@infra.apache.org


With regards,
Apache Git Services

---------------------------------------------------------------------
To unsubscribe, e-mail: reviews-unsubscribe@spark.apache.org
For additional commands, e-mail: reviews-help@spark.apache.org

[GitHub] [spark] srowen commented on a change in pull request #26970: [SPARK-28825][SQL][DOC] Documentation for Explain Command

Posted by GitBox <gi...@apache.org>.
srowen 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_r360711555
 
 

 ##########
 File path: docs/sql-ref-syntax-qry-explain.md
 ##########
 @@ -19,4 +19,157 @@ 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.
 
 Review comment:
   Back-tick `DESCRIBE TABLE`.
   -> does not support _the_ ...
   

----------------------------------------------------------------
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:
users@infra.apache.org


With regards,
Apache Git Services

---------------------------------------------------------------------
To unsubscribe, e-mail: reviews-unsubscribe@spark.apache.org
For additional commands, e-mail: reviews-help@spark.apache.org

[GitHub] [spark] AmplabJenkins commented on issue #26970: [SPARK-28825][SQL][DOC] Documentation for Explain Command

Posted by GitBox <gi...@apache.org>.
AmplabJenkins commented on issue #26970: [SPARK-28825][SQL][DOC] Documentation for Explain Command
URL: https://github.com/apache/spark/pull/26970#issuecomment-567980153
 
 
   Can one of the admins verify this patch?

----------------------------------------------------------------
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:
users@infra.apache.org


With regards,
Apache Git Services

---------------------------------------------------------------------
To unsubscribe, e-mail: reviews-unsubscribe@spark.apache.org
For additional commands, e-mail: reviews-help@spark.apache.org

[GitHub] [spark] maropu commented on a change in pull request #26970: [SPARK-28825][SQL][DOC] Documentation for Explain Command

Posted by GitBox <gi...@apache.org>.
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:
users@infra.apache.org


With regards,
Apache Git Services

---------------------------------------------------------------------
To unsubscribe, e-mail: reviews-unsubscribe@spark.apache.org
For additional commands, e-mail: reviews-help@spark.apache.org

[GitHub] [spark] AmplabJenkins commented on issue #26970: [SPARK-28825][SQL][DOC] Documentation for Explain Command

Posted by GitBox <gi...@apache.org>.
AmplabJenkins commented on issue #26970: [SPARK-28825][SQL][DOC] Documentation for Explain Command
URL: https://github.com/apache/spark/pull/26970#issuecomment-571831353
 
 
   Merged build finished. Test PASSed.

----------------------------------------------------------------
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:
users@infra.apache.org


With regards,
Apache Git Services

---------------------------------------------------------------------
To unsubscribe, e-mail: reviews-unsubscribe@spark.apache.org
For additional commands, e-mail: reviews-help@spark.apache.org

[GitHub] [spark] maropu commented on issue #26970: [SPARK-28825][SQL][DOC] Documentation for Explain Command

Posted by GitBox <gi...@apache.org>.
maropu commented on issue #26970: [SPARK-28825][SQL][DOC] Documentation for Explain Command
URL: https://github.com/apache/spark/pull/26970#issuecomment-571834484
 
 
   Thanks! Merged to master.

----------------------------------------------------------------
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:
users@infra.apache.org


With regards,
Apache Git Services

---------------------------------------------------------------------
To unsubscribe, e-mail: reviews-unsubscribe@spark.apache.org
For additional commands, e-mail: reviews-help@spark.apache.org

[GitHub] [spark] SparkQA commented on issue #26970: [SPARK-28825][SQL][DOC] Documentation for Explain Command

Posted by GitBox <gi...@apache.org>.
SparkQA commented on issue #26970: [SPARK-28825][SQL][DOC] Documentation for Explain Command
URL: https://github.com/apache/spark/pull/26970#issuecomment-571833782
 
 
   **[Test build #116268 has finished](https://amplab.cs.berkeley.edu/jenkins/job/SparkPullRequestBuilder/116268/testReport)** for PR 26970 at commit [`4d0867f`](https://github.com/apache/spark/commit/4d0867fd9acb6a5305940dc5a0fecaf236c4bc0d).
    * This patch passes all tests.
    * This patch merges cleanly.
    * This patch adds no public classes.

----------------------------------------------------------------
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:
users@infra.apache.org


With regards,
Apache Git Services

---------------------------------------------------------------------
To unsubscribe, e-mail: reviews-unsubscribe@spark.apache.org
For additional commands, e-mail: reviews-help@spark.apache.org

[GitHub] [spark] maropu commented on a change in pull request #26970: [SPARK-28825][SQL][DOC] Documentation for Explain Command

Posted by GitBox <gi...@apache.org>.
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_r361028946
 
 

 ##########
 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:
   Where's a description about `input_statement`? See: https://github.com/apache/spark/blob/master/docs/sql-ref-syntax-aux-describe-query.md#parameters

----------------------------------------------------------------
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:
users@infra.apache.org


With regards,
Apache Git Services

---------------------------------------------------------------------
To unsubscribe, e-mail: reviews-unsubscribe@spark.apache.org
For additional commands, e-mail: reviews-help@spark.apache.org

[GitHub] [spark] PavithraRamachandran commented on a change in pull request #26970: [SPARK-28825][SQL][DOC] Documentation for Explain Command

Posted by GitBox <gi...@apache.org>.
PavithraRamachandran 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_r361432158
 
 

 ##########
 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:
   @maropu  i have written a generalised explanation for statement, as i could be any SQL query, Listing may not be feasible. Could you review if the below explanation is ok?

----------------------------------------------------------------
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:
users@infra.apache.org


With regards,
Apache Git Services

---------------------------------------------------------------------
To unsubscribe, e-mail: reviews-unsubscribe@spark.apache.org
For additional commands, e-mail: reviews-help@spark.apache.org

[GitHub] [spark] maropu commented on a change in pull request #26970: [SPARK-28825][SQL][DOC] Documentation for Explain Command

Posted by GitBox <gi...@apache.org>.
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_r360735963
 
 

 ##########
 File path: docs/sql-ref-syntax-qry-explain.md
 ##########
 @@ -19,4 +19,157 @@ 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] 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.</dd>
+</dl> 
+
+<dl>
+  <dt><code><em>CODEGEN</em></code></dt>
+  <dd>Generates code for the statement, if any.</dd>
+</dl>
+
+### Examples
+{% highlight sql %}
+
+--Using Extended
+
+EXPLAIN EXTENDED select * from emp;
++----------------------------------------------------+
+|                        plan                        |
++----------------------------------------------------+
+| == Parsed Logical Plan ==
+'Project [*]
++- 'UnresolvedRelation [emp]
+
+== Analyzed Logical Plan ==
+id: int
+Project [id#0]
++- SubqueryAlias `default`.`emp`
+   +- Relation[id#0] parquet
+
+== Optimized Logical Plan ==
+Relation[id#0] parquet
+
+== Physical Plan ==
+*(1) ColumnarToRow
++- FileScan parquet default.emp[id#0] Batched: true, DataFilters: [], Format: Parquet, Location: InMemoryFileIndex[file:/home/root1/Spark/spark/spark-warehouse/emp], PartitionFilters: [], PushedFilters: [], ReadSchema: struct<id:int>
+ |
++----------------------------------------------------+
+
+--Default Output
+
+EXPLAIN select * from emp;
++----------------------------------------------------+
+|                        plan                        |
++----------------------------------------------------+
+| == Physical Plan ==
+*(1) ColumnarToRow
++- FileScan parquet default.emp[id#0] Batched: true, DataFilters: [], Format: Parquet, Location: InMemoryFileIndex[file:/home/root1/Spark/spark/spark-warehouse/emp], PartitionFilters: [], PushedFilters: [], ReadSchema: struct<id:int>
+
+ |
++----------------------------------------------------+
+
+
+-- Using CODEGEN
+
+EXPLAIN CODEGEN select * from emp;
++----------------------------------------------------+
+|                        plan                        |
++----------------------------------------------------+
+| Found 1 WholeStageCodegen subtrees.
+== Subtree 1 / 1 (maxMethodCodeSize:192; maxConstantPoolSize:127(0.19% used); numInnerClasses:0) ==
+*(1) ColumnarToRow
++- FileScan parquet default.emp[id#0] Batched: true, DataFilters: [], Format: Parquet, Location: InMemoryFileIndex[file:/home/root1/Spark/spark/spark-warehouse/emp], PartitionFilters: [], PushedFilters: [], ReadSchema: struct<id:int>
+
+Generated code:
 
 Review comment:
   This description looks verbose to me and the codegen mode is mainly for advanced users. So, I think its less worth printing this and the other examples (e.g., `EXTENDED` and `FORMATTED`) are enough for documents. WDYT?

----------------------------------------------------------------
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:
users@infra.apache.org


With regards,
Apache Git Services

---------------------------------------------------------------------
To unsubscribe, e-mail: reviews-unsubscribe@spark.apache.org
For additional commands, e-mail: reviews-help@spark.apache.org

[GitHub] [spark] AmplabJenkins removed a comment on issue #26970: [SPARK-28825][SQL][DOC] Documentation for Explain Command

Posted by GitBox <gi...@apache.org>.
AmplabJenkins removed a comment on issue #26970: [SPARK-28825][SQL][DOC] Documentation for Explain Command
URL: https://github.com/apache/spark/pull/26970#issuecomment-571833889
 
 
   Test PASSed.
   Refer to this link for build results (access rights to CI server needed): 
   https://amplab.cs.berkeley.edu/jenkins//job/SparkPullRequestBuilder/116268/
   Test PASSed.

----------------------------------------------------------------
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:
users@infra.apache.org


With regards,
Apache Git Services

---------------------------------------------------------------------
To unsubscribe, e-mail: reviews-unsubscribe@spark.apache.org
For additional commands, e-mail: reviews-help@spark.apache.org

[GitHub] [spark] PavithraRamachandran commented on issue #26970: [SPARK-28825][SQL][DOC] Documentation for Explain Command

Posted by GitBox <gi...@apache.org>.
PavithraRamachandran commented on issue #26970: [SPARK-28825][SQL][DOC] Documentation for Explain Command
URL: https://github.com/apache/spark/pull/26970#issuecomment-570153537
 
 
   @srowen @maropu i have updated the screenshot

----------------------------------------------------------------
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:
users@infra.apache.org


With regards,
Apache Git Services

---------------------------------------------------------------------
To unsubscribe, e-mail: reviews-unsubscribe@spark.apache.org
For additional commands, e-mail: reviews-help@spark.apache.org

[GitHub] [spark] AmplabJenkins commented on issue #26970: [SPARK-28825][SQL][DOC] Documentation for Explain Command

Posted by GitBox <gi...@apache.org>.
AmplabJenkins commented on issue #26970: [SPARK-28825][SQL][DOC] Documentation for Explain Command
URL: https://github.com/apache/spark/pull/26970#issuecomment-571833880
 
 
   Merged build finished. Test PASSed.

----------------------------------------------------------------
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:
users@infra.apache.org


With regards,
Apache Git Services

---------------------------------------------------------------------
To unsubscribe, e-mail: reviews-unsubscribe@spark.apache.org
For additional commands, e-mail: reviews-help@spark.apache.org

[GitHub] [spark] HyukjinKwon commented on a change in pull request #26970: [SPARK-28825][SQL][DOC] Documentation for Explain Command

Posted by GitBox <gi...@apache.org>.
HyukjinKwon 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_r360743650
 
 

 ##########
 File path: docs/sql-ref-syntax-qry-explain.md
 ##########
 @@ -19,4 +19,157 @@ 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] 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.</dd>
+</dl> 
+
+<dl>
+  <dt><code><em>CODEGEN</em></code></dt>
+  <dd>Generates code for the statement, if any.</dd>
+</dl>
+
+### Examples
+{% highlight sql %}
+
+--Using Extended
+
+EXPLAIN EXTENDED select * from emp;
++----------------------------------------------------+
+|                        plan                        |
++----------------------------------------------------+
+| == Parsed Logical Plan ==
+'Project [*]
++- 'UnresolvedRelation [emp]
+
+== Analyzed Logical Plan ==
+id: int
+Project [id#0]
++- SubqueryAlias `default`.`emp`
+   +- Relation[id#0] parquet
+
+== Optimized Logical Plan ==
+Relation[id#0] parquet
+
+== Physical Plan ==
+*(1) ColumnarToRow
++- FileScan parquet default.emp[id#0] Batched: true, DataFilters: [], Format: Parquet, Location: InMemoryFileIndex[file:/home/root1/Spark/spark/spark-warehouse/emp], PartitionFilters: [], PushedFilters: [], ReadSchema: struct<id:int>
+ |
++----------------------------------------------------+
+
+--Default Output
+
+EXPLAIN select * from emp;
++----------------------------------------------------+
+|                        plan                        |
++----------------------------------------------------+
+| == Physical Plan ==
+*(1) ColumnarToRow
++- FileScan parquet default.emp[id#0] Batched: true, DataFilters: [], Format: Parquet, Location: InMemoryFileIndex[file:/home/root1/Spark/spark/spark-warehouse/emp], PartitionFilters: [], PushedFilters: [], ReadSchema: struct<id:int>
+
+ |
++----------------------------------------------------+
+
+
+-- Using CODEGEN
+
+EXPLAIN CODEGEN select * from emp;
++----------------------------------------------------+
+|                        plan                        |
++----------------------------------------------------+
+| Found 1 WholeStageCodegen subtrees.
+== Subtree 1 / 1 (maxMethodCodeSize:192; maxConstantPoolSize:127(0.19% used); numInnerClasses:0) ==
+*(1) ColumnarToRow
++- FileScan parquet default.emp[id#0] Batched: true, DataFilters: [], Format: Parquet, Location: InMemoryFileIndex[file:/home/root1/Spark/spark/spark-warehouse/emp], PartitionFilters: [], PushedFilters: [], ReadSchema: struct<id:int>
+
+Generated code:
 
 Review comment:
   Yeah, I don't think we should write down generated codes in the docs too. +1 for @maropu's advice. We can just show a couple of simple examples and that's it.

----------------------------------------------------------------
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:
users@infra.apache.org


With regards,
Apache Git Services

---------------------------------------------------------------------
To unsubscribe, e-mail: reviews-unsubscribe@spark.apache.org
For additional commands, e-mail: reviews-help@spark.apache.org

[GitHub] [spark] HyukjinKwon commented on a change in pull request #26970: [SPARK-28825][SQL][DOC] Documentation for Explain Command

Posted by GitBox <gi...@apache.org>.
HyukjinKwon 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_r360743754
 
 

 ##########
 File path: docs/sql-ref-syntax-qry-explain.md
 ##########
 @@ -19,4 +19,157 @@ 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] 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.</dd>
+</dl> 
+
+<dl>
+  <dt><code><em>CODEGEN</em></code></dt>
+  <dd>Generates code for the statement, if any.</dd>
 
 Review comment:
   You can also refer the documentations at https://github.com/apache/spark/blob/master/sql/core/src/main/scala/org/apache/spark/sql/execution/ExplainMode.scala#L29-L57

----------------------------------------------------------------
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:
users@infra.apache.org


With regards,
Apache Git Services

---------------------------------------------------------------------
To unsubscribe, e-mail: reviews-unsubscribe@spark.apache.org
For additional commands, e-mail: reviews-help@spark.apache.org

[GitHub] [spark] srowen commented on issue #26970: [SPARK-28825][SQL][DOC] Documentation for Explain Command

Posted by GitBox <gi...@apache.org>.
srowen commented on issue #26970: [SPARK-28825][SQL][DOC] Documentation for Explain Command
URL: https://github.com/apache/spark/pull/26970#issuecomment-569946989
 
 
   Ping @PavithraRamachandran 

----------------------------------------------------------------
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:
users@infra.apache.org


With regards,
Apache Git Services

---------------------------------------------------------------------
To unsubscribe, e-mail: reviews-unsubscribe@spark.apache.org
For additional commands, e-mail: reviews-help@spark.apache.org

[GitHub] [spark] AmplabJenkins removed a comment on issue #26970: [SPARK-28825][SQL][DOC] Documentation for Explain Command

Posted by GitBox <gi...@apache.org>.
AmplabJenkins removed a comment on issue #26970: [SPARK-28825][SQL][DOC] Documentation for Explain Command
URL: https://github.com/apache/spark/pull/26970#issuecomment-567973919
 
 
   Can one of the admins verify this patch?

----------------------------------------------------------------
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:
users@infra.apache.org


With regards,
Apache Git Services

---------------------------------------------------------------------
To unsubscribe, e-mail: reviews-unsubscribe@spark.apache.org
For additional commands, e-mail: reviews-help@spark.apache.org

[GitHub] [spark] PavithraRamachandran commented on a change in pull request #26970: [SPARK-28825][SQL][DOC] Documentation for Explain Command

Posted by GitBox <gi...@apache.org>.
PavithraRamachandran 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_r362445041
 
 

 ##########
 File path: docs/sql-ref-syntax-qry-explain.md
 ##########
 @@ -19,4 +19,112 @@ license: |
   limitations under the License.
 ---
 
-**This page is under construction**
+### Description
+
+The `EXPLAIN` statement is used to provide logical/physical plans for an input statement. 
+By default, this clause provides information about a physical plan only.
+
+
+### 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>
+
+<dl>
+  <dt><code><em>statement</em></code></dt>
+  <dd>
+    Specifies a SQL statement to be explained.
+  </dd>
+ </dl>
+
+### Examples
+{% highlight sql %}
+
+--Default Output
+
+EXPLAIN select * from emp;
++----------------------------------------------------+
+|                        plan                        |
++----------------------------------------------------+
+| == Physical Plan ==
+*(1) ColumnarToRow
++- FileScan parquet default.emp[id#0] Batched: true, DataFilters: [], Format: Parquet, Location: InMemoryFileIndex[file:/home/root1/Spark/spark/spark-warehouse/emp], PartitionFilters: [], PushedFilters: [], ReadSchema: struct<id:int>
 
 Review comment:
   ${file_path}/emp shall i make the reference like this or remove?

----------------------------------------------------------------
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:
users@infra.apache.org


With regards,
Apache Git Services

---------------------------------------------------------------------
To unsubscribe, e-mail: reviews-unsubscribe@spark.apache.org
For additional commands, e-mail: reviews-help@spark.apache.org

[GitHub] [spark] AmplabJenkins commented on issue #26970: [SPARK-28825][SQL][DOC] Documentation for Explain Command

Posted by GitBox <gi...@apache.org>.
AmplabJenkins commented on issue #26970: [SPARK-28825][SQL][DOC] Documentation for Explain Command
URL: https://github.com/apache/spark/pull/26970#issuecomment-571831369
 
 
   Test PASSed.
   Refer to this link for build results (access rights to CI server needed): 
   https://amplab.cs.berkeley.edu/jenkins//job/SparkPullRequestBuilder-K8s/21060/
   Test PASSed.

----------------------------------------------------------------
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:
users@infra.apache.org


With regards,
Apache Git Services

---------------------------------------------------------------------
To unsubscribe, e-mail: reviews-unsubscribe@spark.apache.org
For additional commands, e-mail: reviews-help@spark.apache.org

[GitHub] [spark] maropu edited a comment on issue #26970: [SPARK-28825][SQL][DOC] Documentation for Explain Command

Posted by GitBox <gi...@apache.org>.
maropu edited a comment on issue #26970: [SPARK-28825][SQL][DOC] Documentation for Explain Command
URL: https://github.com/apache/spark/pull/26970#issuecomment-568142931
 
 
   Thanks for the work, @PavithraRamachandran. btw, I updated the PR template. Plz don't change it next time.

----------------------------------------------------------------
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:
users@infra.apache.org


With regards,
Apache Git Services

---------------------------------------------------------------------
To unsubscribe, e-mail: reviews-unsubscribe@spark.apache.org
For additional commands, e-mail: reviews-help@spark.apache.org

[GitHub] [spark] SparkQA commented on issue #26970: [SPARK-28825][SQL][DOC] Documentation for Explain Command

Posted by GitBox <gi...@apache.org>.
SparkQA commented on issue #26970: [SPARK-28825][SQL][DOC] Documentation for Explain Command
URL: https://github.com/apache/spark/pull/26970#issuecomment-571830977
 
 
   **[Test build #116268 has started](https://amplab.cs.berkeley.edu/jenkins/job/SparkPullRequestBuilder/116268/testReport)** for PR 26970 at commit [`4d0867f`](https://github.com/apache/spark/commit/4d0867fd9acb6a5305940dc5a0fecaf236c4bc0d).

----------------------------------------------------------------
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:
users@infra.apache.org


With regards,
Apache Git Services

---------------------------------------------------------------------
To unsubscribe, e-mail: reviews-unsubscribe@spark.apache.org
For additional commands, e-mail: reviews-help@spark.apache.org

[GitHub] [spark] maropu commented on a change in pull request #26970: [SPARK-28825][SQL][DOC] Documentation for Explain Command

Posted by GitBox <gi...@apache.org>.
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_r361028289
 
 

 ##########
 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. 
 
 Review comment:
   How about `The EXPLAIN statement is used to provide logical/physical plans for an input statement. `?

----------------------------------------------------------------
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:
users@infra.apache.org


With regards,
Apache Git Services

---------------------------------------------------------------------
To unsubscribe, e-mail: reviews-unsubscribe@spark.apache.org
For additional commands, e-mail: reviews-help@spark.apache.org

[GitHub] [spark] PavithraRamachandran commented on a change in pull request #26970: [SPARK-28825][SQL][DOC] Documentation for Explain Command

Posted by GitBox <gi...@apache.org>.
PavithraRamachandran 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_r361171023
 
 

 ##########
 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.
 
 Review comment:
   sorry I made a mistake while executing. Thank you. I corrected. 

----------------------------------------------------------------
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:
users@infra.apache.org


With regards,
Apache Git Services

---------------------------------------------------------------------
To unsubscribe, e-mail: reviews-unsubscribe@spark.apache.org
For additional commands, e-mail: reviews-help@spark.apache.org

[GitHub] [spark] maropu commented on a change in pull request #26970: [SPARK-28825][SQL][DOC] Documentation for Explain Command

Posted by GitBox <gi...@apache.org>.
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_r361028828
 
 

 ##########
 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>
+
+### Examples
+{% highlight sql %}
+
+-- Using Extended
 
 Review comment:
   Let's put the three examples here: the default case, the extended case, and the formatted case.

----------------------------------------------------------------
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:
users@infra.apache.org


With regards,
Apache Git Services

---------------------------------------------------------------------
To unsubscribe, e-mail: reviews-unsubscribe@spark.apache.org
For additional commands, e-mail: reviews-help@spark.apache.org

[GitHub] [spark] maropu closed pull request #26970: [SPARK-28825][SQL][DOC] Documentation for Explain Command

Posted by GitBox <gi...@apache.org>.
maropu closed pull request #26970: [SPARK-28825][SQL][DOC] Documentation for Explain Command
URL: https://github.com/apache/spark/pull/26970
 
 
   

----------------------------------------------------------------
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:
users@infra.apache.org


With regards,
Apache Git Services

---------------------------------------------------------------------
To unsubscribe, e-mail: reviews-unsubscribe@spark.apache.org
For additional commands, e-mail: reviews-help@spark.apache.org

[GitHub] [spark] srowen commented on a change in pull request #26970: [SPARK-28825][SQL][DOC] Documentation for Explain Command

Posted by GitBox <gi...@apache.org>.
srowen 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_r360711584
 
 

 ##########
 File path: docs/sql-ref-syntax-qry-explain.md
 ##########
 @@ -19,4 +19,157 @@ 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] 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.</dd>
 
 Review comment:
   Can we say anything about what the plans represent, even just a sentence?

----------------------------------------------------------------
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:
users@infra.apache.org


With regards,
Apache Git Services

---------------------------------------------------------------------
To unsubscribe, e-mail: reviews-unsubscribe@spark.apache.org
For additional commands, e-mail: reviews-help@spark.apache.org

[GitHub] [spark] PavithraRamachandran commented on a change in pull request #26970: [SPARK-28825][SQL][DOC] Documentation for Explain Command

Posted by GitBox <gi...@apache.org>.
PavithraRamachandran 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_r360912660
 
 

 ##########
 File path: docs/sql-ref-syntax-qry-explain.md
 ##########
 @@ -19,4 +19,157 @@ 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] 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.</dd>
 
 Review comment:
   @srowen I have added some additional information. Could you check if that is ok?

----------------------------------------------------------------
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:
users@infra.apache.org


With regards,
Apache Git Services

---------------------------------------------------------------------
To unsubscribe, e-mail: reviews-unsubscribe@spark.apache.org
For additional commands, e-mail: reviews-help@spark.apache.org

[GitHub] [spark] PavithraRamachandran commented on issue #26970: [SPARK-28825][SQL][DOC] Documentation for Explain Command

Posted by GitBox <gi...@apache.org>.
PavithraRamachandran commented on issue #26970: [SPARK-28825][SQL][DOC] Documentation for Explain Command
URL: https://github.com/apache/spark/pull/26970#issuecomment-571110118
 
 
   @maropu  could you review the document? i have updated the description too with the latest.

----------------------------------------------------------------
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:
users@infra.apache.org


With regards,
Apache Git Services

---------------------------------------------------------------------
To unsubscribe, e-mail: reviews-unsubscribe@spark.apache.org
For additional commands, e-mail: reviews-help@spark.apache.org

[GitHub] [spark] AmplabJenkins removed a comment on issue #26970: [SPARK-28825][SQL][DOC] Documentation for Explain Command

Posted by GitBox <gi...@apache.org>.
AmplabJenkins removed a comment on issue #26970: [SPARK-28825][SQL][DOC] Documentation for Explain Command
URL: https://github.com/apache/spark/pull/26970#issuecomment-567980153
 
 
   Can one of the admins verify this patch?

----------------------------------------------------------------
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:
users@infra.apache.org


With regards,
Apache Git Services

---------------------------------------------------------------------
To unsubscribe, e-mail: reviews-unsubscribe@spark.apache.org
For additional commands, e-mail: reviews-help@spark.apache.org

[GitHub] [spark] maropu commented on a change in pull request #26970: [SPARK-28825][SQL][DOC] Documentation for Explain Command

Posted by GitBox <gi...@apache.org>.
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_r361027802
 
 

 ##########
 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
 
 Review comment:
   Since its better to follow the other docs, `statement` -> `input_statement`? https://github.com/apache/spark/blob/master/docs/sql-ref-syntax-aux-describe-query.md#syntax
   Can you check again that kind of consistency for the other statements, too?

----------------------------------------------------------------
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:
users@infra.apache.org


With regards,
Apache Git Services

---------------------------------------------------------------------
To unsubscribe, e-mail: reviews-unsubscribe@spark.apache.org
For additional commands, e-mail: reviews-help@spark.apache.org

[GitHub] [spark] maropu commented on a change in pull request #26970: [SPARK-28825][SQL][DOC] Documentation for Explain Command

Posted by GitBox <gi...@apache.org>.
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_r362435000
 
 

 ##########
 File path: docs/sql-ref-syntax-qry-explain.md
 ##########
 @@ -19,4 +19,112 @@ license: |
   limitations under the License.
 ---
 
-**This page is under construction**
+### Description
+
+The `EXPLAIN` statement is used to provide logical/physical plans for an input statement. 
+By default, this clause provides information about a physical plan only.
+
+
+### 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.
 
 Review comment:
   nit: please do not capitalize words in the middle of statements.

----------------------------------------------------------------
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:
users@infra.apache.org


With regards,
Apache Git Services

---------------------------------------------------------------------
To unsubscribe, e-mail: reviews-unsubscribe@spark.apache.org
For additional commands, e-mail: reviews-help@spark.apache.org

[GitHub] [spark] maropu commented on a change in pull request #26970: [SPARK-28825][SQL][DOC] Documentation for Explain Command

Posted by GitBox <gi...@apache.org>.
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_r362446099
 
 

 ##########
 File path: docs/sql-ref-syntax-qry-explain.md
 ##########
 @@ -19,4 +19,112 @@ license: |
   limitations under the License.
 ---
 
-**This page is under construction**
+### Description
+
+The `EXPLAIN` statement is used to provide logical/physical plans for an input statement. 
+By default, this clause provides information about a physical plan only.
+
+
+### 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>
+
+<dl>
+  <dt><code><em>statement</em></code></dt>
+  <dd>
+    Specifies a SQL statement to be explained.
+  </dd>
+ </dl>
+
+### Examples
+{% highlight sql %}
+
+--Default Output
+
+EXPLAIN select * from emp;
++----------------------------------------------------+
+|                        plan                        |
++----------------------------------------------------+
+| == Physical Plan ==
+*(1) ColumnarToRow
++- FileScan parquet default.emp[id#0] Batched: true, DataFilters: [], Format: Parquet, Location: InMemoryFileIndex[file:/home/root1/Spark/spark/spark-warehouse/emp], PartitionFilters: [], PushedFilters: [], ReadSchema: struct<id:int>
 
 Review comment:
   How about just using a simpler query? e.g.,
   ```
   scala> sql("explain select k, sum(v) from values (1, 2), (1, 3) t(k, v) group by k").show(1, false)
   +----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
   |plan                                                                                                                                                                                                                                                                        |
   +----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
   |== Physical Plan ==
   *(2) HashAggregate(keys=[k#5], functions=[sum(cast(v#6 as bigint))])
   +- Exchange hashpartitioning(k#5, 200), true, [id=#16]
      +- *(1) HashAggregate(keys=[k#5], functions=[partial_sum(cast(v#6 as bigint))])
         +- *(1) LocalTableScan [k#5, v#6]
   
   |
   +----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
   ```

----------------------------------------------------------------
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:
users@infra.apache.org


With regards,
Apache Git Services

---------------------------------------------------------------------
To unsubscribe, e-mail: reviews-unsubscribe@spark.apache.org
For additional commands, e-mail: reviews-help@spark.apache.org

[GitHub] [spark] maropu commented on a change in pull request #26970: [SPARK-28825][SQL][DOC] Documentation for Explain Command

Posted by GitBox <gi...@apache.org>.
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_r362435598
 
 

 ##########
 File path: docs/sql-ref-syntax-qry-explain.md
 ##########
 @@ -19,4 +19,112 @@ license: |
   limitations under the License.
 ---
 
-**This page is under construction**
+### Description
+
+The `EXPLAIN` statement is used to provide logical/physical plans for an input statement. 
+By default, this clause provides information about a physical plan only.
+
+
+### 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>
 
 Review comment:
   ditto

----------------------------------------------------------------
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:
users@infra.apache.org


With regards,
Apache Git Services

---------------------------------------------------------------------
To unsubscribe, e-mail: reviews-unsubscribe@spark.apache.org
For additional commands, e-mail: reviews-help@spark.apache.org

[GitHub] [spark] SparkQA removed a comment on issue #26970: [SPARK-28825][SQL][DOC] Documentation for Explain Command

Posted by GitBox <gi...@apache.org>.
SparkQA removed a comment on issue #26970: [SPARK-28825][SQL][DOC] Documentation for Explain Command
URL: https://github.com/apache/spark/pull/26970#issuecomment-571830977
 
 
   **[Test build #116268 has started](https://amplab.cs.berkeley.edu/jenkins/job/SparkPullRequestBuilder/116268/testReport)** for PR 26970 at commit [`4d0867f`](https://github.com/apache/spark/commit/4d0867fd9acb6a5305940dc5a0fecaf236c4bc0d).

----------------------------------------------------------------
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:
users@infra.apache.org


With regards,
Apache Git Services

---------------------------------------------------------------------
To unsubscribe, e-mail: reviews-unsubscribe@spark.apache.org
For additional commands, e-mail: reviews-help@spark.apache.org

[GitHub] [spark] AmplabJenkins removed a comment on issue #26970: [SPARK-28825][SQL][DOC] Documentation for Explain Command

Posted by GitBox <gi...@apache.org>.
AmplabJenkins removed a comment on issue #26970: [SPARK-28825][SQL][DOC] Documentation for Explain Command
URL: https://github.com/apache/spark/pull/26970#issuecomment-571831353
 
 
   Merged build finished. Test PASSed.

----------------------------------------------------------------
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:
users@infra.apache.org


With regards,
Apache Git Services

---------------------------------------------------------------------
To unsubscribe, e-mail: reviews-unsubscribe@spark.apache.org
For additional commands, e-mail: reviews-help@spark.apache.org

[GitHub] [spark] maropu commented on a change in pull request #26970: [SPARK-28825][SQL][DOC] Documentation for Explain Command

Posted by GitBox <gi...@apache.org>.
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_r360622819
 
 

 ##########
 File path: docs/sql-ref-syntax-qry-explain.md
 ##########
 @@ -19,4 +19,157 @@ 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] statement
 
 Review comment:
   We have more modes for explains:
   https://github.com/apache/spark/blob/c72f88b0ba20727e831ba9755d9628d0347ee3cb/sql/core/src/main/scala/org/apache/spark/sql/execution/command/commands.scala#L134

----------------------------------------------------------------
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:
users@infra.apache.org


With regards,
Apache Git Services

---------------------------------------------------------------------
To unsubscribe, e-mail: reviews-unsubscribe@spark.apache.org
For additional commands, e-mail: reviews-help@spark.apache.org

[GitHub] [spark] AmplabJenkins commented on issue #26970: [SPARK-28825][SQL][DOC] Documentation for Explain Command

Posted by GitBox <gi...@apache.org>.
AmplabJenkins commented on issue #26970: [SPARK-28825][SQL][DOC] Documentation for Explain Command
URL: https://github.com/apache/spark/pull/26970#issuecomment-567973919
 
 
   Can one of the admins verify this patch?

----------------------------------------------------------------
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:
users@infra.apache.org


With regards,
Apache Git Services

---------------------------------------------------------------------
To unsubscribe, e-mail: reviews-unsubscribe@spark.apache.org
For additional commands, e-mail: reviews-help@spark.apache.org

[GitHub] [spark] maropu edited a comment on issue #26970: [SPARK-28825][SQL][DOC] Documentation for Explain Command

Posted by GitBox <gi...@apache.org>.
maropu edited a comment on issue #26970: [SPARK-28825][SQL][DOC] Documentation for Explain Command
URL: https://github.com/apache/spark/pull/26970#issuecomment-568142931
 
 
   Thanks for the work, @PavithraRamachandran. btw, I updated the PR template and plz don't change it next time.

----------------------------------------------------------------
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:
users@infra.apache.org


With regards,
Apache Git Services

---------------------------------------------------------------------
To unsubscribe, e-mail: reviews-unsubscribe@spark.apache.org
For additional commands, e-mail: reviews-help@spark.apache.org

[GitHub] [spark] maropu commented on a change in pull request #26970: [SPARK-28825][SQL][DOC] Documentation for Explain Command

Posted by GitBox <gi...@apache.org>.
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_r361028626
 
 

 ##########
 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>
+
+### Examples
+{% highlight sql %}
+
+-- Using Extended
+
+EXPLAIN EXTENDED select * from emp;
++----------------------------------------------------+
+|                        plan                        |
++----------------------------------------------------+
+| == Parsed Logical Plan ==
+'Project [*]
++- 'UnresolvedRelation [emp]
+
+== Analyzed Logical Plan ==
+id: int
+Project [id#0]
++- SubqueryAlias `default`.`emp`
+   +- Relation[id#0] parquet
+
+== Optimized Logical Plan ==
+Relation[id#0] parquet
+
+== Physical Plan ==
+*(1) ColumnarToRow
++- FileScan parquet default.emp[id#0] Batched: true, DataFilters: [], Format: Parquet, Location: InMemoryFileIndex[file:/home/root1/Spark/spark/spark-warehouse/emp], PartitionFilters: [], PushedFilters: [], ReadSchema: struct<id:int>
+ |
++----------------------------------------------------+
+
+--Default Output
+
+EXPLAIN select * from emp;
++----------------------------------------------------+
+|                        plan                        |
++----------------------------------------------------+
+| == Physical Plan ==
+*(1) ColumnarToRow
++- FileScan parquet default.emp[id#0] Batched: true, DataFilters: [], Format: Parquet, Location: InMemoryFileIndex[file:/home/root1/Spark/spark/spark-warehouse/emp], PartitionFilters: [], PushedFilters: [], ReadSchema: struct<id:int>
+
+ |
++----------------------------------------------------+
+
+-- Using Cost 
+EXPLAIN COST select * from emp;
++----------------------------------------------------+
+|                        plan                        |
++----------------------------------------------------+
+| == Optimized Logical Plan ==
+Relation[id#5] parquet, Statistics(sizeInBytes=421.0 B)
+
+== Physical Plan ==
+*(1) ColumnarToRow
++- FileScan parquet default.emp[id#5] Batched: true, DataFilters: [], Format: Parquet, Location: InMemoryFileIndex[file:/home/root1/Spark/spark/spark-warehouse/emp], PartitionFilters: [], PushedFilters: [], ReadSchema: struct<id:int>
+
+ |
++----------------------------------------------------+
+
+--Using Formatted
+
+EXPLAIN FORMATTED select * from emp;
++----------------------------------------------------+
+|                        plan                        |
++----------------------------------------------------+
+| == Physical Plan ==
+* ColumnarToRow (2)
++- Scan parquet default.emp (1)
+
+
+(1) Scan parquet default.emp 
+Output: [id#5]
+Batched: true
+Location: InMemoryFileIndex [file:/home/root1/Spark/spark/spark-warehouse/emp]
+ReadSchema: struct&lt;id:int&gt;
+     
+(2) ColumnarToRow [codegen id : 1]
+Input: [id#5]
+     
+ |
++----------------------------------------------------+
+
+
+-- Using CODEGEN
+
+EXPLAIN CODEGEN select * from emp;
 
 Review comment:
   I think we don't need this CODEGEN example.

----------------------------------------------------------------
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:
users@infra.apache.org


With regards,
Apache Git Services

---------------------------------------------------------------------
To unsubscribe, e-mail: reviews-unsubscribe@spark.apache.org
For additional commands, e-mail: reviews-help@spark.apache.org

[GitHub] [spark] maropu commented on issue #26970: [SPARK-28825][SQL][DOC] Documentation for Explain Command

Posted by GitBox <gi...@apache.org>.
maropu commented on issue #26970: [SPARK-28825][SQL][DOC] Documentation for Explain Command
URL: https://github.com/apache/spark/pull/26970#issuecomment-568142931
 
 
   I updated the PR template. Plz don't change it next time.

----------------------------------------------------------------
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:
users@infra.apache.org


With regards,
Apache Git Services

---------------------------------------------------------------------
To unsubscribe, e-mail: reviews-unsubscribe@spark.apache.org
For additional commands, e-mail: reviews-help@spark.apache.org

[GitHub] [spark] maropu commented on a change in pull request #26970: [SPARK-28825][SQL][DOC] Documentation for Explain Command

Posted by GitBox <gi...@apache.org>.
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_r362435876
 
 

 ##########
 File path: docs/sql-ref-syntax-qry-explain.md
 ##########
 @@ -19,4 +19,112 @@ license: |
   limitations under the License.
 ---
 
-**This page is under construction**
+### Description
+
+The `EXPLAIN` statement is used to provide logical/physical plans for an input statement. 
+By default, this clause provides information about a physical plan only.
+
+
+### 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>
+
+<dl>
+  <dt><code><em>statement</em></code></dt>
+  <dd>
+    Specifies a SQL statement to be explained.
+  </dd>
+ </dl>
+
+### Examples
+{% highlight sql %}
+
+--Default Output
+
+EXPLAIN select * from emp;
++----------------------------------------------------+
+|                        plan                        |
++----------------------------------------------------+
+| == Physical Plan ==
+*(1) ColumnarToRow
++- FileScan parquet default.emp[id#0] Batched: true, DataFilters: [], Format: Parquet, Location: InMemoryFileIndex[file:/home/root1/Spark/spark/spark-warehouse/emp], PartitionFilters: [], PushedFilters: [], ReadSchema: struct<id:int>
 
 Review comment:
   nit: can we avoid the environment-dependent info (`file:/home/root1/Spark/spark/...`) in this doc?

----------------------------------------------------------------
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:
users@infra.apache.org


With regards,
Apache Git Services

---------------------------------------------------------------------
To unsubscribe, e-mail: reviews-unsubscribe@spark.apache.org
For additional commands, e-mail: reviews-help@spark.apache.org

[GitHub] [spark] AmplabJenkins removed a comment on issue #26970: [SPARK-28825][SQL][DOC] Documentation for Explain Command

Posted by GitBox <gi...@apache.org>.
AmplabJenkins removed a comment on issue #26970: [SPARK-28825][SQL][DOC] Documentation for Explain Command
URL: https://github.com/apache/spark/pull/26970#issuecomment-571833880
 
 
   Merged build finished. Test PASSed.

----------------------------------------------------------------
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:
users@infra.apache.org


With regards,
Apache Git Services

---------------------------------------------------------------------
To unsubscribe, e-mail: reviews-unsubscribe@spark.apache.org
For additional commands, e-mail: reviews-help@spark.apache.org

[GitHub] [spark] AmplabJenkins removed a comment on issue #26970: [SPARK-28825][SQL][DOC] Documentation for Explain Command

Posted by GitBox <gi...@apache.org>.
AmplabJenkins removed a comment on issue #26970: [SPARK-28825][SQL][DOC] Documentation for Explain Command
URL: https://github.com/apache/spark/pull/26970#issuecomment-571831369
 
 
   Test PASSed.
   Refer to this link for build results (access rights to CI server needed): 
   https://amplab.cs.berkeley.edu/jenkins//job/SparkPullRequestBuilder-K8s/21060/
   Test PASSed.

----------------------------------------------------------------
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:
users@infra.apache.org


With regards,
Apache Git Services

---------------------------------------------------------------------
To unsubscribe, e-mail: reviews-unsubscribe@spark.apache.org
For additional commands, e-mail: reviews-help@spark.apache.org

[GitHub] [spark] AmplabJenkins commented on issue #26970: [SPARK-28825][SQL][DOC] Documentation for Explain Command

Posted by GitBox <gi...@apache.org>.
AmplabJenkins commented on issue #26970: [SPARK-28825][SQL][DOC] Documentation for Explain Command
URL: https://github.com/apache/spark/pull/26970#issuecomment-571833889
 
 
   Test PASSed.
   Refer to this link for build results (access rights to CI server needed): 
   https://amplab.cs.berkeley.edu/jenkins//job/SparkPullRequestBuilder/116268/
   Test PASSed.

----------------------------------------------------------------
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:
users@infra.apache.org


With regards,
Apache Git Services

---------------------------------------------------------------------
To unsubscribe, e-mail: reviews-unsubscribe@spark.apache.org
For additional commands, e-mail: reviews-help@spark.apache.org