haohuaijin opened a new pull request, #16933: URL: https://github.com/apache/datafusion/pull/16933
## Which issue does this PR close? Closes #15485 ## Rationale for this change see https://github.com/apache/datafusion/issues/15485, support `qualify` can filter windows function's result without use subquery before ```sql with ranked as ( select row_number() over (PARTITION BY region) as rk from t ) select * from ranked where rk > 1; ``` after ```sql select row_number() over (PARTITION BY region) as rk from t qualify rk > 1; ``` ## What changes are included in this PR? support the `qualify` clause like what we do for `having` clause ## Are these changes tested? yes, add integration test and sqllogictest test ## Are there any user-facing changes? It is easier to filter the windows function's result -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: github-unsubscr...@datafusion.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: github-unsubscr...@datafusion.apache.org For additional commands, e-mail: github-h...@datafusion.apache.org
