我要评论目录
一、背景
datax内置的enumtype数据类型与不同数据库间都有些差异，本文整理出相应的映射关系，在配置自定义json时可以参考做一些类型转换
二、映射
1.hive
| datax 数据类型 | hive表 数据类型 |
|---|---|
| long | tinyint,smallint,int,bigint |
| double | float,double |
| string | string,char,varchar,struct,map,array,union,binary |
| boolean | boolean |
| date | date,timestamp |
2.hbase
| datax 数据类型 | hbase 数据类型 |
|---|---|
| long | int, short ,long |
| double | float, double |
| string | string,binarystring |
| date | date |
| boolean | boolean |
3.mongodb
| datax 数据类型 | mongodb 数据类型 |
|---|---|
| long | int, long |
| double | double |
| string | string, array |
| date | date |
| boolean | boolean |
| bytes | bytes |
4.oracle
| datax 数据类型 | oracle 数据类型 |
|---|---|
| long | number,integer,int,smallint |
| double | numeric,decimal,float,double precision,real |
| string | long,char,nchar,varchar,varchar2,nvarchar2,clob,nclob,character,character varying,char varying,national character,national char,national character varying,national char varying,nchar varying |
| date | timestamp,date |
| boolean | bit, bool |
| bytes | blob,bfile,raw,long raw |
5.postgresql
| datax 数据类型 | postgresql 数据类型 |
|---|---|
| long | bigint, bigserial, integer, smallint, serial |
| double | double precision, money, numeric, real |
| string | varchar, char, text, bit, inet. （jsonb，_varchar,_int需要转成字符串 例如jsonb::varchar) |
| date | date, time, timestamp |
| boolean | bool |
| bytes | bytea |
6.sqlserver
| datax 数据类型 | sqlserver 数据类型 |
|---|---|
| long | bigint, int, smallint, tinyint |
| double | float, decimal, real, numeric |
| string | char,nchar,ntext,nvarchar,text,varchar,nvarchar(max),varchar(max) |
| date | date, datetime, time |
| boolean | bit |
| bytes | binary,varbinary,varbinary(max),timestamp |
7.mysql
| datax 数据类型 | mysql 数据类型 |
|---|---|
| long | int, tinyint, smallint, mediumint, int, bigint, year |
| double | float, double, decimal |
| string | varchar, char, tinytext, text, mediumtext, longtext |
| date | date, datetime, timestamp, time |
| boolean | bit, bool |
| bytes | tinyblob, mediumblob, blob, longblob, varbinary |
8.odps
| datax 数据类型 | odps 数据类型 |
|---|---|
| long | bigint |
| double | double |
| string | string |
| date | datetime |
| boolean | boolean |
9.oss
| datax 数据类型 | oss 数据类型 |
|---|---|
| long | long |
| double | double |
| string | string |
| boolean | boolean |
| date | date |
10.ots
| datax 数据类型 | ots 数据类型 |
|---|---|
| long | integer |
| double | double |
| string | string |
| boolean | boolean |
| bytes | binary |
11. tsdb
| datax 数据类型 | tsdb 数据类型 |
|---|---|
| string | tsdb 数据点序列化字符串，包括 timestamp、metric、tags 和 value |
12.adb pg
| datax 数据类型 | adb pg 数据类型 |
|---|---|
| long | bigint, bigserial, integer, smallint, serial |
| double | double precision, float, numeric, real |
| string | varchar, char, text |
| date | date, time, timestamp |
| boolean | bool |
13.ads
| datax 数据类型 | ads 数据类型 |
|---|---|
| long | int, tinyint, smallint, int, bigint |
| double | float, double, decimal |
| string | varchar |
| date | date |
| boolean | bool |
14. cassandra
| datax 数据类型 | cassandra 数据类型 |
|---|---|
| long | int, tinyint, smallint,varint,bigint,time |
| double | float, double, decimal |
| string | ascii,varchar, text,uuid,timeuuid,duration,list,map,set,tuple,udt,inet |
| date | date, timestamp |
| boolean | bool |
| bytes | blob |
15.drds
| datax 数据类型 | drds 数据类型 |
|---|---|
| long | int, tinyint, smallint, mediumint, int, bigint |
| double | float, double, decimal |
| string | varchar, char, tinytext, text, mediumtext, longtext |
| date | date, datetime, timestamp, time, year |
| boolean | bit, bool |
| bytes | tinyblob, mediumblob, blob, longblob, varbinary |
16.phoenix
| datax 数据类型 | phoenix 数据类型 |
|---|---|
| string | char, varchar |
| bytes | binary, varbinary |
| bool | boolean |
| long | integer, tinyint, smallint, bigint |
| double | float, decimal, double, |
| date | date, time, timestamp |
17.kingbasees
| datax 数据类型 | kingbasees 数据类型 |
|---|---|
| long | bigint, bigserial, integer, smallint, serial |
| double | double precision, money, numeric, real |
| string | varchar, char, text, bit, inet |
| date | date, time, timestamp |
| boolean | bool |
| bytes | bytea |
发表评论