# 附录 #### 数据源原始类型与系统类型映射 ![](https://support.huaweicloud.com/usermanual-dataartsplatform/public_sys-resources/note_3.0-zh-cn.png) - 数组类型映射规则：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 | #### 系统类型及其可选类型说明 ![](https://support.huaweicloud.com/usermanual-dataartsplatform/public_sys-resources/note_3.0-zh-cn.png) - 向下转型说明：由高精度数值转型为低精度数值或由文本转为数值等情况视为向下转型，向下转型可能存在数据不一致或数据丢失情况，请谨慎使用。 - 默认转换类型：前端自动选取正常转型列表中首个类型作为默认转换类型（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 | / |