chenhaonan313 opened a new issue, #2930: URL: https://github.com/apache/incubator-streampark/issues/2930
### Search before asking - [X] I had searched in the [issues](https://github.com/apache/incubator-streampark/issues?q=is%3Aissue+label%3A%22bug%22) and found no similar issues. ### Java Version 1.8 ### Scala Version 2.12.x ### StreamPark Version 2.1.1 ### Flink Version 1.14.5 ### deploy mode remote ### What happened When you insert data into mysql using flink sql, a message is displayed indicating that the table does not exist. Creating and storing data using flink sql does not take effect ### Error Exception _No response_ ### Screenshots CREATE TABLE user_log ( user_id VARCHAR, item_id VARCHAR, category_id VARCHAR, behavior VARCHAR, ts TIMESTAMP(3) ) WITH ( 'connector' = 'kafka', 'topic' = 'user_behavior', 'properties.bootstrap.servers'='10.100.0.44:9092', 'scan.startup.mode' = 'earliest-offset', 'format' = 'json' ); CREATE TABLE pvuv_sink ( dt VARCHAR, pv BIGINT, uv BIGINT, PRIMARY KEY (dt,pv,uv) NOT ENFORCED ) WITH ( 'connector' = 'jdbc', 'url' = 'jdbc:mysql://10.100.0.33:6306/test?useSSL=false', 'table-name' = 'pvuv_sink', 'username' = 'root', 'password' = 'aMnTFmW7-ac%', 'sink.buffer-flush.max-rows' = '1' ); INSERT INTO pvuv_sink SELECT DATE_FORMAT(ts, 'yyyy-MM-dd HH:00') dt, COUNT(*) AS pv, COUNT(DISTINCT user_id) AS uv FROM user_log GROUP BY DATE_FORMAT(ts, 'yyyy-MM-dd HH:00'); ### Are you willing to submit PR? - [X] Yes I am willing to submit a PR!(您是否要贡献这个PR?) ### Code of Conduct - [X] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct) -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
