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 an HP Vertica database.
HP Vertica Database Type |
Spotfire Data Type |
Supported |
BOOLEAN |
Boolean |
Yes |
INTEGER |
Integer |
Yes |
BIGINT |
LongInteger |
Yes |
VARBINARY |
Binary |
Yes |
BINARY |
Binary |
Yes |
CHAR |
String |
Yes |
VARCHAR |
String |
Yes |
MONEY |
Currency |
Yes |
NUMERIC |
When p <= 9 and
s = 0: Integer |
Yes |
DOUBLE |
Real |
Yes |
FLOAT |
SingleReal |
Yes |
DATE |
Date |
Yes |
TIME |
Time |
Yes |
TIMETZ |
Time |
Yes |
TIMESTAMPTZ |
DateTime |
Yes |
TIMESTAMP |
DateTime |
Yes |
INTERVAL DAY |
TimeSpan |
Yes |
INTERVAL HOUR |
TimeSpan |
Yes |
INTERVAL MINUTE |
TimeSpan |
Yes |
INTERVAL SECOND |
TimeSpan |
Yes |
INTERVAL DAY TO HOUR |
TimeSpan |
Yes |
INTERVAL DAY TO MINUTE |
TimeSpan |
Yes |
INTERVAL DAY TO SECOND |
TimeSpan |
Yes |
INTERVAL HOUR TO SECOND |
TimeSpan |
Yes |
INTERVAL MINUTE TO SECOND |
TimeSpan |
Yes |
INTERVAL YEAR |
|
No |
INTERVAL YEAR TO MONTH |
|
No |
INTERVAL MONTH |
|
No |
Any other data types are not supported.
See also:
Details on HP Vertica Connection