DTStack / DTStack/chunjun

[Bug] [flinkx-connector-oracle] sink data duplication

Open
#1,373 0 comments 0 reactions 0 assignees View on GitHub
bug
Dominant language
Java
Stars
4.1k
Forks
1.7k
PR merge metrics
No merged PRs in 30d

Description

### Search before asking

- [X] I had searched in the [issues](https://github.com/DTStack/chunjun/issues) and found no similar issues.

### What happened

I use oracle-x as sink,and the flinksql is "SELECT ROUND(actor_id,0) as round_id,actor_bio,actor_chName FROM table_a",but finally the result is beyond expectation.
image

### What you expected to happen

The result of sink should be like this.
image

### How to reproduce

The flinksql is "SELECT ROUND(actor_id,0) as round_id,actor_bio,actor_chName FROM table_a",I put the results into a new table(table_b),and then execute the sinksql
"INSERT INTO `table_c` SELECT * FROM `table_b` ".
chunjun version is 1.14_beta.
flink version is 1.14.4.

### Anything else

_No response_

### Version

master

### 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)

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.