Default forward data type mappings for Impala data sources
The following table lists the default forward data type mappings for Impala 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 |
|---|---|---|---|---|---|---|---|---|---|---|
| SQL_BIGINT | - | - | - | - | - | - | BIGINT | 8 | - | - |
| SQL_CHAR | 1 | 254 | - | - | - | - | CHAR | - | - | N |
| SQL_CHAR | 255 | 32672 | - | - | - | - | VARCHAR | - | - | N |
| SQL_DECIMAL | 1 | 31 | 0 | 31 | - | - | DECIMAL | - | - | - |
| SQL_DECIMAL | 32 | 38 | 0 | 38 | - | - | DOUBLE | 8 | - | - |
| SQL_DOUBLE | - | - | - | - | - | - | DOUBLE | 8 | - | - |
| SQL_FLOAT | - | 8 | - | - | - | - | FLOAT | 8 | - | - |
| SQL_FLOAT | - | 4 | - | - | - | - | FLOAT | 4 | - | - |
| SQL_INTEGER | - | - | - | - | - | - | INTEGER | 4 | - | - |
| SQL_REAL | - | - | - | - | - | - | REAL | 4 | - | - |
| SQL_SMALLINT | - | - | - | - | - | - | SMALLINT | 2 | - | - |
| SQL_TIMESTAMP | - | - | - | - | - | - | TIMESTAMP(6) | 10 | 6 | - |
| SQL_TINYINT | - | - | - | - | - | - | SMALLINT | 2 | - | - |
| SQL_VARCHAR | 1 | 32672 | - | - | - | - | VARCHAR | - | - | N |
| SQL_VARCHAR | 32673 | 65535 | - | - | - | - | CLOB | - | - | N |
| SQL_WVARCHAR | - | - | - | - | - | - | CLOB | 32767 | - | N |