1、错误详情
Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary.
2、问题原因
使用了最新的mysql连接驱动,现在按照最新官方提示支持将com.mysql.jdbc.Driver 改为 com.mysql.cj.jdbc.Driver
3、解决方案
写sql时指定driver= com.mysql.cj.jdbc.Driver
CREATE TABLE sink_order (
`date` STRING , --保留关键字需要用飘号引起来
`language` STRING ,
current_length INT ,
category_level1 ARRAY<STRING> , --数组需要指定类型
id INT ,
option MAP<STRING,STRING> --MAP需要指定类型
) WITH (
connector = jdbc
driver = com.mysql.cj.jdbc.Driver
url = jdbc:mysql://127.0.0.1:3306/test
username= root
password= 123456
table-name = sink_table_01