[CALCITE-5268] Add QUALIFY clause - ASF JIRA

XML

Word

Printable

JSON

QUALIFY is to Window functions what HAVING is to GROUP BY.

For example:

SELECT a, b, c, ROW_NUMBER() OVER (PARTITION BY b ORDER BY c) as row_num
FROM t1
QUALIFY row_num = 1

Is the same as:

SELECT *
FROM (
    SELECT a, b, c, ROW_NUMBER() OVER (PARTITION BY b ORDER BY c) as row_num
    FROM t1)
WHERE row_num = 1

links to

GitHub Pull Request #2953

Estimated:

Not Specified

Remaining:

Logged:

2h 40m