使用DataX迁移mysql到oceanbase，bit字段报内容超长
- Dominant language
- Java
- Stars
- 17.4k
- Forks
- 5.7k
- PR merge metrics
- No merged PRs in 30d
Description
使用环境 】测试环境
【 OB or 其他组件 】OB、MySQL、DataX
【 使用版本 】OB:5.7.25-OceanBase_CE-v4.0.0.0-OceanBase_CE 4.0.0.0，MySQL：8.0.29，DataX：datax_v202303
【问题描述】使用DataX迁移mysql到oceanbase，bit字段报内容超长
【复现路径】mysql和oceanbase中建了同一张表，里面有bit类型的字段，同步失败
【问题现象及影响】
表里有bit类型的字段，使用DataX同步失败，报bit类型的字段内容超长
【附件】
报错：
oceanbase中的表结构：
mysql中的表结构：
mysql中的数据：
DataX的json配置：
https://ask.oceanbase.com/t/topic/35603364
Contributor guide
No contributing guide indexed for this repository
Research direction
Start by reproducing the migration with the DataX JSON configuration, matching MySQL and OceanBase table definitions, and a bit field as described. Compare the reported oversized-content error with the attached schemas and data; done means the same bit field synchronizes successfully without the error.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- java, mysql
- 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