alibaba / alibaba/DataX

DataX 不支持数据库读取这种字段类型

Open
#1,760 4 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

从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

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.