Nav

Cassandra Connector Data Types Reference

The Cassandra connector supports the following CQL primitive data types only:

ascii

counter

float

text

tinyint

bigint

date

inet

time

uuid

blob

decimal

int

timestamp

varchar

boolean

double

smallint

timeuuid

varint

The following operations require you to specify the column type, or new column type in the case of Change Column Type, and accept only primitive data types:

  • Create Table

  • Change column type

  • Add new column

Unsupported Data Types

The Cassandra connector does not support the following CQL data types:

  • list

  • map

  • set

  • tuple

To create a table with columns of unsupported CQL types, or to add a new column of a complex type to an existing table, use the Execute CQL operation.

Data Type Mapping

The connector maps the primitive data types using uppercase. You need to specify data types in one of the following ways:

  • Use uppercase for names of data types

  • Use a transformer to map the type to uppercase:

{
 "columns": payload.columns map {
  name: $.name,
  primaryKey: $.primaryKey,
  type: upper $.type
 }

See Also