[ https://issues.apache.org/jira/browse/HIVE-26151?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
ASF GitHub Bot updated HIVE-26151: ---------------------------------- Labels: pull-request-available (was: ) > 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 > Priority: Major > Labels: pull-request-available > Time Spent: 10m > Remaining Estimate: 0h > > 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)