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

• Type: Sub-task
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: Impala 4.1.0
• Component/s: Frontend
• Labels: impala-iceberg
• Epic Color: ghx-label-14
• Assignee: Zoltán Borók-Nagy
• Reporter: Zoltán Borók-Nagy
• Created: 04/Aug/21 16:54
• Updated: 10/Sep/21 16:08
• Resolved: 10/Sep/21 16:08

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.

Issue Links

• is related to: IMPALA-9773 Kudu temporal (AS OF) queries