You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@hive.apache.org by "Marton Bod (Jira)" <ji...@apache.org> on 2022/04/19 13:18:00 UTC

[jira] [Assigned] (HIVE-26151) Support range-based time travel queries for Iceberg

     [ https://issues.apache.org/jira/browse/HIVE-26151?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Marton Bod reassigned HIVE-26151:
---------------------------------


> 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
>
> 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)