[GitHub] [doris] xzj7019 commented on issue #18646: [Enhancement] filter on row_number() can be pushed down below the window

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

xzj7019 commented on issue #18646:
URL: https://github.com/apache/doris/issues/18646#issuecomment-1512366225

   1. > or >= isn't for this optimization.
   2. if partition by order by pattern is preferred to be handled, window type needs to be specified to be UNBOUNDED to CURRENT.
   3. better to collect other similar win func into scope, such as count, percent_rank, cume_dist, which are aligned with partition topn semantics, and rank and dense_rank, which are aligned with partition topn-with-ties semantics.
   4. for fe side, it seems that putting the filter expr into winfunc desc is a necessary and leave the rest to be.
   5. seems that order by rk limit n is similar with the filter condition on rk, but with a lower priority.


-- 
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: commits-unsubscribe@doris.apache.org

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


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org