Cloudera Impala 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 a Cloudera Impala database.

Cloudera Impala Data Type	Spotfire Data Type
BOOLEAN	Boolean/Bool
TIMESTAMP	DateTime
INT	Integer/Int
SMALLINT	Integer/Int
TINYINT	Integer/Int
BIGINT	LongInteger/Long
DOUBLE	Real/Double
FLOAT	SingleReal/Float
CHAR	String
STRING	String
VARCHAR	String
DECIMAL(p,s)	When p <= 9 and s = 0: Integer When 9 < p <= 18 and s = 0: LongInteger Else: Real

Any other data types are not supported.