[
https://issues.apache.org/jira/browse/HIVE-26151?focusedWorklogId=759840&page=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-759840
]
ASF GitHub Bot logged work on HIVE-26151:
-----------------------------------------
Author: ASF GitHub Bot
Created on: 21/Apr/22 08:44
Start Date: 21/Apr/22 08:44
Worklog Time Spent: 10m
Work Description: marton-bod commented on PR #3222:
URL: https://github.com/apache/hive/pull/3222#issuecomment-1104888421
Let's keep this open for now until the final syntax has been determined
Issue Time Tracking
-------------------
Worklog Id: (was: 759840)
Time Spent: 1h 50m (was: 1h 40m)
> 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: 1h 50m
> 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)
