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

   ### 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 have a task source from mysql, sink to maxcompute, with field mapper, i 
find sink columns in maxcompute is out of order
   env {
   job.mode = BATCH
   }
   
   source {
   Jdbc{
   password = ""
   driver = "com.mysql.cj.jdbc.Driver"
   query = "SELECT id,uid,user_name,job_name,params,created_at,updated_at FROM 
lakeservice_task"
   partition_column = "id"
   user = ""
   url = ""
   partition_num = "4"
   }
   }
   transform {
   FieldMapper {
   field_mapper = {
   id = id
   uid = uid
   user_name = user_name
   job_name = job_name
   params = params
   created_at = created_at
   updated_at = updated_at
   }
   }
   }
   sink {
   Maxcompute{
   accessId = ""
   endpoint = ""
   accesskey = ""
   project = "dp_ads_app_ecube_sec_sit_dev"
   table_name = "lake_service_07"
   }
   }
   after job finished, i select all records from maxcompute:
   
![image](https://github.com/apache/seatunnel/assets/29647455/6efc3d2a-45b7-4b0a-bee8-1968e9878fe6)
   
    Two problems: 
   1. All column values are written incorrectly: the uid column writes the 
value of the params column; the updated_at column writes the value of the id 
column...
   2. `id` column is a bigdecimal field, but '\N' is wroten。
   
   ### SeaTunnel Version
   
   2.3.3
   
   ### SeaTunnel Config
   
   ```conf
   env {
   job.mode = BATCH
   }
   
   source {
   Jdbc{
   password = ""
   driver = "com.mysql.cj.jdbc.Driver"
   query = "SELECT id,uid,user_name,job_name,params,created_at,updated_at FROM 
lakeservice_task"
   partition_column = "id"
   user = ""
   url = ""
   partition_num = "4"
   }
   }
   transform {
   FieldMapper {
   field_mapper = {
   id = id
   uid = uid
   user_name = user_name
   job_name = job_name
   params = params
   created_at = created_at
   updated_at = updated_at
   }
   }
   }
   sink {
   Maxcompute{
   accessId = ""
   endpoint = ""
   accesskey = ""
   project = "dp_ads_app_ecube_sec_sit_dev"
   table_name = "lake_service_07"
   }
   }
   ```
   
   
   ### Running Command
   
   ```shell
   i use dolphinscheduler
   ```
   
   
   ### Error Exception
   
   ```log
   see 'What happened' chapter
   ```
   
   
   ### 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]

Reply via email to