[GitHub] [spark] kiszk commented on a change in pull request #25349: [SPARK-28538][UI][WIP] Document SQL page

[GitBox <gi...@apache.org>]

kiszk commented on a change in pull request #25349: [SPARK-28538][UI][WIP] Document SQL page
URL: https://github.com/apache/spark/pull/25349#discussion_r312600796
 
 

 ##########
 File path: docs/web-ui.md
 ##########
 @@ -0,0 +1,119 @@
+---
+layout: global
+title: Web UI
+description: Web UI guide for Spark SPARK_VERSION_SHORT
+license: |
+  Licensed to the Apache Software Foundation (ASF) under one or more
+  contributor license agreements.  See the NOTICE file distributed with
+  this work for additional information regarding copyright ownership.
+  The ASF licenses this file to You under the Apache License, Version 2.0
+  (the "License"); you may not use this file except in compliance with
+  the License.  You may obtain a copy of the License at
+ 
+     http://www.apache.org/licenses/LICENSE-2.0
+ 
+  Unless required by applicable law or agreed to in writing, software
+  distributed under the License is distributed on an "AS IS" BASIS,
+  WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+  See the License for the specific language governing permissions and
+  limitations under the License.
+---
+
+Apache Spark provides a suite of web user interfaces (UIs) that you can use
+to monitor the status and resource consumption of your Spark cluster.
+
+
+**Table of Contents**
+
+* This will become a table of contents (this text will be scraped).
+{:toc}
+
+## Jobs Tab
+The Jobs tab displays a summary page of all jobs in the Spark application and a details page
+for each job. The summary page shows high-level information, such as the status, duration, and
+progress of all jobs and the overall event timeline. When you click on a job on the summary
+page, you see the details page for that job. The details page further shows the event timeline,
+DAG visualization, and all stages of the job.
+
+## Stages Tab
+The Stages tab displays a summary page that shows the current state of all stages of all jobs in
+the Spark application, and, when you click on a stage, a details page for that stage. The details
+page shows the event timeline, DAG visualization, and all tasks for the stage.
+
+## Storage Tab
+The Storage tab displays the persisted RDDs and DataFrames, if any, in the application. The summary
+page shows the storage levels, sizes and partitions of all RDDs, and the details page shows the
+sizes and using executors for all partitions in an RDD or DataFrame.
+
+## Environment Tab
+The Environment tab displays the values for the different environment and configuration variables,
+including JVM, Spark, and system properties.
+
+## Executors Tab
+The Executors tab displays summary information about the executors that were created for the
+application, including memory and disk usage and task and shuffle information. The Storage Memory
+column shows the amount of memory used and reserved for caching data.
+
+## SQL Tab
+If the application executes Spark SQL queries, the SQL tab displays information, such as the duration,
+jobs, and physical and logical plans for the queries. Here we include a basic example to illustrate
+this tab:
+{% highlight scala %}
+scala> val df = Seq((1, "andy"), (2, "bob"), (2, "andy")).toDF("count", "name")
+df: org.apache.spark.sql.DataFrame = [count: int, name: string]
+
+scala> df.count
+res0: Long = 3                                                                  
+
+scala> df.createGlobalTempView("df")
+
+scala> spark.sql("select name,sum(count) from global_temp.df group by name").show
++----+----------+
+|name|sum(count)|
++----+----------+
+|andy|         3|
+| bob|         2|
++----+----------+
+{% endhighlight %}
+
+<p style="text-align: center;">
+  <img src="img/webui-sql-tab.png"
+       title="SQL tab"
+       alt="SQL tab"
+       width="80%" />
+  <!-- Images are downsized intentionally to improve quality on retina displays -->
+</p>
+
+Now the above three dataframe/SQL operators are shown in the list. If we click the
+'show at \<console\>: 24' link of the last query, we will see the DAG of the job.
+
+<p style="text-align: center;">
+  <img src="img/webui-sql-dag.png"
+       title="SQL DAG"
+       alt="SQL DAG"
+       width="50%" />
+  <!-- Images are downsized intentionally to improve quality on retina displays -->
+</p>
+
+We can see that details information of each stage. The first block 'WholeStageCodegen'  
+compile multiple operator ('LocalTableScan' and 'HashAggregate') together into a single Java
+function to improve performance, and metrics like number of rows and spill size are listed in
+the block. The second block 'Exchange' shows the metrics on the shuffle exchange, including
+number of written shuffle records, total data size, etc.
+
+
+<p style="text-align: center;">
+  <img src="img/webui-sql-plan.png"
+       title="logical plans and the physical plan"
+       alt="logical plans and the physical plan"
+       width="80%" />
+  <!-- Images are downsized intentionally to improve quality on retina displays -->
+</p>
+Clicking the 'Details' link on the bottom displays the logical plans and the physical plan, which
+illustrate how Spark parse, analyze, optimize and perform the query.
 
 Review comment:
   `how Spark parse, analyze, optimize and perform the query.` -> `how Spark parses, analyzes, optimizes and performs the query.`?

----------------------------------------------------------------
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