Supported Cassandra APIs, operations, functions, and data types in Amazon Keyspaces - Amazon Keyspaces (for Apache Cassandra)

Supported Cassandra APIs, operations, functions, and data types in Amazon Keyspaces

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 operation 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 API operations 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 plane API support

Feature Supported

JSON support for SELECT and INSERT statements

Yes

Static columns

Yes

Time to Live (TTL)

Yes

Cassandra function support

For more information about the supported functions, see Built-in functions in Amazon Keyspaces.

Function Supported

Aggregate functions

No

Blob conversion

Yes

Cast

Yes

Datetime functions

Yes

Timeconversion functions

Yes

TimeUuid functions

Yes

Token

Yes

User defined functions (UDF)

No

Uuid

Yes

Cassandra data type support

Data type Supported Note

ascii

Yes

bigint

Yes

blob

Yes

boolean

Yes

counter

Yes

date

Yes

decimal

Yes

double

Yes

float

Yes

frozen

Yes

inet

Yes

int

Yes

list

Yes

map

Yes

set

Yes

smallint

Yes

text

Yes

time

Yes

timestamp

Yes

timeuuid

Yes

tinyint

Yes

tuple

Yes

user-defined types (UDT)

No

To refactor UDTs with Protocol Buffers, see Amazon Keyspaces Protocol Buffers.

uuid

Yes

varchar

Yes

varint

Yes