# Supported Cassandra APIs, operations, functions, and data types
<a name="cassandra-apis"></a>

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
](#cassandra-api-support)
+ [

## Cassandra control plane API support
](#cassandra-control-plane-apis)
+ [

## Cassandra data plane API support
](#cassandra-data-plane-apis)
+ [

## Cassandra function support
](#cassandra-functions)
+ [

## Cassandra data type support
](#cassandra-data-type)

## Cassandra API support
<a name="cassandra-api-support"></a>


| 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`  |  Yes  | 
|  `SELECT`  |  Yes  | 
|  `INSERT`  |  Yes  | 
|  `DELETE`  |  Yes  | 
|  `UPDATE`  |  Yes  | 
|  `USE`  |  Yes  | 
|  `CREATE TYPE`  |  Yes  | 
|  `ALTER TYPE`  |  No  | 
|  `DROP TYPE`  |  Yes  | 
|  `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
<a name="cassandra-control-plane-apis"></a>

 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
<a name="cassandra-data-plane-apis"></a>


| Feature | Supported | 
| --- | --- | 
|  JSON support for SELECT and INSERT statements  |  Yes  | 
|  Static columns  |  Yes  | 
|  Time to Live (TTL)  |  Yes  | 

## Cassandra function support
<a name="cassandra-functions"></a>

For more information about the supported functions, see [Built-in functions in Amazon Keyspaces](cql.functions.md).


| 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
<a name="cassandra-data-type"></a>

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](cql.elements.md#cql.data-types).


| Data type | Supported | 
| --- | --- | 
|  `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` (`UDTs`)  |  Yes  | 
|  `uuid`  |  Yes  | 
|  `varchar`  |  Yes  | 
|  `varint`  |  Yes  |