[GitHub] [arrow-datafusion] AssHero opened a new issue, #2822: eliminate multi limit-offset nodes to EmptyRelation if possible

[GitBox <gi...@apache.org>]

AssHero opened a new issue, #2822:
URL: https://github.com/apache/arrow-datafusion/issues/2822

   **Is your feature request related to a problem or challenge? Please describe what you are trying to do.**
   For such query: select * from (select * from xxxx limit n offset ..) a limit  n offset m;
   
   If outer offset(m) is greater than or equal to inner limit(n)，we can replace inner limit node with an [LogicalPlan::EmptyRelation].
   
   Generally, for logical plans,  if upper offset is greater than or equal to current limit, replace current limit with an [LogicalPlan::EmptyRelation].
   
   **Describe the solution you'd like**
   As above.
   
   **Describe alternatives you've considered**
   None
   
   **Additional context**
   None
   


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

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

[GitHub] [arrow-datafusion] alamb closed issue #2822: eliminate multi limit-offset nodes to EmptyRelation if possible

[GitBox <gi...@apache.org>]

alamb closed issue #2822: eliminate multi limit-offset nodes to EmptyRelation if possible 
URL: https://github.com/apache/arrow-datafusion/issues/2822


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

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