Default forward data type mappings for Spark data sources
The following table lists the default forward data type mappings for Spark data sources.
Remote Typename | Remote Lower Len | Remote Upper Len | Remote Lower Scale | Remote Upper Scale | Remote Bit Data | Remote Data Operators | Federated Typename | Federated Length | Federated Scale | Federated Bit Data |
---|---|---|---|---|---|---|---|---|---|---|
BIGINT | - | - | - | - | - | - | BIGINT | 8 | - | - |
BINARY | - | - | - | - | - | - | BLOB | 2147483647 | - | Y |
BOOLEAN | - | - | - | - | - | - | SMALLINT | 2 | - | - |
DATE | - | - | - | - | - | - | DATE | - | - | - |
DECIMAL | - | - | - | - | - | - | DECIMAL | 31 | 10 | - |
DOUBLE | - | - | - | - | - | - | DOUBLE | 8 | - | - |
FLOAT | - | - | - | - | - | - | DOUBLE | 4 | - | - |
INT | 2,147,483,648 | 2,147,483,647 | - | - | - | - | INTEGER | 4 | - | - |
SMALLINT | 32768 | 32767 | SMALLINT | 2 | - | - | ||||
STRING | - | - | - | - | - | - | CLOB | 2147483647 | - | - |
TIMESTAMP | - | - | - | - | - | - | TIMESTAMP(6) | 10 | 6 | - |
TINYINT | 128 | 127 | - | - | - | - | SMALLINT | 2 | - | - |
VARCHAR | - | - | - | - | - | - | CLOB | 65535 | - | - |