LYL41011 opened a new issue, #9106: URL: https://github.com/apache/seatunnel/issues/9106
### Search before asking - [x] I had searched in the [issues](https://github.com/apache/seatunnel/issues?q=is%3Aissue+label%3A%22bug%22) and found no similar issues. ### What happened I am using SeaTunnel to synchronize data from Hive to MySQL. I have configured the batch_size for the JDBC sink, but this parameter does not take effect. In the backend, I see that records are being inserted one by one. ### SeaTunnel Version 2.3.8 ### SeaTunnel Config ```conf env { execution.parallelism = 1 job.mode = "BATCH" } source{ Hive{ table_name = "dp_data_db.gds_stang_loan_vintage_v2_xian_yq" metastore_uri = "${hiveMeta}" } } sink { jdbc { url = "jdbc:mysql://xx.xx.xx.xx:xxx/test?useUnicode=true&characterEncoding=utf-8" driver = "com.mysql.cj.jdbc.Driver" database = "test" table = "xxx" user = "liu_test" password = "liu_test@0&cc" batch_size = 5000 query = "INSERT INTO gds_stang_loan_vintage_v2_xian_yq (product_2, province, city, createmonth, rp_day, amt, nbr, remain_amt, huishou_1, huishou_2, huishou_3, huishou_4, huishou_5, huishou_6, huishou_7, hs_1, remain_amt_1, remain_amt_2, remain_amt_3, remain_amt_4, remain_amt_5, remain_amt_6, remain_amt_7, huishou_30, remain_amt_30, amt_7, updateday) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)" } } ``` ### Running Command ```shell ${FLINK_HOME}/bin/flink run -m yarn-cluster -c org.apache.seatunnel.core.starter.flink.SeaTunnelFlink /home/q/dis/apache-seatunnel-2.3.8/starter/seatunnel-flink-13-starter.jar --config st_hive2mysql_test.txt --name SeaTunnel ``` ### Error Exception ```log no error ``` ### Zeta or Flink or Spark Version _No response_ ### Java or Scala Version _No response_ ### Screenshots _No response_ ### Are you willing to submit PR? - [ ] Yes I am willing to submit a 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]
