You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@spark.apache.org by "Dongjoon Hyun (JIRA)" <ji...@apache.org> on 2019/04/21 22:42:00 UTC
[jira] [Resolved] (SPARK-27480) Improve `EXPLAIN DESC QUERY` to
show the input SQL statement
[ 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-unsubscribe@spark.apache.org
For additional commands, e-mail: issues-help@spark.apache.org