Supported Cassandra APIs, operations, functions, and data types
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.
Topics
Cassandra API support
API operation | Supported |
---|---|
|
Yes |
|
Yes |
|
Yes |
|
Yes |
|
Yes |
|
Yes |
|
No |
|
No |
|
Yes |
|
No |
|
Yes |
|
Yes |
|
Yes |
|
Yes |
|
Yes |
|
Yes |
|
No |
|
Yes |
|
No |
|
No |
|
No |
|
No |
|
No |
|
No |
|
No |
|
No |
|
No |
|
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 |
---|---|
|
No |
|
Yes |
|
Yes |
|
Yes |
Timeconversion functions |
Yes |
|
Yes |
|
Yes |
|
No |
|
Yes |
Cassandra data type support
The following table lists the Apache Cassandra data types supported in Amazon Keyspaces. For more information about data types in Amazon Keyspaces, see Data types.
Data type | Supported |
---|---|
|
Yes |
|
Yes |
|
Yes |
|
Yes |
|
Yes |
|
Yes |
|
Yes |
|
Yes |
|
Yes |
|
Yes |
|
Yes |
|
Yes |
|
Yes |
|
Yes |
|
Yes |
|
Yes |
|
Yes |
|
Yes |
|
Yes |
|
Yes |
|
Yes |
|
Yes |
|
Yes |
|
Yes |
|
Yes |
|
Yes |