FlinkSQL连接JDBC

运行FlinkSQL

./sql-client.sh embedded --jar /home/<username>/flink-connector-jdbc_2.11-1.11.0.jar --jar /home/<username>/mysql-connector-java-8.0.21.jar

创建表

CREATE TABLE test (
  a string,
  b int,
  c string,
  PRIMARY KEY (a) NOT ENFORCED
) WITH (
   'connector' = 'jdbc',
   'url' = 'jdbc:mysql://ip:port/<database>',
   'table-name' = '<tablename>',
   'username' = '<username>',
   'password' = '<password>'
);

添加数据

insert into oil_type(a, b, c) values('111', 22, 'feng');
insert into oil_type(a, b, c) values('111', 22, 'feng2');

查询表

select * from test;