liunaijie opened a new issue, #8767: URL: https://github.com/apache/seatunnel/issues/8767
### Search before asking - [x] I had searched in the [feature](https://github.com/apache/seatunnel/issues?q=is%3Aissue+label%3A%22Feature%22) and found no similar feature requirement. ### Description In JDBC connector. JDBC connector has a [parallel-reader](https://seatunnel.apache.org/docs/2.3.8/connector-v2/source/Jdbc#parallel-reader) feature. It can split the user big query to multiple small query. The generated sql pattern is like this: ``` select * from (user special sql) where md5(partition_col) % total_paraliam = current_paraliam_index ``` But there has a problem if the `user special sql` contains `sql hints`. For example, the user query is ``` SELECT /*+ SET_VAR(query_timeout = 6000) */ col_a, col_b from table_a ``` After sql re-generate, the executed sql would be ``` select * from ( SELECT /*+ SET_VAR(query_timeout = 6000) */ col_a, col_b from table_a ) xxxxx ``` Then the sql hint will be ignore. ### Usage Scenario _No response_ ### Related issues _No response_ ### Are you willing to submit a 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: commits-unsubscr...@seatunnel.apache.org.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org
