Supported Cassandra APIs, Operations, and Data Types in Amazon Keyspaces (for Apache Cassandra) - Amazon Keyspaces (for Apache Cassandra)

Supported Cassandra APIs, Operations, and Data Types in Amazon Keyspaces (for Apache Cassandra)

Amazon Keyspaces (for Apache Cassandra) is compatible with Cassandra Query Language (CQL) 3.11 API (backward-compatible with version 2.x).

Amazon Keyspaces supports all commonly used Cassandra data-plane operations, such as creating keyspaces and tables, reading data, and writing data.

The following sections list the supported functionality.

Cassandra API Support

API Supported

CREATE KEYSPACE

Yes

ALTER KEYSPACE

Yes

DROP KEYSPACE

Yes

CREATE TABLE

Yes

ALTER TABLE

Yes

DROP TABLE

Yes

CREATE INDEX

No

DROP INDEX

No

UNLOGGED BATCH

Yes

LOGGED BATCH

No

SELECT

Yes

INSERT

Yes

DELETE

Yes

UPDATE

Yes

USE

Yes

CREATE TYPE

No

ALTER TYPE

No

DROP TYPE

No

CREATE TRIGGER

No

DROP TRIGGER

No

CREATE FUNCTION

No

DROP FUNCTION

No

CREATE AGGREGATE

No

DROP AGGREGATE

No

CREATE MATERIALIZED VIEW

No

ALTER MATERIALIZED VIEW

No

DROP MATERIALIZED VIEW

No

TRUNCATE

No

Cassandra Control Plane API Support

Because Amazon Keyspaces is managed, the Cassandra control plane APIs to manage cluster and node settings are not required. As a result, the following Cassandra features are not applicable.

Feature Reason

Durable writes toggle

All writes are durable

Read repair settings

Not applicable

GC grace seconds

Not applicable

Bloom filter settings

Not applicable

Compaction settings

Not applicable

Compression settings

Not applicable

Caching settings

Not applicable

Security settings

Replaced by IAM

Cassandra Data Type Support

Data Type Supported

ascii

Yes

bigint

Yes

blob

Yes

boolean

Yes

counter

Yes

date

Yes

decimal

Yes

double

Yes

float

Yes

frozen

No

inet

Yes

int

Yes

list

Yes

map

Yes

set

Yes

smallint

Yes

static

No

text

Yes

time

Yes

timestamp

Yes

timeuuid

Yes

tinyint

Yes

tuple

Yes

user-defined types (UDT)

No

uuid

Yes

varchar

Yes

varint

Yes