Default forward data type mappings for Spark data sources

The following table lists the default forward data type mappings for Spark data sources.

Table 1. Spark default forward data type mappings
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 - -