You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user-zh@flink.apache.org by Asahi Lee <97...@qq.com> on 2021/05/19 06:01:37 UTC

flink 1.13.0 ,使用flink sql 链接数据库是否支持多模式,即表名为schema.name

hi!
&nbsp; &nbsp; &nbsp; flink jdbc 是否有考虑支持表基于模式查询?如下 table-name写法:
CREATE TABLE MyUserTable (   id BIGINT,   name STRING,   age INT,   status BOOLEAN,   PRIMARY KEY (id) NOT ENFORCED ) WITH (    'connector' = 'jdbc',    'url' = 'jdbc:mysql://localhost:3306/mydatabase',    'table-name' = 'org.users' );

Re: flink 1.13.0 ,使用flink sql 链接数据库是否支持多模式,即表名为schema.name

Posted by Shengkai Fang <fs...@gmail.com>.
请问是要用正则表达式匹配数据库中的table吗?‘org.users’ 是一个正则表达式吗?

Best,
Shengkai

Asahi Lee <97...@qq.com> 于2021年5月19日周三 下午2:01写道:

> hi!
> &nbsp; &nbsp; &nbsp; flink jdbc 是否有考虑支持表基于模式查询?如下 table-name写法:
> CREATE TABLE MyUserTable (   id BIGINT,   name STRING,   age INT,   status
> BOOLEAN,   PRIMARY KEY (id) NOT ENFORCED ) WITH (    'connector' = 'jdbc',
>   'url' = 'jdbc:mysql://localhost:3306/mydatabase',    'table-name' =
> 'org.users' );