[ https://issues.apache.org/jira/browse/SPARK-28064?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17238662#comment-17238662 ]
Dylan Guedes commented on SPARK-28064: -------------------------------------- Sorry, my only intention was to help to map the differences between PostgreSQL and SparkSQL APIs. > Order by does not accept a call to rank() > ----------------------------------------- > > Key: SPARK-28064 > URL: https://issues.apache.org/jira/browse/SPARK-28064 > Project: Spark > Issue Type: Sub-task > Components: SQL > Affects Versions: 3.1.0 > Reporter: Dylan Guedes > Priority: Major > > Currently in Spark, we can't use a call to `rank()` in a order by; we need to > first rename the rank column to, for instance, `r` and then, use `order by > r`. For example: > This does not work: > {code:sql} > SELECT depname, empno, salary, rank() OVER w FROM empsalary WINDOW w AS > (PARTITION BY depname ORDER BY salary) ORDER BY rank() OVER w; > {code} > However, this one does: > {code:sql} > SELECT depname, empno, salary, rank() OVER w as r FROM empsalary WINDOW w AS > (PARTITION BY depname ORDER BY salary) ORDER BY r; > {code} > By the way, I took this one from Postgres behavior: postgres accept both ways. -- This message was sent by Atlassian Jira (v8.3.4#803005) --------------------------------------------------------------------- To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org