[
https://issues.apache.org/jira/browse/FLINK-9716?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17337167#comment-17337167
]
Jark Wu commented on FLINK-9716:
--------------------------------
[~twalthr], yes, this is a nice feature. Because data lakes usually allows to
query a table snapshot at a given time, and the {{FOR SYSTEM_TIME AS OF}}
syntax is a SQL standard way to do this, e.g. {{SELECT * FROM iceberg FOR
SYSTEM_TIME AS OF TIMESTAMP '2020-04-30 10:00:00'}}.
> Support scans from temporal table
> ---------------------------------
>
> Key: FLINK-9716
> URL: https://issues.apache.org/jira/browse/FLINK-9716
> Project: Flink
> Issue Type: New Feature
> Components: Table SQL / Planner
> Reporter: Piotr Nowojski
> Priority: Major
> Labels: auto-unassigned
>
> Given a temporal table of {{Rates}} this should work:
>
> {code:java}
> SELECT * FROM Rates AS SYSTEM TIME OF 2016-06-27 10:10:42.123
> {code}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
