• Apache Cassandra 4.0
  • Installation: Build from Source
• Yugabyte - https://www.yugabyte.com/
  • “YCQL is a transactional flexible-schema API that is compatible with the Cassandra Query Language (CQL). “
  • Installation: Docker
• ScyllaDB - https://www.scylladb.com/
  • “Apache Cassandra’s wire protocol, a rich polyglot of drivers, and integration with Spark, Presto, and Graph tools make for resource-efficient and performance-effective coding.”
  • Installation: Docker
• Azure Cosmos - https://azure.microsoft.com/en-us/services/cosmos-db/
  • “Azure Cosmos DB provides native support for NoSQL and OSS APIs including MongoDB, Cassandra, Gremlin and SQL”
  • Installation: Azure Portal Wizard

What was tested

1. Keyspace Creation
2. Table Creation
3. Adding a Column to a table (Alter table)
4. Data Insert
5. Data Insert with TTL (Time-to-live)
6. Data Insert with LWT (Lightweight Transactions)
7. Select Data
8. Select data with a full table scan (ALLOW FILTERING)
9. Creating a Secondary Index (2I)

Cassandra 4.0

• All statements worked (as expected)

CosmosDB

Scylla

Yugabyte

Results Table