datax(26):各个数据库与datax字段映射

通过源码解读Column-datax中的数据类型,可以知道datax框架中只有7(enum Type种)种数据类型,那么各个数据库的字段是如何和datax的字段进行相互映射?


一、ADB PG

DataX 内部类型ADB PG 数据类型
Longbigint, bigserial, integer, smallint, serial
Doubledouble precision, float, numeric, real
Stringvarchar, char, text
Datedate, time, timestamp
Booleanbool

二、ADS

DataX 内部类型ADS 数据类型
Longint, tinyint, smallint, int, bigint
Doublefloat, double, decimal
Stringvarchar
Datedate
Booleanbool
Bytes

三、Cassandra

DataX 内部类型Cassandra 数据类型
Longint, tinyint, smallint,varint,bigint,time
Doublefloat, double, decimal
Stringascii,varchar, text,uuid,timeuuid,duration,list,map,set,tuple,udt,inet
Datedate, timestamp
Booleanbool
Bytesblob

四、DRDS

DataX 内部类型DRDS 数据类型
Longint, tinyint, smallint, mediumint, int, bigint
Doublefloat, double, decimal
Stringvarchar, char, tinytext, text, mediumtext, longtext
Datedate, datetime, timestamp, time, year
Booleanbit, bool
Bytestinyblob, mediumblob, blob, longblob, varbinary

五、FTP

DataX 内部类型FTP文件 数据类型
LongLong -> 字符串序列化表示
DoubleDouble -> 字符串序列化表示
StringString -> 字符串序列化表示
BooleanBoolean -> 字符串序列化表示
DateDate -> 字符串序列化表示

六、HBase

DataX 内部类型HBase 数据类型
Longint, short ,long
Doublefloat, double
Stringstring,binarystring
Datedate
Booleanboolean

七、 Phoenix

DataX 内部类型Phoenix 数据类型
StringCHAR, VARCHAR
BytesBINARY, VARBINARY
BoolBOOLEAN
LongINTEGER, TINYINT, SMALLINT, BIGINT
DoubleFLOAT, DECIMAL, DOUBLE,
DateDATE, TIME, TIMESTAMP

八、Hive

DataX 内部类型Hive表 数据类型
LongTINYINT,SMALLINT,INT,BIGINT
DoubleFLOAT,DOUBLE
StringString,CHAR,VARCHAR,STRUCT,MAP,ARRAY,UNION,BINARY
BooleanBOOLEAN
DateDate,TIMESTAMP

九、KingbaseES

DataX 内部类型KingbaseES 数据类型
Longbigint, bigserial, integer, smallint, serial
Doubledouble precision, money, numeric, real
Stringvarchar, char, text, bit, inet
Datedate, time, timestamp
Booleanbool
Bytesbytea

十、MongoDB

DataX 内部类型MongoDB 数据类型
Longint, Long
Doubledouble
Stringstring, array
Datedate
Booleanboolean
Bytesbytes

十一、ADB PG

DataX 内部类型Mysql 数据类型
Longint, tinyint, smallint, mediumint, int, bigint, year
Doublefloat, double, decimal
Stringvarchar, char, tinytext, text, mediumtext, longtext
Datedate, datetime, timestamp, time
Booleanbit, bool
Bytestinyblob, mediumblob, blob, longblob, varbinary

十二、ODPS

DataX 内部类型ODPS 数据类型
LongBIGINT
DoubleDOUBLE
StringSTRING
DateDATETIME
BooleanBoolean

十三、TSDB

DataX 内部类型TSDB 数据类型
StringTSDB 数据点序列化字符串,包括 timestamp、metric、tags 和 value

十四、Oracle

DataX 内部类型Oracle 数据类型
LongNUMBER,INTEGER,INT,SMALLINT
DoubleNUMERIC,DECIMAL,FLOAT,DOUBLE PRECISION,REAL
StringLONG,CHAR,NCHAR,VARCHAR,VARCHAR2,NVARCHAR2,CLOB,NCLOB,CHARACTER,CHARACTER VARYING,CHAR VARYING,NATIONAL CHARACTER,NATIONAL CHAR,NATIONAL CHARACTER VARYING,NATIONAL CHAR VARYING,NCHAR VARYING
DateTIMESTAMP,DATE
Booleanbit, bool
BytesBLOB,BFILE,RAW,LONG RAW

十五、OSS

DataX 内部类型OSS 数据类型
LongLong
DoubleDouble
StringString
BooleanBoolean
DateDate

十六、OTS

DataX 内部类型OTS 数据类型
LongInteger
DoubleDouble
StringString
BooleanBoolean
BytesBinary

十七、PostgreSQL

DataX 内部类型PostgreSQL 数据类型
Longbigint, bigserial, integer, smallint, serial
Doubledouble precision, money, numeric, real
Stringvarchar, char, text, bit, inet
Datedate, time, timestamp
Booleanbool
Bytesbytea

十八、SqlServer

DataX 内部类型SqlServer 数据类型
Longbigint, int, smallint, tinyint
Doublefloat, decimal, real, numeric
Stringchar,nchar,ntext,nvarchar,text,varchar,nvarchar(MAX),varchar(MAX)
Datedate, datetime, time
Booleanbit
Bytesbinary,varbinary,varbinary(MAX),timestamp

十九、本地文件

DataX 内部类型本地文件 数据类型
LongLong
DoubleDouble
StringString
BooleanBoolean
DateDate
相关推荐
©️2020 CSDN 皮肤主题: 酷酷鲨 设计师:CSDN官方博客 返回首页