You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@spark.apache.org by "Yuming Wang (JIRA)" <ji...@apache.org> on 2019/07/10 08:07:00 UTC
[jira] [Commented] (SPARK-28010) Support ORDER BY ... USING syntax
[ https://issues.apache.org/jira/browse/SPARK-28010?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16881820#comment-16881820 ]
Yuming Wang commented on SPARK-28010:
-------------------------------------
{{ASC}} is usually equivalent to {{USING <}} and {{DESC}} is usually equivalent to {{USING >}}.
https://www.postgresql.org/docs/11/sql-select.html
> Support ORDER BY ... USING syntax
> ---------------------------------
>
> Key: SPARK-28010
> URL: https://issues.apache.org/jira/browse/SPARK-28010
> Project: Spark
> Issue Type: Sub-task
> Components: SQL
> Affects Versions: 3.0.0
> Reporter: Lantao Jin
> Priority: Major
>
> Currently, SparkSQL ORDER BY is below:
> {code:sql}
> ORDER BY expression [ ASC | DESC]
> SELECT * FROM tab ORDER BY col ASC
> {code}
>
> Can SparkSQL support grammar like below, as PostgreSQL ORDER BY:
> {code:sql}
> ORDER BY expression [ ASC | DESC | USING operator ]
> SELECT * FROM tab ORDER BY col USING <
> {code}
>
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@spark.apache.org
For additional commands, e-mail: issues-help@spark.apache.org