Data Type Mapping
Data Type Mappings
The 本製品 maps types from the data source to the corresponding data type available in the schema. The table below documents these mappings.
BIGINT | BIGINT |
BIGSERIAL | BIGINT |
BSON | VARCHAR |
JSON | VARCHAR |
BYTE | BLOB |
CHARACTER | VARCHAR |
CHARACTER VARYING | VARCHAR |
DATE | DATE |
DATETIME | TIMESTAMP |
DECIMAL | DECIMAL |
DECIMAL, Fixed Point | DECIMAL |
FLOAT | DOUBLE |
INTEGER | INTEGER |
INT8 | BIGINT |
INTERVAL | VARCHAR |
MONEY | DECIMAL |
NCHAR | VARCHAR |
NVARCHAR | VARCHAR |
SERIAL | INTEGER |
SMALLFLOAT | FLOAT |
SMALLINT | SMALLINT |
TEXT | VARCHAR |
VARCHAR | VARCHAR |
BLOB | BLOB |
BOOLEAN | BOOLEAN |
CLOB | VARCHAR |
LIST | LIST |
LVARCHAR | VARCHAR |
MULTISET | MULTISET |
ROW, Named | ROW |
ROW, Unnamed | VARCHAR |
SET | SET |