SQL Reference Guide > SQL Reference Guide > G. Spark Data Type Mapping
Was this helpful?
Spark Data Type Mapping
Actian X data types map to Spark data types as follows:
Actian X Data Type
Spark Data Type
CHAR, VARCHAR, NCHAR, NVARCHAR
string
INTEGER, INTEGER1, INTEGER2, INTEGER4
int, integer
INTEGER8, BIGINT
long
DECIMAL
double
FLOAT
double
FLOAT4
float
ANSIDATE, DATE
date
TIME, TIMESTAMP
timestamp
MONEY
double
IPV4
string
IPV6
string
UUID
string
BOOLEAN
boolean
 
Last modified date: 08/14/2024