Dongjoon Hyun created SPARK-19218:
-------------------------------------
Summary: SET command should show a sorted result
Key: SPARK-19218
URL: https://issues.apache.org/jira/browse/SPARK-19218
Project: Spark
Issue Type: Bug
Components: SQL
Affects Versions: 2.1.0
Reporter: Dongjoon Hyun
Priority: Trivial
Currently, `SET` command shows unsorted result. We had better show a sorted
result for UX. Also, this is compatible with Hive.
*BEFORE*
{code}
scala> sql("set").show(false)
+-------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------+
|key |value
|
+-------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------+
|spark.driver.host |10.22.16.140
|
|spark.driver.port |63893
|
|hive.metastore.warehouse.dir |file:/Users/dhyun/spark/spark-warehouse
|
|spark.repl.class.uri |spark://10.22.16.140:63893/classes
|
|spark.jars |
|
|spark.repl.class.outputDir
|/private/var/folders/bl/67vhzgqs1ks88l92h8dy8_1r0000gp/T/spark-43da424e-7530-4053-b30e-4068e8424dc9/repl-f1c957c7-2e4a-4f14-b234-f7b9f2447971|
|spark.app.name |Spark shell
|
|spark.driver.memory |4G
|
|spark.executor.id |driver
|
|spark.submit.deployMode |client
|
|spark.master |local[*]
|
|spark.home |/Users/dhyun/spark
|
|spark.sql.catalogImplementation|hive
|
|spark.app.id |local-1484333618945
|
+-------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------+
{code}
*AFTER*
{code}
scala> sql("set").show(false)
+-------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------+
|key |value
|
+-------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------+
|hive.metastore.warehouse.dir
|file:/Users/dhyun/SPARK-SORTED-SET/spark-warehouse
|
|spark.app.id |local-1484333925649
|
|spark.app.name |Spark shell
|
|spark.driver.host |10.22.16.140
|
|spark.driver.memory |4G
|
|spark.driver.port |64994
|
|spark.executor.id |driver
|
|spark.home |/Users/dhyun/SPARK-SORTED-SET
|
|spark.jars |
|
|spark.master |local[*]
|
|spark.repl.class.outputDir
|/private/var/folders/bl/67vhzgqs1ks88l92h8dy8_1r0000gp/T/spark-ca1cf43c-ebd3-4e14-8045-0dd92419ef32/repl-006cff8e-fb82-4f18-9485-9fa9f91a2051|
|spark.repl.class.uri |spark://10.22.16.140:64994/classes
|
|spark.sql.catalogImplementation|hive
|
|spark.submit.deployMode |client
|
+-------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------+
{code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
