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 data from a Vertica database.
Vertica Data Type |
Spotfire Data Type |
BINARY |
Binary |
VARBINARY |
Binary |
BOOLEAN |
Boolean |
MONEY |
Currency |
DATE |
Date |
TIMESTAMP |
DateTime |
TIMESTAMPTZ |
DateTime |
INTEGER |
LongInteger |
BIGINT |
LongInteger |
DOUBLE PRECISION |
Real |
FLOAT |
Real |
CHAR |
String |
LONG VARCHAR |
String |
VARCHAR |
String |
TIME |
Time |
TIMETZ |
DateTime |
INTERVAL DAY |
TimeSpan |
INTERVAL DAY TO HOUR |
TimeSpan |
INTERVAL DAY TO MINUTE |
TimeSpan |
INTERVAL DAY TO SECOND |
TimeSpan |
INTERVAL HOUR |
TimeSpan |
INTERVAL HOUR TO SECOND |
TimeSpan |
INTERVAL MINUTE |
TimeSpan |
INTERVAL MINUTE TO SECOND |
TimeSpan |
INTERVAL SECOND |
TimeSpan |
NUMERIC |
When p <= 9 and
s = 0: Integer When p <= 28: Currency |
Any other data types are not supported.