alibaba / alibaba/DataX

postgresql往postgresql同步,存在时间精度丢失的问题

Open
#655 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

字段类型为`timestamp without time zone`,通过datax同步后,精度存在丢失。比如2020-04-28 20:46:54.922357,同步后变成2020-04-28 20:46:54.922,丢掉了末尾3位。

Contributor guide

No contributing guide indexed for this repository

Research direction

Reproduce a DataX synchronization from PostgreSQL using a timestamp without time zone value such as 2020-04-28 20:46:54.922357. Trace the PostgreSQL synchronization path and compare source and destination precision; the issue is done when all timestamp fractional digits are preserved.

Written by the indexing model from the issue text.

Assessment

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

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.