You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@spark.apache.org by "Apache Spark (Jira)" <ji...@apache.org> on 2020/12/16 08:21:00 UTC
[jira] [Commented] (SPARK-33803) Sort table properties by key in
DESCRIBE TABLE command
[ https://issues.apache.org/jira/browse/SPARK-33803?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17250163#comment-17250163 ]
Apache Spark commented on SPARK-33803:
--------------------------------------
User 'HyukjinKwon' has created a pull request for this issue:
https://github.com/apache/spark/pull/30799
> Sort table properties by key in DESCRIBE TABLE command
> ------------------------------------------------------
>
> Key: SPARK-33803
> URL: https://issues.apache.org/jira/browse/SPARK-33803
> Project: Spark
> Issue Type: Improvement
> Components: SQL
> Affects Versions: 3.1.0
> Reporter: Hyukjin Kwon
> Priority: Minor
>
> Currently:
> {code}
> -- !query
> DESC FORMATTED v
> -- !query schema
> struct<col_name:string,data_type:string,comment:string>
> -- !query output
> a string
> b int
> c string
> d string
>
> # Detailed Table Information
> Database default
> Table v
> Created Time [not included in comparison]
> Last Access [not included in comparison]
> Created By [not included in comparison]
> Type VIEW
> View Text SELECT * FROM t
> View Original Text SELECT * FROM t
> View Catalog and Namespace spark_catalog.default
> View Query Output Columns [a, b, c, d]
> Table Properties [view.catalogAndNamespace.numParts=2, view.catalogAndNamespace.part.0=spark_catalog, view.catalogAndNamespace.part.1=default, view.query.out.col.0=a, view.query.out.col.1=b, view.query.out.col.2=c, view.query.out.col.3=d, view.query.out.numCols=4, view.referredTempFunctionsNames=[], view.referredTempViewNames=[]]
> {code}
> The order of "Table Properties" is indeterministic which makes the test above fails in other environments. It should be best to sort it by key. This is consistent with DSv2 command as well.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@spark.apache.org
For additional commands, e-mail: issues-help@spark.apache.org