Marton Bod created HIVE-26151: --------------------------------- Summary: Support range-based time travel queries for Iceberg Key: HIVE-26151 URL: https://issues.apache.org/jira/browse/HIVE-26151 Project: Hive Issue Type: New Feature Reporter: Marton Bod Assignee: Marton Bod
Allow querying which records have been inserted during a certain time window for Iceberg tables. The Iceberg TableScan API provides an implementation for that, so most of the work would go into adding syntax support and transporting the startTime and endTime parameters to the Iceberg input format. Proposed new syntax: SELECT * FROM table FOR SYSTEM_TIME FROM '<startTime>' TO '<endTime>' SELECT * FROM table FOR SYSTEM_VERSION FROM <startVersion> TO <endVersion> (the TO clause is optional in both cases) -- This message was sent by Atlassian Jira (v8.20.7#820007)