FLINK 连接 mysql

最新推荐文章于 2024-11-12 23:17:54 发布

原创最新推荐文章于 2024-11-12 23:17:54 发布 · 435 阅读

0 ·

CC 4.0 BY-SA版权

我们不生产知识，我们只是互联网的搬运工

文章标签：

#flink #mysql

依赖

pipeline.jars=file:///work/lib/flink-connector-jdbc-3.2.0-1.19.jar;file:///work/lib/mysql-connector-java-5.1.49.jar

SQL

CREATE CATALOG mydb WITH(
    'type' = 'jdbc',
    'default-database' = 'dbname',
    'username' = 'root',
    'password' = 'mysqlisthebest',
    'base-url' = 'jdbc:mysql://10.xxx.xxx.xxx:3306'
);

CREATE TABLE mytable
LIKE mydb.dbname.mytable;


-- 设置jdbc连接参数，防止写入中文乱码
CREATE TABLE  mytable2
WITH (
'url' = 'jdbc:mysql://10.xxx.xxx.xxx:3306/dbname?useUnicode=true&characterEncoding=UTF8'
)
LIKE mydb.dbname.mytable2;