flink sql连接mysql

• [ERROR] Could not execute SQL statement. Reason:
  org.apache.flink.table.api.ValidationException: Could not find any factory for identifier ‘com.mysql.jdbc.Driver’ that implements ‘org.apache.flink.table.factories.DynamicTableSourceFactory’ in the classpath.
  Available factory identifiers are:
  datagen

[ERROR] Could not execute SQL statement. Reason: org.apache.flink.table.api.ValidationException: Unsupported options found for connector 'jdbc'.

Unsupported options:

database-name
hostname
port

Supported options:

connector
driver
lookup.cache.max-rows
lookup.cache.ttl
lookup.max-retries
password
property-version
scan.fetch-size
scan.partition.column
scan.partition.lower-bound
scan.partition.num
scan.partition.upper-bound
sink.buffer-flush.interval
sink.buffer-flush.max-rows
sink.max-retries
table-name
url
username

解决方案

drop table if exists  bill_info;
CREATE TABLE bill_info (
  billCode STRING,
  serviceCode STRING,
  accountPeriod STRING,
  subjectName STRING ,
  subjectCode STRING,
  occurDate TIMESTAMP,
  amt  DECIMAL(11,2),
  status STRING,
  proc_time AS PROCTIME() --使用维表时需要指定该字段
) WITH (
  'connector' = 'jdbc', -- 连接器
  'driver'='com.mysql.jdbc.Driver',
  --'hostname' = 'hadoop103',   --mysql地址
  --'port' = '3306',  -- mysql端口
  'username' = 'root',  --mysql用户名
  'password' = '123456',  -- mysql密码
  --'database-name' = 'cdc', --  数据库名称
  'table-name' = 'test0906',
  'url' = 'jdbc:mysql://hadoop103:3306/cdc'
);