The relational library supports upsert mode writing

[yuangjiang]

Search before asking

• [X] I had searched in the feature and found no similar feature requirement.

Description

The relational library supports upsert mode writing, for example, when mysql->oracle is used, data is quickly imported into the main table through distributed distribution. When encountering an update failure, log the error to a file and the entire task does not stop. Record data of failed task synchronization after the task is completed. It turned out that we used the temporary table method to solve this problem. I don't know if seatunnel has a relatively complete and fast data import solution.

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

[CalvinKirs]

@ic4y Hi, do you have any idea?

[liugddx]

i have an idea,when data synchronization fails,we can write drity data to a three-way store,need a dirtyManager module to do this job.And this module is pluggable,we can configure it in the env.

[github-actions[bot]]

This issue has been automatically marked as stale because it has not had recent activity for 30 days. It will be closed in next 7 days if no further activity occurs.

[github-actions[bot]]

This issue has been closed because it has not received response for too long time. You could reopen it if you encountered similar problems in the future.