You are viewing a plain text version of this content. The canonical link for it is here.
Posted to github@datafusion.apache.org by "askalt (via GitHub)" <gi...@apache.org> on 2026/02/03 13:38:42 UTC

[PR] feat: support limited deletion [datafusion]

askalt opened a new pull request, #20137:
URL: https://github.com/apache/datafusion/pull/20137

   
   ## Rationale for this change
   
   We support `DELETE LIMIT` query and it would be good to port our fork patch to the upstream.
   
   <!--
    Why are you proposing this change? If this is already explained clearly in the issue then this section is not needed.
    Explaining clearly why changes are proposed helps reviewers understand your changes and offer better suggestions for fixes.  
   -->
   
   ## What changes are included in this PR?
   
   This patch adds a support for delete statement with limit planning. An inner table scan is wrapped with a limit in this case. e.g.:
   
   ```
   query TT
   explain delete from t1 limit 10
   ----
   logical_plan
   01)Dml: op=[Delete] table=[t1]
   02)--Limit: skip=0, fetch=10
   03)----TableScan: t1
   physical_plan
   01)CooperativeExec
   02)--DmlResultExec: rows_affected=0
   ```
   ## Are these changes tested?
   
   Covered with SLT.
   
   ## Are there any user-facing changes?
   
   Now queries with limited deletion are successfully planned, instead of returning not-supported error.
   


-- 
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

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

Re: [PR] feat: support limited deletion [datafusion]

Posted by "alamb (via GitHub)" <gi...@apache.org>.
alamb commented on PR #20137:
URL: https://github.com/apache/datafusion/pull/20137#issuecomment-3856480916

   Thanks again @askalt 


-- 
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

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

Re: [PR] feat: support limited deletion [datafusion]

Posted by "alamb (via GitHub)" <gi...@apache.org>.
alamb merged PR #20137:
URL: https://github.com/apache/datafusion/pull/20137


-- 
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

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