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 type mappings applicable when working with a Cloudera Hive database.
|
Cloudera Hive Database Type |
Spotfire Data Type |
Supported |
|
TINYINT |
Integer/Int |
Yes |
|
SMALLINT |
Integer/Int |
Yes |
|
INT |
Integer/Int |
Yes |
|
BIGINT |
LongInteger/Long |
Yes |
|
FLOAT |
SingleReal/Float |
Yes |
|
DOUBLE |
Real/Double |
Yes |
|
DECIMAL |
Real/Double |
Yes |
|
BOOLEAN |
Boolean/Bool |
Yes |
|
STRING |
String |
Yes |
|
TIMESTAMP |
DateTime |
Yes |
|
ARRAY |
String |
Yes |
|
BINARY |
|
No |