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 2017/01/13 19:07:26 UTC

[jira] [Assigned] (SPARK-19218) SET command should show a sorted result

     [ https://issues.apache.org/jira/browse/SPARK-19218?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Apache Spark reassigned SPARK-19218:
------------------------------------

    Assignee: Apache Spark

> 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
>            Assignee: Apache Spark
>            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: issues-unsubscribe@spark.apache.org
For additional commands, e-mail: issues-help@spark.apache.org