When you are setting up a connection to an external data source, Spotfire needs to map the data types in the data source to data types in Spotfire. See below for a list of the different data types that Spotfire supports and the applied data type mappings when working with a Cloudera Hive database.
Cloudera Hive Data Type |
Spotfire Data Type |
BOOLEAN |
Boolean/Bool |
TIMESTAMP |
DateTime |
INT |
Integer/Int |
SMALLINT |
Integer/Int |
TINYINT |
Integer/Int |
BIGINT |
LongInteger/Long |
DECIMAL |
Real/Double |
DOUBLE |
Real/Double |
FLOAT |
SingleReal/Float |
ARRAY |
String |
STRING |
String |
Any other data types are not supported.