[SPARK-28566] window functions should not be allowed in window definitions

• Type: Sub-task
• Status: Resolved
• Priority: Major
• Resolution: Won't Fix
• Affects Version/s: 3.0.0
• Component/s: SQL
• Assignee: Unassigned
• Reporter: Dylan Guedes
• Created: 30/Jul/19 17:21
• Updated: 13/Sep/19 17:40
• Resolved: 13/Sep/19 17:40

Description

Currently, Spark allows the usage of window functions inside window definitions, such as:

 SELECT rank() OVER (ORDER BY rank() OVER (ORDER BY random()));

However, in PgSQL such behavior is now allowed:

postgres=# SELECT rank() OVER (ORDER BY rank() OVER (ORDER BY random()));
ERROR:  window functions are not allowed in window definitions
LINE 1: SELECT rank() OVER (ORDER BY rank() OVER (ORDER BY random())...