[HIVE-25344] Add a possibility to query Iceberg table snapshots based on the timestamp or the snapshot id

• Type: New Feature
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 4.0.0-alpha-1
• Labels: pull-request-available
• Assignee: Peter Vary
• Reporter: Peter Vary
• Created: 19/Jul/21 10:34
• Updated: 17/Nov/22 08:47
• Resolved: 28/Jul/21 16:38

Description

Implement the following commands:

SELECT * FROM t FOR SYSTEM_TIME AS OF <timestamp>;
SELECT * FROM t FOR SYSTEM_VERSION AS OF <version>;

where SYSTEM_TIME is the Iceberg table state at the given timestamp (UTC), or SYSTEM_VERSION is the Iceberg table snapshot id.

Issue Links

• links to: GitHub Pull Request #2512