附录

数据源原始类型与系统类型映射

数组类型映射规则：PostgreSQL、OpenGauss、DWS的数组类型按 ARRAY<元素映射类型> 映射；Doris数组类型暂映射为 STRING，后续将支持原生数组映射。
DECIMAL类型精度说明：系统最高支持精度为38，对于未明确指定精度或精度大于38的原始类型将映射为STRING类型。

表1 数据源原始类型与系统类型映射
序号	数据源类型	数据源原始字段类型	映射系统类型
1	MySQL	BIT	STRING
2	MySQL	TINYINT	BYTE
3	MySQL	SMALLINT	SHORT
4	MySQL	MEDIUMINT	INTEGER
5	MySQL	INT	INTEGER
6	MySQL	INTEGER	INTEGER
7	MySQL	BIGINT	BIGINT
8	MySQL	FLOAT	FLOAT
9	MySQL	DOUBLE	DOUBLE
10	MySQL	DECIMAL	DECIMAL/STRING
11	MySQL	DATE	DATE
12	MySQL	DATETIME	TIMESTAMP
13	MySQL	TIMESTAMP	TIMESTAMP
14	MySQL	TIME	STRING
15	MySQL	YEAR	STRING
16	MySQL	CHAR	STRING
17	MySQL	VARCHAR	STRING
18	MySQL	BINARY	BINARY
19	MySQL	VARBINARY	STRING
20	MySQL	TINYBLOB	STRING
21	MySQL	BLOB	STRING
22	MySQL	MEDIUMBLOB	STRING
23	MySQL	LONGBLOB	STRING
24	MySQL	TINYTEXT	STRING
25	MySQL	TEXT	STRING
26	MySQL	MEDIUMTEXT	STRING
27	MySQL	LONGTEXT	STRING
28	MySQL	JSON	STRING
29	MySQL	BOOLEAN	BOOLEAN
30	MySQL	BOOL	BOOLEAN
31	MySQL	ENUM	STRING
32	MySQL	SET	STRING
33	PostgreSQL	BIT	STRING
34	PostgreSQL	SMALLINT	SHORT
35	PostgreSQL	INTEGER	INTEGER
36	PostgreSQL	BIGINT	BIGINT
37	PostgreSQL	DECIMAL	DECIMAL/STRING
38	PostgreSQL	NUMERIC	DECIMAL/STRING
39	PostgreSQL	REAL	DOUBLE
40	PostgreSQL	DOUBLE PRECISION	DOUBLE
41	PostgreSQL	SMALLSERIAL	SHORT
42	PostgreSQL	SERIAL	INTEGER
43	PostgreSQL	BIGSERIAL	BIGINT
44	PostgreSQL	OID	BIGINT
45	PostgreSQL	INT2	SHORT
46	PostgreSQL	INT4	INTEGER
47	PostgreSQL	INT8	BIGINT
48	PostgreSQL	FLOAT4	FLOAT
49	PostgreSQL	FLOAT8	DOUBLE
50	PostgreSQL	SERIAL2	SHORT
51	PostgreSQL	SERIAL4	INTEGER
52	PostgreSQL	SERIAL8	BIGINT
53	PostgreSQL	CHARACTER	STRING
54	PostgreSQL	CHARACTER VARYING	STRING
55	PostgreSQL	CHAR	STRING
56	PostgreSQL	VARCHAR	STRING
57	PostgreSQL	TEXT	STRING
58	PostgreSQL	UUID	STRING
59	PostgreSQL	TIMESTAMP	TIMESTAMP
60	PostgreSQL	TIMESTAMPTZ	TIMESTAMP
61	PostgreSQL	DATE	DATE
62	PostgreSQL	TIME	STRING
63	PostgreSQL	TIMETZ	STRING
64	PostgreSQL	INTERVAL	STRING
65	PostgreSQL	BOOLEAN	BOOLEAN
66	PostgreSQL	BOOL	BOOLEAN
67	PostgreSQL	JSON	STRING
68	PostgreSQL	JSONB	STRING
69	PostgreSQL	BYTEA	BINARY
70	PostgreSQL	MONEY	STRING
71	PostgreSQL	BPCHAR	STRING
72	PostgreSQL	NAME	STRING
73	PostgreSQL	POINT	STRING
74	PostgreSQL	LSEG	STRING
75	PostgreSQL	BOX	STRING
76	PostgreSQL	PATH	STRING
77	PostgreSQL	POLYGON	STRING
78	PostgreSQL	CIRCLE	STRING
79	PostgreSQL	CIDR	STRING
80	PostgreSQL	INET	STRING
81	PostgreSQL	MACADDR	STRING
82	PostgreSQL	RELTIME	STRING
83	OpenGauss	TINYINT	SHORT
84	OpenGauss	SMALLINT	SHORT
85	OpenGauss	INTEGER	INTEGER
86	OpenGauss	BINARY_INTEGER	INTEGER
87	OpenGauss	BIGINT	BIGINT
88	OpenGauss	INT1	SHORT
89	OpenGauss	INT2	SHORT
90	OpenGauss	INT4	INTEGER
91	OpenGauss	INT8	BIGINT
92	OpenGauss	NUMERIC	DECIMAL/STRING
93	OpenGauss	DECIMAL	DECIMAL/STRING
94	OpenGauss	NUMBER	DECIMAL/STRING
95	OpenGauss	DEC	DECIMAL/STRING
96	OpenGauss	SMALLSERIAL	SHORT
97	OpenGauss	SERIAL	INTEGER
98	OpenGauss	BIGSERIAL	BIGINT
99	OpenGauss	OID	BIGINT
100	OpenGauss	REAL	FLOAT
101	OpenGauss	FLOAT	DOUBLE
102	OpenGauss	FLOAT4	FLOAT
103	OpenGauss	FLOAT8	DOUBLE
104	OpenGauss	DOUBLE PRECISION	DOUBLE
105	OpenGauss	BINARY_DOUBLE	DOUBLE
106	OpenGauss	MONEY	STRING
107	OpenGauss	BOOLEAN	BOOLEAN
108	OpenGauss	BOOL	BOOLEAN
109	OpenGauss	CHAR	STRING
110	OpenGauss	CHARACTER	STRING
111	OpenGauss	NCHAR	STRING
112	OpenGauss	VARCHAR	STRING
113	OpenGauss	CHARACTER VARYING	STRING
114	OpenGauss	VARCHAR2	STRING
115	OpenGauss	NVARCHAR2	STRING
116	OpenGauss	BPCHAR	STRING
117	OpenGauss	UUID	STRING
118	OpenGauss	CLOB	STRING
119	OpenGauss	TEXT	STRING
120	OpenGauss	NAME	STRING
121	OpenGauss	DATE	DATE
122	OpenGauss	TIME	STRING
123	OpenGauss	TIMETZ	STRING
124	OpenGauss	TIMESTAMP	TIMESTAMP
125	OpenGauss	TIMESTAMPTZ	TIMESTAMP
126	OpenGauss	SMALLDATETIME	TIMESTAMP
127	OpenGauss	BIT	STRING
128	OpenGauss	BIT VARYING	STRING
129	OpenGauss	VARBIT	STRING
130	OpenGauss	JSON	STRING
131	OpenGauss	JSONB	STRING
132	DWS	BIT	STRING
133	DWS	SMALLINT	SHORT
134	DWS	INTEGER	INTEGER
135	DWS	TINYINT	SHORT
136	DWS	BIGINT	BIGINT
137	DWS	DECIMAL	DECIMAL/STRING
138	DWS	NUMERIC	DECIMAL/STRING
139	DWS	REAL	DOUBLE
140	DWS	DOUBLE PRECISION	DOUBLE
141	DWS	SMALLSERIAL	SHORT
142	DWS	SERIAL	INTEGER
143	DWS	BIGSERIAL	BIGINT
144	DWS	OID	BIGINT
145	DWS	INT2	SHORT
146	DWS	INT4	INTEGER
147	DWS	INT8	BIGINT
148	DWS	FLOAT4	FLOAT
149	DWS	FLOAT8	DOUBLE
150	DWS	SERIAL2	SHORT
151	DWS	SERIAL4	INTEGER
152	DWS	SERIAL8	BIGINT
153	DWS	CHARACTER	STRING
154	DWS	CHARACTER VARYING	STRING
155	DWS	CHAR	STRING
156	DWS	VARCHAR	STRING
157	DWS	NVARCHAR2	STRING
158	DWS	TEXT	STRING
159	DWS	UUID	STRING
160	DWS	TIMESTAMP	TIMESTAMP
161	DWS	TIMESTAMPTZ	TIMESTAMP
162	DWS	DATE	DATE
163	DWS	TIME	STRING
164	DWS	TIMETZ	STRING
165	DWS	INTERVAL	STRING
166	DWS	BOOLEAN	BOOLEAN
167	DWS	BOOL	BOOLEAN
168	DWS	JSON	STRING
169	DWS	JSONB	STRING
170	DWS	BYTEA	BINARY
171	DWS	MONEY	STRING
172	DWS	BPCHAR	STRING
173	DWS	NAME	STRING
174	DWS	POINT	STRING
175	DWS	LSEG	STRING
176	DWS	BOX	STRING
177	DWS	PATH	STRING
178	DWS	POLYGON	STRING
179	DWS	CIRCLE	STRING
180	DWS	CIDR	STRING
181	DWS	INET	STRING
182	DWS	MACADDR	STRING
183	DWS	RELTIME	STRING
184	Doris	BIGINT	BIGINT
185	Doris	BOOLEAN	BOOLEAN
186	Doris	CHAR	STRING
187	Doris	DATE	DATE
188	Doris	DATEV2	DATE
189	Doris	DATETIME	TIMESTAMP
190	Doris	DATETIMEV2	TIMESTAMP
191	Doris	DECIMALV2	DECIMAL/STRING
192	Doris	DECIMAL32	DECIMAL/STRING
193	Doris	DECIMAL64	DECIMAL/STRING
194	Doris	DECIMAL128	DECIMAL/STRING
195	Doris	DOUBLE	DOUBLE
196	Doris	FLOAT	FLOAT
197	Doris	INT	INTEGER
198	Doris	LARGEINT	DECIMAL
199	Doris	SMALLINT	SHORT
200	Doris	STRING	STRING
201	Doris	TINYINT	BYTE
202	Doris	VARCHAR	STRING
203	Doris	JSON	STRING
204	Doris	AGG_STATE	STRING
205	Doris	BITMAP	STRING
206	Doris	HLL	STRING
207	Doris	QUANTILE_STATE	STRING
208	Doris	MAP	STRING

系统类型及其可选类型说明

向下转型说明：由高精度数值转型为低精度数值或由文本转为数值等情况视为向下转型，向下转型可能存在数据不一致或数据丢失情况，请谨慎使用。
默认转换类型：前端自动选取正常转型列表中首个类型作为默认转换类型（DECIMAL 类型除外，需手动选择）。若与业务不匹配，请按需修改。
地理位置类型说明：支持将json格式字符串写入本体“geo_point”或“geo_shape”类型，源数据需满足以下格式要求。
- geo_point：json字符串，格式为{"lon": 22,"lat": 30}，其中lon表示经度，取值范围[-180, 180]，lat表示纬度，取值范围[-90, 90]。
- geo_shape：json字符串，满足标准GeoJSON格式，如：{"type":"LineString","coordinates":[[100,0],[101,1],[102,2]]}。当前支持的type范围为Point、LineString、Polygon。

表2 系统类型及其可选类型说明
序号	系统类型	可选本体类型	正常转型	向下转型
1	BYTE	byte, short, int, long, float, double, boolean,string	byte, short, int, long, float, double, string	boolean
2	SHORT	short, byte, int, long, float, double, boolean, string	short, int, long, float, double, string	boolean,byte
3	INTEGER	int, byte, short, long, float, double, boolean, string	int, long, float, double, string	boolean, byte, short
4	BIGINT	long, int, byte, short, float, double, boolean, string, date, date_time	long, float, double, date, date_time, string	boolean, byte, short, int
5	FLOAT	float, double, long, int, byte, short, boolean, string, date, date_time	float, double, string	boolean, byte, short, int, long, date, date_time
6	DOUBLE	double, float, long, int, byte, short, boolean, string, date, date_time	double, string	boolean, byte, short, int, long, float, date, date_time
7	DECIMAL	double, float, long, int, byte, short, boolean, string	string	boolean, byte, short, int, long, float, double
8	STRING	string, byte, short, int, long, float, double, boolean, geo_point, geo_shape	string	boolean, byte, short, int, long, float, double, geo_point, geo_shape
9	DATE	date_time, date, long, string	date, date_time, long, string	/
10	TIMESTAMP	date_time, date, long, string	date_time, date, long, string	/
11	BOOLEAN	boolean, byte, short, int, long, float, double, string	boolean, byte, short, int, long, float, double, string	/
12	BINARY	string	string	/
13	ARRAY	array, set, string	array, set, string	/

上一篇：日常维护自定义工具

附录

数据源原始类型与系统类型映射

系统类型及其可选类型说明

相关文档

您对此文档页面的整体评价？