参考官网 写相关sql,准备实现kafka-flink-sink to mysql,发现不报错,数据也写不到sink的mysql表中
-- register a MySQL table 'users' in Flink SQL
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' = 'users'
);
idea中运行直接正常退出了
把url后面加上相关参数后正常
‘url’ = ‘jdbc:mysql://localhost:3306/mydatabase?serverTimezone=UTC’,
说明:table-name/url/username/password等参数值写错,连不上要sink的表时,程序会直接结束,不会报错,很容易不知道哪出了问题,所以要仔细检查参数值
另外,要添加相关依赖,不然会报错
<dependency>
<groupId>org.apache.flink</groupId>
<artifactId>flink-connector-jdbc_2.11</artifactId>
<version>1.11.2</version>
</dependency>
参考:https://blog.csdn.net/superdangbo/article/details/78732700