MAPREDUCE服务 MRS-添加GAUSSDB数据源:数据类型映射
数据类型映射
GAUSSDB数据类型(data type) |
HetuEngine数据类型(data type) |
---|---|
BOOLEAN |
BOOLEAN |
TINYINT |
TINYINT |
SMALLINT |
SMALLINT |
INTEGER |
INTEGER |
BINARY_INTEGER |
INTEGER |
BIGINT |
BIGINT |
SMALLSERIAL |
SMALLINT |
SERIAL |
INTEGER |
BIGSERIAL |
BIGINT |
FLOAT4 (REAL) |
REAL |
FLOAT8(DOUBLE PRECISION) |
DOUBLE PRECISION |
DECIMAL[p (,s)] |
DECIMAL[p (,s)] |
NUMERIC[p (,s)] |
DECIMAL[p (,s)] |
CHAR(n) |
CHAR(n) |
CHARACTER(n) |
CHAR(n) |
NCHAR(n) |
CHAR(n) |
VARCHAR(n) |
VARCHAR(n) |
CHARACTER VARYING(55) |
VARCHAR(n) |
VARCHAR2(n) |
VARCHAR(n) |
NVARCHAR2(n) |
VARCHAR |
TEXT(CLOB) |
VARCHAR |
DATE |
TIMESTAMP |
TIMESTAMP |
TIMESTAMP |
UUID |
UUID |
JSON |
JSON |