Yuming Wang created SPARK-31561:
-----------------------------------
Summary: Add QUALIFY Clause
Key: SPARK-31561
URL: https://issues.apache.org/jira/browse/SPARK-31561
Project: Spark
Issue Type: Improvement
Components: SQL
Affects Versions: 3.1.0
Reporter: Yuming Wang
In a SELECT statement, the QUALIFY clause filters the results of window
functions.
QUALIFY does with window functions what HAVING does with aggregate functions
and GROUP BY clauses.
In the execution order of a query, QUALIFY is therefore evaluated after window
functions are computed.
Examples:
https://docs.snowflake.com/en/sql-reference/constructs/qualify.html#examples
More details:
https://docs.snowflake.com/en/sql-reference/constructs/qualify.html
https://docs.teradata.com/reader/2_MC9vCtAJRlKle2Rpb0mA/19NnI91neorAi7LX6SJXBw
--
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
