Cassandra Connector > Data Type Reference > Cassandra and transformation data types
  

Cassandra and transformation data types

The following table describes the data types that Data Integration supports for Cassandra sources and targets:
Cassandra Data Type
Transformation Data Type
Range and Description for the Transformation Data Type
ASCII
String
1 to 104,857,600 characters.
BIGINT
Bigint
-9,223,372,036,854,775,808 to 9,223,372,036,854,775,807
Precision 19, scale 0
BOOLEAN
String
1 to 104,857,600 characters.
DECIMAL
Decimal
For transformations that support precision up to 38 digits, the precision is 1 to 38 digits, and the scale is 0 to 38.
For transformations that support precision up to 28 digits, the precision is 1 to 28 digits, and the scale is 0 to 28.
If you specify the precision greater than the maximum number of digits, the Cassandra converts decimal values to double in high precision mode.
DATE
Date/Time
Jan 1, 0001 A.D. to Dec 31, 9999 A.D.
(precision to the nanosecond)
DOUBLE
Double
Precision 15.
FLOAT
Decimal
For transformations that support precision up to 38 digits, the precision is 1 to 38 digits, and the scale is 0 to 38.
For transformations that support precision up to 28 digits, the precision is 1 to 28 digits, and the scale is 0 to 28.
If you specify the precision greater than the maximum number of digits, the Secure Agent decimal values to double in high precision mode.
INET
String
1 to 104,857,600 characters.
INT
Integer
-2,147,483,648 to 2,147,483,647
Precision of 10
TEXT
String
1 to 104,857,600 characters.
TIME
Date/Time
Jan 1, 0001 A.D. to Dec 31, 9999 A.D.
(precision to the nanosecond)
TIMESTAMP
Date/Time
Jan 1, 0001 A.D. to Dec 31, 9999 A.D.
(precision to the nanosecond)
TIMEUUID
String
1 to 104,857,600 characters.
UUID
String
1 to 104,857,600 characters.
VARCHAR
String
1 to 104,857,600 characters.
VARINT
Bigint
-9,223,372,036,854,775,808 to 9,223,372,036,854,775,807
Precision 19, scale 0
LIST
NA
Simba Cassandra JDBC driver re-normalizes the data in the list into virtual tables.
MAP
NA
Simba Cassandra JDBC driver re-normalizes the data in the map into virtual tables.
SET
NA
Simba Cassandra JDBC driver re-normalizes the data in the set into virtual tables.