数据类型支持说明
TapData Cloud 为您提供了云端服务，适合需要快速部署、低前期投资场景，帮助您更好地专注于业务发展而非基础设施管理，注册账号即可领取免费的 Agent 实例，欢迎试用。
TapData Enterprise 可部署在您的本地数据中心，适合对数据敏感性或网络隔离有严格要求的场景，可服务于构建实时数仓，实现实时数据交换，数据迁移等场景。
TapData Community 是一个开源的数据集成平台，提供基础的数据同步和转换功能，可通过 Docker 一键部署，帮助您快速探索和实施数据集成项目。随着项目或企业发展，您可以平滑升级至 TapData Cloud 或 TapData Enterprise，以获得更多高级功能或服务支持。提示
本文仅列举 TapData 在同步过程中不支持的字段类型，不在范围的数据源逐步补充。
Oracle 作为源
| 目标 | 不支持字段 |
|---|---|
| Oracle | RAW，LONG_RAW，BFILE，XMLTYPE，STRUCT |
| MongoDB | RAW，LONG_RAW，BFILE，XMLTYPE，STRUCT，INTERVAL DAY(2) TO SECOND(6),INTERVAL YEAR(4) TO MONTH |
| SQL Server | RAW，LONG_RAW，BFILE，XMLTYPE，STRUCT，INTERVAL DAY(2) TO SECOND(6),INTERVAL YEAR(4) TO MONTH |
| MySQL | RAW，LONG_RAW，BFILE，XMLTYPE，STRUCT，INTERVAL DAY(2) TO SECOND(6),INTERVAL YEAR(4) TO MONTH |
| PostgreSQL | RAW，LONG_RAW，BFILE，XMLTYPE，STRUCT，INTERVAL DAY(2) TO SECOND(6),INTERVAL YEAR(4) TO MONTH |
| Elastic Search | RAW，LONG_RAW，BFILE，XMLTYPE，STRUCT，INTERVAL DAY(2) TO SECOND(6),INTERVAL YEAR(4) TO MONTH |
| Kafka | RAW，LONG_RAW，BFILE，XMLTYPE，STRUCT，INTERVAL DAY(2) TO SECOND(6),INTERVAL YEAR(4) TO MONTH |
| ClickHouse | RAW，LONG_RAW，BFILE，XMLTYPE，STRUCT，INTERVAL DAY(2) TO SECOND(6),INTERVAL YEAR(4) TO MONTH,BLOB |
MySQL 作为源
| 目标 | 不支持字段 |
|---|---|
| Oracle | GEOMETRY,POINT,LINESTRING,POLYGON,MULTIPOINT,MULTILINESTRING,MULTIPOLYGON,GEOMETRYCOLLECTION,DOUBLE UNSIGNED,DOUBLE UNSIGNED,BINARY,VARBINARY,TINYBLOB,BLOB,LONGBLOB |
| MongoDB | GEOMETRY,POINT,LINESTRING,POLYGON,MULTIPOINT,MULTILINESTRING,MULTIPOLYGON,GEOMETRYCOLLECTION,DOUBLE UNSIGNED,DOUBLE UNSIGNED,BINARY,VARBINARY,TINYBLOB,BLOB,LONGBLOB |
| SQL Server | GEOMETRY,POINT,LINESTRING,POLYGON,MULTIPOINT,MULTILINESTRING,MULTIPOLYGON,GEOMETRYCOLLECTION,DOUBLE UNSIGNED,DOUBLE UNSIGNED,BINARY,VARBINARY,TINYBLOB,BLOB,LONGBLOB |
| MySQL | GEOMETRY,POINT,LINESTRING,POLYGON,MULTIPOINT,MULTILINESTRING,MULTIPOLYGON,GEOMETRYCOLLECTION |
| PostgreSQL | GEOMETRY,POINT,LINESTRING,POLYGON,MULTIPOINT,MULTILINESTRING,MULTIPOLYGON,GEOMETRYCOLLECTION,DOUBLE UNSIGNED,DOUBLE UNSIGNED,BINARY,VARBINARY,TINYBLOB,BLOB,LONGBLOB |
| Elastic Search | GEOMETRY,POINT,LINESTRING,POLYGON,MULTIPOINT,MULTILINESTRING,MULTIPOLYGON,GEOMETRYCOLLECTION,DOUBLE UNSIGNED,DOUBLE UNSIGNED,BINARY,VARBINARY,TINYBLOB,BLOB,LONGBLOB |
| Kafka | GEOMETRY,POINT,LINESTRING,POLYGON,MULTIPOINT,MULTILINESTRING,MULTIPOLYGON,GEOMETRYCOLLECTION,DOUBLE UNSIGNED,DOUBLE UNSIGNED,BINARY,VARBINARY,TINYBLOB,BLOB,LONGBLOB |
| ClickHouse | GEOMETRY,POINT,LINESTRING,POLYGON,MULTIPOINT,MULTILINESTRING,MULTIPOLYGON,GEOMETRYCOLLECTION,DOUBLE UNSIGNED,BINARY,VARBINARY,TINYBLOB,BLOB,LONGBLOB |
SQL Server 作为源
提示
受 SQL Server 本身机制的影响，如果待同步的表没有主键且包含 ntext/text/image 类型时，一旦该表发生更新或者删除操作，可能会导致更新或删除多条数据（多条数据中，仅前文中字段的值不一致，其余字段值都一致的情况下）。
| 目标 | 不支持字段 |
|---|---|
| Oracle | xml, geometry, geography |
| MongoDB | xml, geometry, geography |
| MySQL | xml, geometry, geography |
| PostgreSQL | xml, geometry, geography |
| Elastic Search | xml, geometry, geography |
| Kafka | xml, geometry, geography |
| ClickHouse | xml, geometry, geography,binary,varbinary,image |
PG 作为源
| 目标 | 不支持字段 |
|---|---|
| Oracle | point, line, lseg, box, path, polygon, circle, int4range, int8range, numrange, tsrange, tstzrange, daterange, macaddr8, uuid, xml |
| MongoDB | point, line, lseg, box, path, polygon, circle, int4range, int8range, numrange, tsrange, tstzrange, daterange, macaddr8, uuid, xml |
| SQL Server | point, line, lseg, box, path, polygon, circle, int4range, int8range, numrange, tsrange, tstzrange, daterange, macaddr8, uuid, xml |
| MySQL | point, line, lseg, box, path, polygon, circle, int4range, int8range, numrange, tsrange, tstzrange, daterange, macaddr8, uuid, xml |
| PostgreSQL | 'int4range', 'int8range', 'numrange', 'tsrange', 'tstzrange', 'daterange' |
| Elastic Search | point, line, lseg, box, path, polygon, circle, int4range, int8range, numrange, tsrange, tstzrange, daterange, macaddr8, uuid, xml |
| Kafka | point, line, lseg, box, path, polygon, circle, int4range, int8range, numrange, tsrange, tstzrange, daterange, macaddr8, uuid, xml |
| ClickHouse | point, line, lseg, box, path, polygon, circle, int4range, int8range, numrange, tsrange, tstzrange, daterange, macaddr8, uuid, xml, bytea |
MongoDB 作为源
| 目标 | 不支持字段 |
|---|---|
| Oracle | JAVASCRIPT,MIN_KEY,REGULAR_EXPRESSION,MAX_KEY |
| SQL Server | JAVASCRIPT,MIN_KEY,REGULAR_EXPRESSION,MAX_KEY |
| MySQL | JAVASCRIPT,MIN_KEY,REGULAR_EXPRESSION,MAX_KEY |
| PostgreSQL | JAVASCRIPT,MIN_KEY,REGULAR_EXPRESSION,MAX_KEY |
| Elastic Search | JAVASCRIPT,MIN_KEY,REGULAR_EXPRESSION,MAX_KEY |
| Kafka | JAVASCRIPT,MIN_KEY,REGULAR_EXPRESSION,MAX_KEY |
| ClickHouse | JAVASCRIPT,MIN_KEY,REGULAR_EXPRESSION,MAX_KEY,BINARY,NULL |