Details
-
New Feature
-
Status: Closed
-
Major
-
Resolution: Fixed
-
None
-
None
Description
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
Attachments
Issue Links
- relates to
-
CALCITE-6691 Qualify expressions not updated when merging two Project
- In Progress
- links to