同步数据到clickhouse的datetime64类型，会丢失精度
- Dominant language
- Java
- Stars
- 17.4k
- Forks
- 5.7k
- PR merge metrics
- No merged PRs in 30d
Description
@dingxiaobo 同步数据到clickhouse的datetime64类型，会丢失精度
sqlserver原表字段类型：datetime(3)
clickhouse字段类型：datetime64
_Originally posted by @MrZhao1024B in https://github.com/alibaba/DataX/issues/1465#issuecomment-1276955878_
Contributor guide
No contributing guide indexed for this repository
Research direction
Reproduce the synchronization from a SQL Server datetime(3) source into a ClickHouse datetime64 field using the examples and screenshots in the issue. Trace the data path that handles these datetime values and compare source and destination precision. Done means the fractional-second precision is preserved in ClickHouse without loss.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- clickhouse, sql
- Domain
- databases
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 35/100