[
https://issues.apache.org/jira/browse/FLINK-12025?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16803788#comment-16803788
]
Piotr Nowojski commented on FLINK-12025:
----------------------------------------
Our current solution with table functions is a stop gap until calcite supports
{{FOR SYSTEM_TIME AS OF field_reference}}. This {{field_reference}} is the
important bit. If that's so, then supporting this syntax for temporal tables
and temporal table joins is a logical next step.
I guess this would require couple of things.
1. Frontend/api/table definitions changes (Currently temporal tables are
expressed/registered as table functions). With {{FOR SYSTEM_TIME}} syntax there
will be alternate way of accessing them.
2. adding a rewrite rule from {{FOR SYSTEM_TIME AS OF field_reference}} plan to
temporal table join
> Support FOR SYSTEM_TIME AS OF in temporal table
> -----------------------------------------------
>
> Key: FLINK-12025
> URL: https://issues.apache.org/jira/browse/FLINK-12025
> Project: Flink
> Issue Type: New Feature
> Components: Table SQL / API
> Reporter: vinoyang
> Assignee: vinoyang
> Priority: Major
>
> Since Calcite 1.19 has been released and "FOR SYSTEM_TIME AS OF" been
> supported. I suggest we can support it in the temporal table.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
