RussellSpitzer opened a new issue #3297:
URL: https://github.com/apache/iceberg/issues/3297


   Currently we have found that there is some utility in being able to get all 
the snapshot ancestors of a particular snapshot. This information can be 
obtained using 
   
   
https://github.com/apache/iceberg/blob/d9ab0babd2de7c5d3dc14e8f458bd1020a14329e/core/src/main/java/org/apache/iceberg/util/SnapshotUtil.java#L77-L89
   
   But there is no way to get this information from SQL directly. I was 
thinking we may benefit from exposing this, and several other functions as 
stored procedures for SQL use.
   
   Something like
   
   ```SQL
   CALL ice_cat.system.ancestorsOf(table, snapshotId = currentSnapshot)
   | snapshotId |
   | 3                |
   | 2                 |
   | 1                 |
   ```
   


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