Dylan Guedes created SPARK-28648:
------------------------------------
Summary: Adds support to `groups` in window clauses
Key: SPARK-28648
URL: https://issues.apache.org/jira/browse/SPARK-28648
Project: Spark
Issue Type: Sub-task
Components: SQL
Affects Versions: 3.0.0
Reporter: Dylan Guedes
Spark currently support the two most common window functions unit types: rows
and ranges. However, in PgSQL a new type was added: `groups`.
According to [this
source|https://blog.jooq.org/2018/07/05/postgresql-11s-support-for-sql-standard-groups-and-exclude-window-function-clauses/],
the difference is:
"""ROWS counts the exact number of rows in the frame.
RANGE performs logical windowing where we don’t count the number of rows, but
look for a value offset.
GROUPS counts all groups of tied rows within the window."""
--
This message was sent by Atlassian JIRA
(v7.6.14#76016)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
