You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@spark.apache.org by "Wenchen Fan (Jira)" <ji...@apache.org> on 2020/12/16 13:43:00 UTC

[jira] [Resolved] (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:all-tabpanel ]

Wenchen Fan resolved SPARK-33803.
---------------------------------
    Fix Version/s: 3.1.0
       Resolution: Fixed

Issue resolved by pull request 30799
[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
>            Assignee: Apache Spark
>            Priority: Minor
>             Fix For: 3.1.0
>
>
> 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