[I] Further Optimize "per partition" top-k : `ROW_NUMBER < 5` / TopK [datafusion]

["alamb (via GitHub)" <gi...@apache.org>]

alamb opened a new issue, #24060:
URL: https://github.com/apache/datafusion/issues/24060

   This ticket track the follow on work from 
   - https://github.com/apache/datafusion/issues/6899
   
   Where @SubhamSinghal and others have implemented specific optimizations for queries such as this (topK per partition)
   
   ```sql
   SELECT ...
     ROW_NUMBER() OVER (PARTITION BY value1, ORDER BY value2) as rn
   WHERE
     rn < 10
   ```
   
   We closed https://github.com/apache/datafusion/issues/6899 to signal we have implemented the first part of the operator; This ticket tracks further optimizations
   
   - [ ] https://github.com/apache/datafusion/issues/21594
   - [ ] https://github.com/apache/datafusion/issues/21596 / https://github.com/apache/datafusion/pull/23599
   - [ ] https://github.com/apache/datafusion/issues/13586
   
   


-- 
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-unsubscribe@datafusion.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: github-unsubscribe@datafusion.apache.org
For additional commands, e-mail: github-help@datafusion.apache.org