You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@flink.apache.org by cr...@gmail.com on 2020/04/10 19:13:54 UTC

Temporal Table Function in SQL

Hi

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

Thanks

Re: Temporal Table Function in SQL

Posted by Benchao Li <li...@gmail.com>.

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

<cr...@gmail.com> 于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



-- 

Benchao Li
School of Electronics Engineering and Computer Science, Peking University
Tel:+86-15650713730
Email: libenchao@gmail.com; libenchao@pku.edu.cn