mymeiyi opened a new issue, #31348:
URL: https://github.com/apache/doris/issues/31348

   ### Search before asking
   
   - [X] I had searched in the 
[issues](https://github.com/apache/doris/issues?q=is%3Aissue) and found no 
similar issues.
   
   
   ### Description
   
   When drop db/table/partition, the catalog recycle bin will delete them after 
`catalog_trash_expire_second`(in `fe.conf`) seconds. We can provide a new 
command to delete them to free disk usage timely.
   
   Since the name of db/table/partition is repeatable, maybe we can delete them 
by id, the commands are like:
   ```
   // drop the database, table and partition with the specified db_id
   drop catalog recycle bin where 'DbId' = '';
   
   // drop the table and partition with the specified table_id
   drop catalog recycle bin where 'TableId' = '';
   
   // drop the partition with the specified partition_id
   drop catalog recycle bin where 'PartitionId' = '';
   ```
   
   ### Solution
   
   _No response_
   
   ### Are you willing to submit PR?
   
   - [ ] Yes I am willing to submit a PR!
   
   ### Code of Conduct
   
   - [X] I agree to follow this project's [Code of 
Conduct](https://www.apache.org/foundation/policies/conduct)
   


-- 
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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to