[
https://issues.apache.org/jira/browse/HIVE-26151?focusedWorklogId=759316&page=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-759316
]
ASF GitHub Bot logged work on HIVE-26151:
-----------------------------------------
Author: ASF GitHub Bot
Created on: 20/Apr/22 15:26
Start Date: 20/Apr/22 15:26
Worklog Time Spent: 10m
Work Description: marton-bod commented on PR #3222:
URL: https://github.com/apache/hive/pull/3222#issuecomment-1104065890
The syntax should be marked experimental/alpha with evolving-semantics here.
The problem is that FROM ... TO has a different semantics in standard SQL, it
returns all rows that were active during the time window (so it can contain
rows that were inserted before the time window), instead of just the appends
that happened during the window. Let's discuss it tomorrow, but we might want
to come up with a way to document it that this alpha/experimental at this stage.
Issue Time Tracking
-------------------
Worklog Id: (was: 759316)
Time Spent: 1h 40m (was: 1.5h)
> 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 40m
> 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)
