[ https://issues.apache.org/jira/browse/HIVE-27454?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17744081#comment-17744081 ]
Ayush Saxena commented on HIVE-27454: ------------------------------------- Committed to master. Thanx [~dkuzmenko] for the review!!! > Iceberg: Allow expire snapshots by id > ------------------------------------- > > Key: HIVE-27454 > URL: https://issues.apache.org/jira/browse/HIVE-27454 > Project: Hive > Issue Type: Improvement > Reporter: Ayush Saxena > Assignee: Ayush Saxena > Priority: Major > Labels: pull-request-available > > As of now we allow only expiring snapshots older that x timestamp. Allow > expiring snapshots with ID > Proposed new Syntax > *(Support Snapshot ID)* > Alter Table <table Name> Execute Expire_SNAPSHOT(‘<Snapshot Id>‘) > *(Snapshot ID List)* > Alter Table <table Name> Execute Expire_SNAPSHOT('<Snapshot Id1>,<Snapshot > Id2>... ') -- This message was sent by Atlassian Jira (v8.20.10#820010)