liunaijie opened a new issue, #7293: URL: https://github.com/apache/seatunnel/issues/7293
### 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 try to use jbdc(mysql) to extract data from starrocks. it's a big query, if run the query directly, will get `timeout over 300s` exception. it's throw by starrocks. so i want split the query to multiple small query. i add `partition_column` parameter. but i find the jdbc default split logical add this query filter ` abs(md5(<partition_column>)) % <partition_num> = ? ` the finial query would be ``` select * from ( user defined query ) split where abs(md5(<partition_column>)) % <partition_num> = ? ``` in mysql the result of `md5 % <partition_num>` is a number, so it can work. but in starrocks, it can't work. we need use `md5sum_numeric` function. ### SeaTunnel Version 2.3.5 ### SeaTunnel Config ```conf { "password" : "", "driver" : "com.mysql.cj.jdbc.Driver", "query" : "xxxxxx", "connection_check_timeout_sec" : 100, "fetch_size" : 10000, "partition_column" : "data_day", -- string type "result_table_name" : "", "plugin_name" : "Jdbc", "user" : "xxx", "url" : "jdbc:mysql://xxx" } ``` ### Running Command ```shell rest api to submit job ``` ### Error Exception ```log no exception, and no data readed ``` ### Zeta or Flink or Spark Version _No response_ ### Java or Scala Version _No response_ ### Screenshots _No response_ ### Are you willing to submit PR? - [X] 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]
