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)

Reply via email to