You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@spark.apache.org by "Herman van Hovell (JIRA)" <ji...@apache.org> on 2016/07/14 15:19:20 UTC
[jira] [Resolved] (SPARK-16543) Rename the columns of `SHOW
PARTITION/COLUMNS` commands
[ https://issues.apache.org/jira/browse/SPARK-16543?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Herman van Hovell resolved SPARK-16543.
---------------------------------------
Resolution: Fixed
Assignee: Dongjoon Hyun
Fix Version/s: 2.1.0
> Rename the columns of `SHOW PARTITION/COLUMNS` commands
> -------------------------------------------------------
>
> Key: SPARK-16543
> URL: https://issues.apache.org/jira/browse/SPARK-16543
> Project: Spark
> Issue Type: Improvement
> Components: SQL
> Reporter: Dongjoon Hyun
> Assignee: Dongjoon Hyun
> Priority: Minor
> Fix For: 2.1.0
>
>
> This issue changes the name of columns returned by `SHOW PARTITION/COLUMNS` commands. Currently, both commands uses `result` as a column name.
> **Comparison**
> ||Command||Spark(Before)||Spark(After)||Hive||
> |SHOW PARTITIONS|result|partition|partition|
> |SHOW COLUMNS|result|col_name|field|
> Note that Spark/Hive show 'col_name` in `DESC TABLES`. So, after this issue, Spark uses `col_name` consistently among commands.
> **Before**
> {code}
> scala> sql("show partitions p").show()
> +------+
> |result|
> +------+
> | b=2|
> +------+
> scala> sql("show columns in p").show()
> +------+
> |result|
> +------+
> | a|
> | b|
> +------+
> {code}
> **After**
> {code}
> scala> sql("show partitions p").show
> +---------+
> |partition|
> +---------+
> | b=2|
> +---------+
> scala> sql("show columns in p").show
> +--------+
> |col_name|
> +--------+
> | a|
> | b|
> +--------+
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@spark.apache.org
For additional commands, e-mail: issues-help@spark.apache.org