alibaba / alibaba/DataX

使用datax同步Oracle数据丢失

Open
#1,600 0 comments 0 reactions 0 assignees View on GitHub
Dominant language
Java
Stars
17.4k
Forks
5.7k
PR merge metrics
No merged PRs in 30d

Description

源表有数据约20万条,直接写sql不加任何条件,同步成功后只有源表大概一半的数据
![image](https://user-images.githubusercontent.com/58186097/201635197-401e4adc-3533-4d2c-a16e-08a3c366cc1b.png)
不加where条件,单纯对某一列做order by 排序会同步全部数据
![image](https://user-images.githubusercontent.com/58186097/201635443-1e8b38a5-4809-4723-a015-c4b3e80385fe.png)
求各位大佬指教。

Contributor guide

No contributing guide indexed for this repository

Research direction

No source files, tests, or entry points are identified. Start by reproducing the Oracle-to-DataX synchronization with the reported roughly 200,000-row table and compare source and destination counts, then inspect the complete reader configuration and SQL behavior. Done means the synchronization consistently transfers every source row without adding an ORDER BY workaround.

Written by the indexing model from the issue text.

Assessment

Tech stack
java, sql
Domain
data-engineering, databases
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
25/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.