[ 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-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org