ViaGuai opened a new issue, #9797: URL: https://github.com/apache/seatunnel/issues/9797
### 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 Source单表使用query时，sql里可以使用占位符传递参数，但是 table_list = [{},{}]时，query的sql占位符无法传递参数 ### SeaTunnel Version Version：2.3.11 ### SeaTunnel Config ```conf env { job.name = "oa2doris" # 任务名称 job.mode = "BATCH" # 任务模式：批 job.retry.times = 3 # 任务失败重试次数：3次 job.retry.interval.seconds = 5 # 任务失败重试间隔：3s parallelism = 8 # 任务并行度：3 # read_limit.bytes_per_second=10240000 # 每个并行度每秒读取的最大bytes：10240000 bytes = 10M # read_limit.rows_per_second=10000 # 每个并行度每秒读取的最大行数：400行 } source { Jdbc { plugin_output = "source_result" url = ${DB_OA_ORACLE_URL} driver = ${DB_OA_ORACLE_DRIVER} connection_check_timeout_sec = 100 user = ${DB_OA_ORACLE_USER} password = ${DB_OA_ORACLE_PASSWORD} table_list = [ { table_path = "myoa.km_review_main", query = """ select fd_id,sysdate as etl_time from myoa.km_review_main t WHERE GREATEST(fd_last_modified_time, doc_create_time)>=TRUNC(sysdate-${inc_offset_days}) """ }, { table_path = "myoa.lbpm_audit_note", query = """ select fd_id,fd_notify_type,sysdate as etl_time from myoa.lbpm_audit_note t WHERE FD_CREATE_TIME>=TRUNC(sysdate-${inc_offset_days}) """ } ] partition_num = 8 } } sink { Doris { } } ``` ### Running Command ```shell ${SEATUNNEL_HOME}/bin/seatunnel.sh --config go/oa2doris_inc.conf --deploy-mode local -i inc_offset_days=1 ``` ### Error Exception ```log 无法传递参数，导致oracle sql查询时 ORA-00911: 无效字符 ``` ### Zeta or Flink or Spark Version Zeta ### Java or Scala Version java1.8 ### 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]
