skip to main content
Welcome to the Progress DataDirect for JDBC for Apache Cassandra Driver : Data Types
  

Try DataDirect Drivers Now

Data Types

The following table lists the Cassandra data types supported by the driver and how they are mapped to JDBC data types.
The complex types List, Map, Set, Tuple, and user-defined types have no direct JDBC mapping. However, the driver normalizes these types to provide SQL access to Cassandra. For details on how complex types are mapped, see "Complex Type Normalization."
See "getTypeInfo()" for getTypeInfo() results of data types supported by the driver.
Table 13. Data Type Mapping
Apache Cassandra
JDBC
ASCII
VARCHAR
BIGINT
BIGINT
BLOB
LONGVARBINARY
BOOLEAN
BOOLEAN
COUNTER 1
BIGINT
DATE 2
DATE
DECIMAL
DECIMAL
DOUBLE
DOUBLE
FLOAT
REAL
INET
VARCHAR
INT
INTEGER
LIST 3
LONGVARCHAR
MAP 4
LONGVARCHAR
SET 5
LONGVARCHAR
SMALLINT 6
SMALLINT
TIME 7
TIME
TIMESTAMP
TIMESTAMP
TIMEUUID
CHAR
TINYINT 8
TINYINT
TUPLE 9
LONGVARCHAR
USERTYPE 10
LONGVARCHAR
UUID
CHAR
VARCHAR
VARCHAR
VARINT
DECIMAL
1 Update is supported for Counter columns when all the other columns in the row comprise that row’s primary key. See Update for details.

2 Supported for Apache Cassandra 2.2 and higher.

3 See Complex Type Normalization for details on how complex types are mapped.

4 See Complex Type Normalization for details on how complex types are mapped.

5 See Complex Type Normalization for details on how complex types are mapped.

6 Supported for Apache Cassandra 2.2 and higher.

7 Supported for Apache Cassandra 2.2 and higher.

8 Supported for Apache Cassandra 2.2 and higher.

9 See Complex Type Normalization for details on how complex types are mapped.

10 Also referred to as user-defined types. These are data types created with the CQL CREATE TYPE statement. See Complex Type Normalization for details on how Usertype is mapped.

* getTypeInfo()