ljl568419709 opened a new issue, #6926: URL: https://github.com/apache/seatunnel/issues/6926
### 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 SQLSERVERCDC on flink ： 如果是原表是update，则目标表会生成两条数据（一条原记录，一条修改后的记录），已验证以下两个源，均发现有问题 If the original table is an update, the target table will generate two pieces of data (one original record and one modified record). The following two sources have been verified and problems have been found in both of them sqlserverCDC->hive sqlserverCDC->doris 其中 id 为主键，以下是目标表  ### SeaTunnel Version seatunnel v2.3.5 flink 1.3.6 ### SeaTunnel Config ```conf env { parallelism = 1 job.mode = "STREAMING" checkpoint.interval = 10000 } source { SqlServer-CDC { result_table_name = "customers" username = "sa" password = "XXXX" startup.mode="initial" database-names = ["sqlserver_test"] table-names = ["sqlserver_test.dbo.sys_menu_sqlservercdc"] base-url = "jdbc:sqlserver://XXXXXXX:1433;databaseName=sqlserver_test" } } transform { # If you would like to get more information about how to configure seatunnel and see full list of transform plugins, # please go to https://seatunnel.apache.org/docs/transform-v2/sql } sink { Hive { table_name = "seatunnel_test_target.sys_menu_test_target" metastore_uri = "thrift://XXXXXXX:9083" } } ``` ### Running Command ```shell /apps/hive/apache-seatunnel-2.3.5/bin/start-seatunnel-flink-13-connector-v2.sh --config /apps/hive/apache-seatunnel-2.3.5/config/stream/sqlserverCDC/sqlserverCDC_doris.conf ``` ### Error Exception ```log If the original table is an update, the target table will generate two pieces of data (one original record and one modified record). The following two sources have been verified and problems have been found in both of them ``` ### 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]
