[ 
https://issues.apache.org/jira/browse/SPARK-20067?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Xiao Li updated SPARK-20067:
----------------------------
    Description: 
We should unify and clean up the outputs of `DESC EXTENDED/FORMATTED` and `SHOW 
TABLE EXTENDED` by moving the logics into the Catalog interface. The output 
formats are improved. We also add the missing attributes. It impacts the DDL 
commands like `SHOW TABLE EXTENDED`, `DESC EXTENDED` and `DESC FORMATTED`.

In addition, by following what we did in Dataset API `printSchema`, we can use 
`treeString` to show the schema in the more readable way. 


  was:
Currently, we are using {{sql}} to print the schema. To make the schema more 
readable, we should use {{treeString}}, like what we did in Dataset API 
{{printSchema}}

Below is the current way:
{noformat}
Schema: STRUCT<`a`: STRING (nullable = true), `b`: INT (nullable = true), `c`: 
STRING (nullable = true), `d`: STRING (nullable = true)>
{noformat}

After the change, it should look like
{noformat}
Schema: root
 |-- a: string (nullable = true)
 |-- b: integer (nullable = true)
 |-- c: string (nullable = true)
 |-- d: string (nullable = true)
{noformat}



> Use treeString to print out the table schema for CatalogTable
> -------------------------------------------------------------
>
>                 Key: SPARK-20067
>                 URL: https://issues.apache.org/jira/browse/SPARK-20067
>             Project: Spark
>          Issue Type: Improvement
>          Components: SQL
>    Affects Versions: 2.1.0
>            Reporter: Xiao Li
>            Assignee: Xiao Li
>
> We should unify and clean up the outputs of `DESC EXTENDED/FORMATTED` and 
> `SHOW TABLE EXTENDED` by moving the logics into the Catalog interface. The 
> output formats are improved. We also add the missing attributes. It impacts 
> the DDL commands like `SHOW TABLE EXTENDED`, `DESC EXTENDED` and `DESC 
> FORMATTED`.
> In addition, by following what we did in Dataset API `printSchema`, we can 
> use `treeString` to show the schema in the more readable way. 



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org
For additional commands, e-mail: issues-h...@spark.apache.org

Reply via email to