13813586515 opened a new issue, #10403:
URL: https://github.com/apache/seatunnel/issues/10403

   ### 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
   
   <img width="337" height="252" alt="Image" 
src="https://github.com/user-attachments/assets/8f440294-909b-4511-a536-a56b8a583d07";
 />
   
   <img width="1127" height="459" alt="Image" 
src="https://github.com/user-attachments/assets/5cf11bab-aeb4-4964-8b01-39eebd716480";
 />
   
   <!-- Uploading "image.png"... -->
   
按照https://seatunnel.apache.org/zh-CN/docs/2.3.10/transform-v2/sql-udf/,写了udf放到lib,运行提示找不到java.lang.ClassNotFoundException:
 
org.apache.seatunnel.api.common.CommonOptions这个类,而且我看了一下文档要求udf项目引入的seatunnel-api版本为2.3.2,但是在这个版本中的CommonOptions使用的还是result_table_name和source_table_name,这与后续版本的
 plugin_output/plugin_input也是存在冲突的
   
   ### SeaTunnel Version
   
   2.3.10
   
   ### SeaTunnel Config
   
   ```conf
   env{
     job.name="future_pos_同步销售头"
     parallelism = 1
     job.mode = "BATCH"
   }
   
   source {
     Jdbc {
       url = "jdbc:oracle:thin:@192.168.98.xx:1521:xxx"
       driver = "oracle.jdbc.OracleDriver"
       connection_check_timeout_sec = 100
       user = "dbusrposnew"
       password = "futureposnew"
       split.size = 10000
       table_list = [
           {
             table_path = "DBUSRPOSNEW.SALEHEAD"
             # Use query filetr rows & columns
             query = "select *  from DBUSRPOSNEW.SALEHEAD where 
RQSJ>=TO_DATE('${this_day}', 'YYYY/MM/DD HH24:MI:SS')"
           }
           
       ]
     }
   }
   
   
   transform {
     Sql {
       plugin_output="t"
       plugin_input="t1"
       query = """ 
       select  BILLNO, MKT, SYJH, FPHM, DJLB, BC, RQSJ,  
   TransformsGBK(SYYH) SYYH , HYKH, JFKH, THSQ, GHSQ, HYSQ, SQKH, SQKTYPE, 
SQKZKFD, YSJE, SJFK, ZL, SSWR_SYSY, FK_SYSY, HJZJE, HJZSL, HJZKE, HYZKE, YHZKE, 
LSZKE, BUYERINFO, JDFHDD, SALEFPHM, LJJF, BCJF, MEMO, STR1, TransformsGBK(STR2) 
STR2, STR3, STR4, STR5, NUM1, NUM2, NUM3, NUM4, NUM5, SENDRQSJ, STATUS, 
CUSTTYPE, HHFLAG, MANAUNIT, FQFLAG, JFFLAG, SAFLAG, FQJE, YHZSZK, YBILLNO, 
YSYJH, YFPHM, CRMBILLNO, STR8, CHANNEL, HYCID, HYTYPE FROM t
       """
     }
   }
   
   sink {
     Doris {
       fenodes = "192.168.0.123:8030,192.168.0.456:8030,192.168.0.789:8030"
       username = root
       password = "root"
       database = "ods_future_pos"
       table = "ods_${table_name}"
       # 保证每个文件唯一,拷贝之后文件需要修改此处
       sink.label-prefix = "future-pos_${table_name}-jdbc"
       sink.enable-2pc = "true"
       sink.enable-delete = "true"
       save_mode_create_template="CREATE TABLE IF NOT EXISTS 
`${database}`.`${table_name}` (${rowtype_primary_key},${rowtype_fields},dt 
datetime(0) default current_timestamp(0) on update current_timestamp(0)) 
ENGINE=OLAP UNIQUE KEY (${rowtype_primary_key}) DISTRIBUTED BY HASH 
(${rowtype_primary_key}) BUCKETS 3 PROPERTIES ( \"replication_allocation\" = 
\"tag.location.default: 3\",\"in_memory\" = \"false\",\"storage_format\" = 
\"V2\", \"disable_auto_compaction\" = \"false\")"
       doris.config {
         format = "json"
         read_json_by_line = "true"
       }
     }
   }
   ```
   
   ### Running Command
   
   ```shell
   集群
   ```
   
   ### Error Exception
   
   ```log
   java.lang.ClassNotFoundException: 
org.apache.seatunnel.api.common.CommonOptions
   ```
   
   ### Zeta or Flink or Spark Version
   
   zeta
   
   ### Java or Scala Version
   
   1.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]

Reply via email to