说明：本文仅列举在同步过程中不支持的字段类型，其它不在范围的数据源逐步补充。

Oracle作为源

目标 不支持字段
Oracle RAW，LONG_RAW，BFILE，XMLTYPE，STRUCT
Mongo RAW，LONG_RAW，BFILE，XMLTYPE，STRUCT，INTERVAL DAY(2) TO SECOND(6),INTERVAL YEAR(4) TO MONTH
SqlServer 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
PG RAW，LONG_RAW，BFILE，XMLTYPE，STRUCT，INTERVAL DAY(2) TO SECOND(6),INTERVAL YEAR(4) TO MONTH
ES 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
Mongo GEOMETRY,POINT,LINESTRING,POLYGON,MULTIPOINT,MULTILINESTRING,MULTIPOLYGON,GEOMETRYCOLLECTION,DOUBLE UNSIGNED,DOUBLE UNSIGNED,BINARY,VARBINARY,TINYBLOB,BLOB,LONGBLOB
SqlServer 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
PG GEOMETRY,POINT,LINESTRING,POLYGON,MULTIPOINT,MULTILINESTRING,MULTIPOLYGON,GEOMETRYCOLLECTION,DOUBLE UNSIGNED,DOUBLE UNSIGNED,BINARY,VARBINARY,TINYBLOB,BLOB,LONGBLOB
ES 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

SQLServer作为源

目标 不支持字段
Oracle xml, geometry, geography
Mongo xml, geometry, geography
SqlServer
Mysql xml, geometry, geography
PG xml, geometry, geography
ES 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
Mongo point, line, lseg, box, path, polygon, circle, int4range, int8range, numrange, tsrange, tstzrange, daterange, macaddr8, uuid, xml
SqlServer 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
PG ‘int4range’, ‘int8range’, ‘numrange’, ‘tsrange’, ‘tstzrange’, ‘daterange’
ES 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
Mongo
SqlServer JAVASCRIPT,MIN_KEY,REGULAR_EXPRESSION,MAX_KEY
Mysql JAVASCRIPT,MIN_KEY,REGULAR_EXPRESSION,MAX_KEY
PG JAVASCRIPT,MIN_KEY,REGULAR_EXPRESSION,MAX_KEY
ES 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

更多疑问或加入产品技术交流群：
官网.png
扫码添加 Tapdata 官方小助手

立即免费使用