Dongjoon Hyun created SPARK-16543:
-------------------------------------
Summary: 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
Priority: Minor
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-unsubscr...@spark.apache.org
For additional commands, e-mail: issues-h...@spark.apache.org
