DataX 不支持数据库读取这种字段类型
- Dominant language
- Java
- Stars
- 17.4k
- Forks
- 5.7k
- PR merge metrics
- No merged PRs in 30d
Description
从postgres导入到postgres中,有个表字段的数据类型为jsonb,执行时显示如下错误,请问怎么解决。
Description:[不支持的数据库类型. 请注意查看 DataX 已经支持的数据库类型以及数据库版本.]. - 您的配置文件中的列配置信息有误. 因为DataX 不支持数据库读取这种字段类型. 字段名:[tag], 字段名称:[1111], 字段Java类型:[java.lang.String]. 请尝试使用数据库函数将其转换datax支持的类型 或者不同步该字段 .
Contributor guide
No contributing guide indexed for this repository
Research direction
Start by reproducing the PostgreSQL-to-PostgreSQL import described in the issue with a jsonb column named tag, then trace where DataX reports the unsupported database type and maps the field to java.lang.String. Check the existing PostgreSQL reader and writer support; done means the behavior is covered by a regression test or the supported limitation and workaround are clearly documented.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- java, postgresql
- Domain
- databases
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 30/100