[
https://issues.apache.org/jira/browse/SPARK-27480?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Dongjoon Hyun resolved SPARK-27480.
-----------------------------------
Resolution: Fixed
Assignee: Dilip Biswal
Fix Version/s: 3.0.0
This is resolved via https://github.com/apache/spark/pull/24385
> Improve `EXPLAIN DESC QUERY` to show the input SQL statement
> ------------------------------------------------------------
>
> Key: SPARK-27480
> URL: https://issues.apache.org/jira/browse/SPARK-27480
> Project: Spark
> Issue Type: Improvement
> Components: SQL
> Affects Versions: 2.4.1
> Reporter: Dilip Biswal
> Assignee: Dilip Biswal
> Priority: Minor
> Fix For: 3.0.0
>
>
> Currently running explain on describe query gives a little confusing output.
> Instead of showing the actual query that is input by the user, it shows the
> truncated logical plan as the input. We should improve it to show the query
> text as input by user.
> Here are the sample outputs of the explain command.
>
> {code:java}
> EXPLAIN DESCRIBE WITH s AS (SELECT 'hello' as col1) SELECT * FROM s;
> == Physical Plan ==
> Execute DescribeQueryCommand
> +- DescribeQueryCommand CTE [s]
> {code}
> {code:java}
> EXPLAIN EXTENDED DESCRIBE SELECT * from s1 where c1 > 0;
> == Physical Plan ==
> Execute DescribeQueryCommand
> +- DescribeQueryCommand 'Project [*]
> {code}
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org
For additional commands, e-mail: issues-h...@spark.apache.org
