[jira] [Created] (IMPALA-10840) Add support for "FOR SYSTEM_TIME AS OF" and "FOR SYSTEM_VERSION AS OF" for Iceberg tables

["Zoltán Borók-Nagy (Jira)" <ji...@apache.org>]

Zoltán Borók-Nagy created IMPALA-10840:
------------------------------------------

             Summary: 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


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