[SPARK-28010] Support ORDER BY ... USING syntax

• Type: Sub-task
• Status: Resolved
• Priority: Major
• Resolution: Workaround
• Affects Version/s: 3.0.0
• Component/s: SQL
• Assignee: Unassigned
• Reporter: Lantao Jin
• Created: 12/Jun/19 03:14
• Updated: 29/Mar/20 02:31
• Resolved: 29/Mar/20 02:31

Description

Currently, SparkSQL ORDER BY is below:

ORDER BY expression [ ASC | DESC]
SELECT * FROM tab ORDER BY col ASC

 
Can SparkSQL support grammar like below, as PostgreSQL ORDER BY:

ORDER BY expression [ ASC | DESC | USING operator ]
SELECT * FROM tab ORDER BY col USING <