[SPARK-28428] Spark `exclude` always expecting `()`

• Type: Sub-task
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 3.1.0
• Component/s: SQL, Tests
• Assignee: Unassigned
• Reporter: Dylan Guedes
• Created: 17/Jul/19 18:06
• Updated: 29/Mar/20 02:23

Description

SparkSQL `exclude` always expects a following call to `()`, however, PgSQL `exclude` does not. Examples:

SELECT sum(unique1) over (rows between 2 preceding and 2 following exclude no others),
unique1, four
FROM tenk1 WHERE unique1 < 10;