Dilip Biswal created SPARK-27480: ------------------------------------ Summary: Improve explain output of describe query command to show the actual input query as opposed to a truncated logical plan. Key: SPARK-27480 URL: https://issues.apache.org/jira/browse/SPARK-27480 Project: Spark Issue Type: Bug Components: SQL Affects Versions: 2.4.1 Reporter: Dilip Biswal
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