【Flink】 IllegalArgumentException: open() failed.The server time zone value ‘�й��׼ʱ��‘

一杯咖啡半杯糖

已于 2022-12-07 17:31:51 修改

阅读量2.1k

点赞数

分类专栏： Flink实战文章标签： flink mysql big data

于 2021-11-16 18:23:00 首次发布

本文链接：https://blog.csdn.net/sinat_23225111/article/details/121362041

版权

Flink实战专栏收录该内容

95 篇文章 118 订阅 ¥19.90 ¥99.00

订阅专栏

超级会员免费看

博客内容讲述了在使用Flink连接MySQL时遇到的异常问题，具体表现为IllegalArgumentException，原因是服务器时区设置不正确。作者提供了解决此问题的方法，涉及调整URL参数。

摘要由CSDN通过智能技术生成

Caused by: java.lang.IllegalArgumentException: open() failed.The server time zone value '�й���׼ʱ��' is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver (via the serverTimezone configuration property) to use a more specifc time zone value if you want to utilize time zone support.
	at org.apache.flink.connector.jdbc.table.JdbcRowDataInputFormat.openInputFormat(JdbcRowDataInputFormat.java:118)
	at org.apache.flink.streaming.api.functions.source.InputFormatSourceFunction.run(InputFormatSourceFunction.java:79)
	at org.apache.flink.streaming.api.operators.StreamSource.run(StreamSource.java:110)
	at org.apache.flink.streaming.api.operators.StreamSource.run(StreamSource.java:66)
	at