[jira] [Commented] (SPARK-15692) Improves the explain output of several physical plans by displaying embedded logical plan in tree style

["Apache Spark (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/SPARK-15692?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15309371#comment-15309371 ] 

Apache Spark commented on SPARK-15692:
--------------------------------------

User 'clockfly' has created a pull request for this issue:
https://github.com/apache/spark/pull/13433

> Improves the explain output of several physical plans by displaying embedded logical plan in tree style
> -------------------------------------------------------------------------------------------------------
>
>                 Key: SPARK-15692
>                 URL: https://issues.apache.org/jira/browse/SPARK-15692
>             Project: Spark
>          Issue Type: Bug
>          Components: SQL
>            Reporter: Sean Zhong
>            Priority: Minor
>
> Some physical plan contains a embedded logical plan, for example, {code}cache tableName query{code} maps to:
> {code}
> case class CacheTableCommand(
>     tableName: String,
>     plan: Option[LogicalPlan],
>     isLazy: Boolean) 
>   extends RunnableCommand
> {code}
> It is easier to read the explain output if we can display the `plan` in tree style.
> Before change:
> {code}
> scala> Seq((1,2)).toDF().createOrReplaceTempView("testView")
> scala> spark.sql("cache table testView2 select * from testView").explain()
> == Physical Plan ==
> ExecutedCommand CacheTableCommand testView2, Some('Project [*]
> +- 'UnresolvedRelation `testView`, None
> ), false
> {code}
> After change:
> {code}
> scala> spark.sql("cache table testView2 select * from testView").explain()
> == Physical Plan ==
> ExecutedCommand
> :  +- CacheTableCommand testView2, false
> :     :  +- 'Project [*]
> :     :     +- 'UnresolvedRelation `testView`, None
> {code}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

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