使用dataX工具同步数据发现部分date类型的字段值在目标表中发生变化
Open
- Dominant language
- Java
- Stars
- 17.4k
- Forks
- 5.7k
- PR merge metrics
- No merged PRs in 30d
Description
两个GP数据库之间同步表数据,json文件配置的是select * from table_name,全字段同步。完成数据同步后,发现目标表中部分数据的生日字段(字段类型为date)字段值比源表中此字段值小一天,例如,源表中字段值为1989-05-11,同步后目标表中值变为1989-05-10,但又不是表中所有数据此字段值都发生变化,请问大家是否遇到过此问题,应该怎样排查原因?
Contributor guide
No contributing guide indexed for this repository
Research direction
No source file, test, or entry point is named. Reproduce a DataX sync between the two GP databases using the reported select * configuration, then compare source and target date fields, including rows that do and do not change. Done means identifying the cause of the one-day shift and recording a verified fix or diagnostic conclusion.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- java
- 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