You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues-all@impala.apache.org by "Zoltán Borók-Nagy (Jira)" <ji...@apache.org> on 2021/09/10 16:09:00 UTC
[jira] [Resolved] (IMPALA-10840) Add support for "FOR SYSTEM_TIME
AS OF" and "FOR SYSTEM_VERSION AS OF" for Iceberg tables
[ https://issues.apache.org/jira/browse/IMPALA-10840?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Zoltán Borók-Nagy resolved IMPALA-10840.
----------------------------------------
Fix Version/s: Impala 4.1.0
Resolution: Fixed
> Add support for "FOR SYSTEM_TIME AS OF" and "FOR SYSTEM_VERSION AS OF" for Iceberg tables
> -----------------------------------------------------------------------------------------
>
> Key: IMPALA-10840
> URL: https://issues.apache.org/jira/browse/IMPALA-10840
> Project: IMPALA
> Issue Type: Sub-task
> Components: Frontend
> Reporter: Zoltán Borók-Nagy
> Assignee: Zoltán Borók-Nagy
> Priority: Major
> Labels: impala-iceberg
> Fix For: Impala 4.1.0
>
>
> SQL11 introduced a couple of temporal features:
> https://cs.ulb.ac.be/public/_media/teaching/infoh415/tempfeaturessql2011.pdf
> One of them is FOR SYSTEM_TIME AS OF which can be part of the table reference:
> https://jakewheat.github.io/sql-overview/sql-2011-foundation-grammar.html#query-system-time-period-specification
> With this extension the users are able to query the table at a given time point.
> HIVE-25344 also added support for this. It also adds another, non-standard clause: FOR SYSTEM_VERSION AS OF.
> In Impala we should add both to support time travel for Iceberg tables.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-all-unsubscribe@impala.apache.org
For additional commands, e-mail: issues-all-help@impala.apache.org