alibaba / alibaba/DataX

datax处理double类型数据的精度丢失问题

Open
#2,211 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

reader:oceanbase10reader
字段类型:NUMBER(17,2)
数据:99999999999999.99

writer:hdfswriter
字段类型:DECIMAL(17,2)
数据:9.999999999999998B

hive表查询出来数据就是:99999999999999.98

这种应该是数据超出了double类型的长度导致的,有没有可能通过datax的参数配置或类型转换来解决这个问题?

Contributor guide

No contributing guide indexed for this repository

Research direction

Start with the oceanbase10reader-to-hdfswriter conversion path and reproduce the reported NUMBER(17,2) to DECIMAL(17,2) transfer using 99999999999999.99. Trace where the value becomes a double, then verify that the Hive result preserves the original decimal value without precision loss.

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
Mostly clear
Newbie friendliness
42/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.