Details
-
Sub-task
-
Status: Resolved
-
Major
-
Resolution: Fixed
-
None
-
ghx-label-14
Description
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.
Attachments
Issue Links
- is related to
-
IMPALA-9773 Kudu temporal (AS OF) queries
- Open