Vertica Data Types

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 9 < p <= 18 and s = 0: LongInteger When p <= 28: Currency Else: Real

Any other data types are not supported.