Hi Konstantin, Thanks for bringing up this discussion. +1 for the idea. We have met this in our company too, and I planned to support it recently in our internal branch.
regarding to your questions, 1) I think it might be more a table/view than function, just like Temporal Table (which is also known as dimension table). Maybe we need a DDL like CREATE VIEW and plus some additional settings. 2) If we design the DDL for it like view, then maybe temporary is ok enough. Konstantin Knauf <kna...@apache.org> 于2020年4月16日周四 下午8:16写道: > 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 > -- Benchao Li School of Electronics Engineering and Computer Science, Peking University Tel:+86-15650713730 Email: libenc...@gmail.com; libenc...@pku.edu.cn