[
https://issues.apache.org/jira/browse/SPARK-33850?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17252242#comment-17252242
]
Apache Spark commented on SPARK-33850:
--------------------------------------
User 'sarutak' has created a pull request for this issue:
https://github.com/apache/spark/pull/30855
> EXPLAIN FORMATTED doesn't show the plan for subqueries if AQE is enabled
> ------------------------------------------------------------------------
>
> Key: SPARK-33850
> URL: https://issues.apache.org/jira/browse/SPARK-33850
> Project: Spark
> Issue Type: Bug
> Components: SQL
> Affects Versions: 3.2.0
> Reporter: Kousuke Saruta
> Assignee: Kousuke Saruta
> Priority: Major
>
> When AQE is enabled, EXPLAIN FORMATTED doesn't show the plan for subqueries.
> {code}
> spark.conf.set("spark.sql.adaptive.enabled", "true")
> val df = spark.range(1, 100)
> df.createTempView("df")
> spark.sql("SELECT (SELECT min(id) AS v FROM df)").explain("FORMATTED")
> == Physical Plan ==
> AdaptiveSparkPlan (3)
> +- Project (2)
> +- Scan OneRowRelation (1)
> (1) Scan OneRowRelation
> Output: []
> Arguments: ParallelCollectionRDD[0] at explain at <console>:24,
> OneRowRelation, UnknownPartitioning(0)
> (2) Project
> Output [1]: [Subquery subquery#3, [id=#20] AS scalarsubquery()#5L]
> Input: []
> (3) AdaptiveSparkPlan
> Output [1]: [scalarsubquery()#5L]
> Arguments: isFinalPlan=false
> {code}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
