Temporal Table Function in SQL

[craftmantel]

Hi

Is it possible to create a Temporal Table and a Temporal Table Function from the SQL API? Any example of DDL?

Thanks

[Benchao Li]

Hi,

- Temporal Table 

It is implemented as dimension table, you can define a dimension table using DDL, for example, JDBC [1].

- Temporal Table Function 

Currently it cannot created from pure SQL, you can create it through table api[2], and then use it in sql.

[1] https://ci.apache.org/projects/flink/flink-docs-master/dev/table/connect.html#jdbc-connector

[2] https://ci.apache.org/projects/flink/flink-docs-master/dev/table/streaming/temporal_tables.html#defining-temporal-table-function

<[hidden email]> 于2020年4月11日周六 上午3:14写道：

Hi

Is it possible to create a Temporal Table and a Temporal Table Function from the SQL API? Any example of DDL?

Thanks

--