alibaba / alibaba/DataX

使用dataX工具同步数据发现部分date类型的字段值在目标表中发生变化

Open
#106 4 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

两个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

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.