SteveStevenpoor opened a new issue, #16314:
URL: https://github.com/apache/iceberg/issues/16314

   ### Feature Request / Improvement
   
   ### Motivation
   Apache Flink supports [CALL sql 
statements](https://nightlies.apache.org/flink/flink-docs-master/docs/sql/reference/utility/call/)
 to call a stored procedure which can perform administrative tasks. I want to 
implement something similar to [Paimon's 
procedures](https://paimon.apache.org/docs/master/flink/procedures/) in Iceberg.
   
   The idea is to make snapshot references easier to manage directly from Flink 
SQL.
   
   ### Implemented procedures
   - `create_tag`
   - `delete_tag`
   - `create_tag_from_timestamp`
   - `create_branch`
   - `delete_branch`
   - `rollback_to`
   - `rollback_to_timestamp`
   - `expire_snapshots`
   
   We can add more in the future, something like `rename_tag` or 
`list_snapshots` etc.
   
   ### Example usage
   `CALL sys.create_tag('tableId', 'tagName', snapshotId, 'timeRetained')`
   
   This made branch/tag workflows much more convenient in Flink SQL.
   
   ### Query engine
   
   Flink
   
   ### Willingness to contribute
   
   - [x] I can contribute this improvement/feature independently
   - [ ] I would be willing to contribute this improvement/feature with 
guidance from the Iceberg community
   - [ ] I cannot contribute this improvement/feature at this time


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