[SPARK-28333] NULLS FIRST for DESC and NULLS LAST for ASC

• Type: Sub-task
• Status: Resolved
• Priority: Major
• Resolution: Won't Do
• Affects Version/s: 3.0.0
• Component/s: SQL
• Assignee: Unassigned
• Reporter: Yuming Wang
• Created: 10/Jul/19 11:30
• Updated: 29/Dec/19 05:36
• Resolved: 31/Jul/19 17:26

Description

spark-sql> create or replace temporary view t1 as select * from (values(1), (2), (null), (3), (null)) as v (val);
spark-sql> select * from t1 order by val asc;
NULL
NULL
1
2
3
spark-sql> select * from t1 order by val desc;
3
2
1
NULL
NULL

postgres=# create or replace temporary view t1 as select * from (values(1), (2), (null), (3), (null)) as v (val);
CREATE VIEW
postgres=# select * from t1 order by val asc;
 val
-----
   1
   2
   3


(5 rows)

postgres=# select * from t1 order by val desc;
 val
-----


   3
   2
   1
(5 rows)

https://www.postgresql.org/docs/11/queries-order.html

Issue Links

• links to: GitHub Pull Request #25147