Hi everyone, it would be very useful if temporal tables could be created via DDL. Currently, users either need to do this in the Table API or in the environment file of the Flink CLI, which both require the user to switch the context of the SQL CLI/Editor. I recently created a ticket for this request [1].
I see two main questions: 1) What would be the DDL syntax? A Temporal Table is on the one hand a view and on the other a function depending on how you look at it. 2) Would this temporal table view/function be stored in the catalog or only be temporary? I personally do not have much experience in this area of Flink, so I am looking forward to hearing your thoughts on this. Best, Konstantin [1] https://issues.apache.org/jira/browse/FLINK-16824 -- Konstantin Knauf