答:
以下是建表语句
CREATE TABLE activity(
code string,
title string,
proctime as PROCTIME()
)WITH (
'connector.url' = 'jdbc:mysql://192.168.100.100:3306/ylfin?useUnicode=true&characterEncoding=UTF-8&useSSL=false&autoReconnect=true&serverTimezone=GMT%2B8',
'connector.table' = 'activity',
'connector.type' = 'jdbc',
'connector.driver' = 'com.mysql.cj.jdbc.Driver',
'connector.lookup.cache.max-rows' = '10000',
'connector.lookup.cache.ttl' = '60s',
'connector.lookup.max-retries' = '3',
'connector.username' = 'root'," +
'connector.password' = 'hellomonitor')
关注
