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] [Updated] (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 updated SPARK-27480:
----------------------------------
Summary: Improve `EXPLAIN DESC QUERY` to show the input SQL statement (was: Improve explain output of describe query command to show the actual input query as opposed to a truncated logical plan.)
> 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
> Priority: Minor
>
> 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