ScyllaDB University LIVE, FREE Virtual Training Event | March 21
Register for Free
ScyllaDB Documentation Logo Documentation
  • Server
  • Cloud
  • Tools
    • ScyllaDB Manager
    • ScyllaDB Monitoring Stack
    • ScyllaDB Operator
  • Drivers
    • CQL Drivers
    • DynamoDB Drivers
  • Resources
    • ScyllaDB University
    • Community Forum
    • Tutorials
Download
ScyllaDB Docs ScyllaDB Enterprise Getting Started Migrate to ScyllaDB ScyllaDB and Apache Cassandra Compatibility

Caution

You're viewing documentation for a previous version. Switch to the latest stable version.

ScyllaDB and Apache Cassandra Compatibility¶

ScyllaDB is a drop-in replacement for Apache Cassandra 3.11, with additional features from Apache Cassandra 4.0. This page contains information about ScyllaDB compatibility with Apache Cassandra.

The tables on this page include information about ScyllaDB support for Apache Cassandra features. They do not include the ScyllaDB-specific features with no match in Apache Cassandra. See ScyllaDB Features for more information about ScyllaDB features.

How to Read the Tables on This Page¶

  • - Available in ScyllaDB and compatible with Apache Cassandra.

  • - Not available in ScyllaDB.

  • NC - Available in ScyllaDB, but not compatible with Apache Cassandra.

Interfaces¶

Apache Cassandra Interface

Version Supported by ScyllaDB

Comments

CQL

Fully compatible with version 3.3.1, with additional features from later CQL versions (for example, Duration type).
Fully compatible with protocol v4, with additional features from v5.

More below

Thrift

Not supported anymore in ScyllaDB 6.0

deprecated in Apache Cassandra and got dropped in 4.0
deprecated in ScyllaDB 5.2 and got dropped in 6.0

SSTable format (all versions)

3.11(mc / md / me), 2.2(la), 2.1.8 (ka)

me - supported in ScyllaDB 2022.2.0 and later
md - supported in ScyllaDB 2021.1.0 and later

JMX

3.11

More below

Configuration (cassandra.yaml)

3.11

Log

NC

Gossip and internal streaming

NC

SSL

NC

Supported Tools¶

The tools are based on Apache Cassandra 3.11.

  • Nodetool Reference - ScyllaDB commands for managing ScyllaDB node or cluster using the command-line nodetool utility.

  • CQLSh - the CQL shell.

  • Admin REST API - ScyllaDB Node Admin API.

  • Tracing - a ScyllaDB tool for debugging and analyzing internal flows in the server.

  • SSTableloader - Bulk load the sstables found in the directory to a ScyllaDB cluster

  • ScyllaDB SStable - Validates and dumps the content of SStables, generates a histogram, dumps the content of the SStable index.

  • ScyllaDB Types - Examines raw values obtained from SStables, logs, coredumps, etc.

  • cassandra-stress A tool for benchmarking and load testing a ScyllaDB and Cassandra clusters.

  • SSTabledump

  • SSTableMetadata

  • scylla local-file-key-generator - Generate a local file (system) key for encryption at rest, with the provided length, Key algorithm, Algorithm block mode and Algorithm padding method.

  • scyllatop - A terminal base top-like tool for scylladb collectd/prometheus metrics.

  • scylla_dev_mode_setup - run ScyllaDB in Developer Mode.

  • perftune - performance configuration.

  • Reading mutation fragments - dump the underlying mutation data from tables.

  • Maintenance socket - a Unix domain socket for full-permission CQL connection.

  • Maintenance mode - a mode for performing maintenance tasks on an offline ScyllaDB node.

  • Task manager - a tool for tracking long-running background operations.

Run each tool with -h, --help for full options description.

Features¶

Consistency Level (read and write)¶

Options

Support

Any (Write Only)

One

Two

Three

Quorum

All

Local One

Local Quorum

Each Quorum (Write Only)

SERIAL

*

LOCAL_SERIAL

*

* See ScyllaDB LWT.

Snitches¶

Options

Support

SimpleSnitch

RackInferringSnitch

PropertyFileSnitch

GossipingPropertyFileSnitch

Dynamic snitching

EC2Snitch

EC2MultiRegionSnitch

GoogleCloudSnitch

CloudstackSnitch

AzureSnitch

Partitioners¶

Options

Support

Murmur3Partitioner (default)

RandomPartitioner

OrderPreservingPartitioner

ByteOrderedPartitioner

CollatingOrderPreservingPartitioner

Protocol Options¶

Options

Support

Encryption

Authentication

Compression (see below)

Compression¶

Options

Support

CQL Compression

LZ4

Snappy

Node to Node Compression

Client to Node Compression

Backup and Restore¶

Options

Support

Snapshot

Incremental backup

Restore

Repair and Consistency¶

Options

Support

Nodetool Repair

Incremental Repair

Hinted Handoff

Lightweight Transactions

Replica Replacement Strategy¶

Options

Support

SimpleStrategy

NetworkTopologyStrategy

Security¶

Options

Support

Role Based Access Control (RBAC)

Indexing and Caching¶

Options

Support

Secondary Index

Materialized Views

Additional Features¶

Feature

Support

Counters

User Defined Types

User Defined Functions

*

Time to live (TTL)

Super Column

vNode Enable

Default

vNode Disable

Triggers

Batch Requests

Includes conditional updates

* Experimental

CQL Command Compatibility¶

Create Keyspace¶

Feature

Support

DURABLE_WRITES

IF NOT EXISTS

WITH REPLICATION

(see below)

Create Keyspace with Replication¶

Feature

Support

SimpleStrategy

NetworkTopologyStrategy

OldNetworkTopologyStrategy

Create Table¶

Feature

Support

Primary key column

Compound primary key

Composite partition key

Clustering order

Static column

Create Table Att¶

Feature

Support

bloom_filter_fp_chance

caching

(ignored)

comment

compaction

compression

default_time_to_live

gc_grace_seconds

index_interval

max_index_interval

memtable_flush_period_in_ms

(ignored)

min_index_interval

populate_io_cache_on_flush

replicate_on_write

speculative_retry

ALWAYS, NONE

Create Table Compaction¶

Feature

Support

SizeTieredCompactionStrategy (STCS)

LeveledCompactionStrategy (LCS)

DateTieredCompactionStrategy (DTCS)

*

TimeWindowCompactionStrategy (TWCS)

* No longer supported. Use TimeWindowCompactionStrategy (TWCS) instead.

Create Table Compression¶

Feature

Support

sstable_compression LZ4Compressor

sstable_compression SnappyCompressor

sstable_compression DeflateCompressor

chunk_length_kb

crc_check_chance

Alter Commands¶

Feature

Support

ALTER KEYSPACE

ALTER TABLE

ALTER TYPE

ALTER USER

ALTER ROLE

Data Manipulation¶

Feature

Support

BATCH

INSERT

Prepared Statements

SELECT

TRUNCATE

UPDATE

USE

Create Commands¶

Feature

Support

CREATE TRIGGER

CREATE USER

CREATE ROLE

Drop Commands¶

Feature

Support

DROP KEYSPACE

DROP TABLE

DROP TRIGGER

DROP TYPE

DROP USER

DROP ROLE

Roles and Permissions¶

Feature

Support

GRANT PERMISSIONS

GRANT ROLE

LIST PERMISSIONS

LIST USERS

LIST ROLES

REVOKE PERMISSIONS

REVOKE ROLE

Materialized Views¶

Feature

Support

MATERIALIZED VIEW

ALTER MATERIALIZED VIEW

CREATE MATERIALIZED VIEW

DROP MATERIALIZED VIEW

Index commands¶

Feature

Support

INDEX

CREATE INDEX

DROP INDEX

© 2016, The Apache Software Foundation.

Apache®, Apache Cassandra®, Cassandra®, the Apache feather logo and the Apache Cassandra® Eye logo are either registered trademarks or trademarks of the Apache Software Foundation in the United States and/or other countries. No endorsement by The Apache Software Foundation is implied by the use of these marks.

Was this page helpful?

PREVIOUS
Apache Cassandra to ScyllaDB Migration Process
NEXT
ScyllaDB Migration Tools: An Overview
  • Create an issue

On this page

  • ScyllaDB and Apache Cassandra Compatibility
    • How to Read the Tables on This Page
    • Interfaces
    • Supported Tools
    • Features
      • Consistency Level (read and write)
      • Snitches
      • Partitioners
      • Protocol Options
      • Compression
      • Backup and Restore
      • Repair and Consistency
      • Replica Replacement Strategy
      • Security
      • Indexing and Caching
      • Additional Features
    • CQL Command Compatibility
      • Create Keyspace
      • Create Keyspace with Replication
      • Create Table
        • Create Table Att
        • Create Table Compaction
        • Create Table Compression
        • Alter Commands
        • Data Manipulation
        • Create Commands
        • Drop Commands
        • Roles and Permissions
        • Materialized Views
        • Index commands
ScyllaDB Enterprise
  • enterprise
    • 2024.2
    • 2024.1
    • 2023.1
    • 2022.2
  • Getting Started
    • Install ScyllaDB Enterprise
      • ScyllaDB Web Installer for Linux
      • Install ScyllaDB Without root Privileges
      • Install scylla-jmx Package
      • Air-gapped Server Installation
      • ScyllaDB Housekeeping and how to disable it
      • ScyllaDB Developer Mode
      • Launch ScyllaDB on AWS
      • Launch ScyllaDB on GCP
      • Launch ScyllaDB on Azure
    • Configure ScyllaDB
    • ScyllaDB Configuration Reference
    • ScyllaDB Requirements
      • System Requirements
      • OS Support
      • Cloud Instance Recommendations
      • ScyllaDB in a Shared Environment
    • Migrate to ScyllaDB
      • Migration Process from Cassandra to ScyllaDB
      • ScyllaDB and Apache Cassandra Compatibility
      • Migration Tools Overview
    • Integration Solutions
      • Integrate ScyllaDB with Spark
      • Integrate ScyllaDB with KairosDB
      • Integrate ScyllaDB with Presto
      • Integrate ScyllaDB with Elasticsearch
      • Integrate ScyllaDB with Kubernetes
      • Integrate ScyllaDB with the JanusGraph Graph Data System
      • Integrate ScyllaDB with DataDog
      • Integrate ScyllaDB with Kafka
      • Integrate ScyllaDB with IOTA Chronicle
      • Integrate ScyllaDB with Spring
      • Shard-Aware Kafka Connector for ScyllaDB
      • Install ScyllaDB with Ansible
      • Integrate ScyllaDB with Databricks
      • Integrate ScyllaDB with Jaeger Server
      • Integrate ScyllaDB with MindsDB
    • Tutorials
  • ScyllaDB for Administrators
    • Administration Guide
    • Procedures
      • Cluster Management
      • Backup & Restore
      • Change Configuration
      • Maintenance
      • Best Practices
      • Benchmarking ScyllaDB
      • Migrate from Cassandra to ScyllaDB
      • Disable Housekeeping
    • Security
      • ScyllaDB Security Checklist
      • Enable Authentication
      • Enable and Disable Authentication Without Downtime
      • Creating a Custom Superuser
      • Generate a cqlshrc File
      • Reset Authenticator Password
      • Enable Authorization
      • Grant Authorization CQL Reference
      • Certificate-based Authentication
      • Role Based Access Control (RBAC)
      • ScyllaDB Auditing Guide
      • Encryption: Data in Transit Client to Node
      • Encryption: Data in Transit Node to Node
      • Generating a self-signed Certificate Chain Using openssl
      • Configure SaslauthdAuthenticator
      • Encryption at Rest
      • LDAP Authentication
      • LDAP Authorization (Role Management)
      • Software Bill Of Materials (SBOM)
    • Admin Tools
      • Nodetool Reference
      • CQLSh
      • Admin REST API
      • Tracing
      • ScyllaDB SStable
      • ScyllaDB Types
      • SSTableLoader
      • cassandra-stress
      • SSTabledump
      • SSTableMetadata
      • ScyllaDB Logs
      • Seastar Perftune
      • Virtual Tables
      • Reading mutation fragments
      • Maintenance socket
      • Maintenance mode
      • Task manager
    • Version Support Policy
    • ScyllaDB Monitoring Stack
    • ScyllaDB Operator
    • ScyllaDB Manager
    • Upgrade Procedures
      • About Upgrade
      • Upgrade Guides
    • System Configuration
      • System Configuration Guide
      • scylla.yaml
      • ScyllaDB Snitches
    • Benchmarking ScyllaDB
    • ScyllaDB Diagnostic Tools
  • ScyllaDB for Developers
    • Develop with ScyllaDB
    • Tutorials and Example Projects
    • Learn to Use ScyllaDB
    • ScyllaDB Alternator
    • ScyllaDB Drivers
      • ScyllaDB CQL Drivers
      • ScyllaDB DynamoDB Drivers
  • CQL Reference
    • CQLSh: the CQL shell
    • Appendices
    • Compaction
    • Consistency Levels
    • Consistency Level Calculator
    • Data Definition
    • Data Manipulation
      • SELECT
      • INSERT
      • UPDATE
      • DELETE
      • BATCH
    • Data Types
    • Definitions
    • Global Secondary Indexes
    • Expiring Data with Time to Live (TTL)
    • Functions
    • Wasm support for user-defined functions
    • JSON Support
    • Materialized Views
    • Non-Reserved CQL Keywords
    • Reserved CQL Keywords
    • DESCRIBE SCHEMA
    • Service Levels
    • ScyllaDB CQL Extensions
  • Features
    • Lightweight Transactions
    • Global Secondary Indexes
    • Local Secondary Indexes
    • Materialized Views
    • Counters
    • Change Data Capture
      • CDC Overview
      • The CDC Log Table
      • Basic operations in CDC
      • CDC Streams
      • CDC Stream Generations
      • Querying CDC Streams
      • Advanced column types
      • Preimages and postimages
      • Data Consistency in CDC
    • Workload Attributes
    • Workload Prioritization
  • ScyllaDB Architecture
    • Data Distribution with Tablets
    • ScyllaDB Ring Architecture
    • ScyllaDB Fault Tolerance
    • Consistency Level Console Demo
    • ScyllaDB Anti-Entropy
      • ScyllaDB Hinted Handoff
      • ScyllaDB Read Repair
      • ScyllaDB Repair
    • SSTable
      • ScyllaDB SSTable - 2.x
      • ScyllaDB SSTable - 3.x
    • Compaction Strategies
    • Raft Consensus Algorithm in ScyllaDB
    • Zero-token Nodes
  • Troubleshooting ScyllaDB
    • Errors and Support
      • Report a ScyllaDB problem
      • Error Messages
      • Change Log Level
    • ScyllaDB Startup
      • Ownership Problems
      • ScyllaDB will not Start
      • ScyllaDB Python Script broken
    • Upgrade
      • Inaccessible configuration files after ScyllaDB upgrade
    • Cluster and Node
      • Handling Node Failures
      • Failure to Add, Remove, or Replace a Node
      • Failed Decommission Problem
      • Cluster Timeouts
      • Node Joined With No Data
      • NullPointerException
      • Failed Schema Sync
    • Data Modeling
      • ScyllaDB Large Partitions Table
      • ScyllaDB Large Rows and Cells Table
      • Large Partitions Hunting
      • Failure to Update the Schema
    • Data Storage and SSTables
      • Space Utilization Increasing
      • Disk Space is not Reclaimed
      • SSTable Corruption Problem
      • Pointless Compactions
      • Limiting Compaction
    • CQL
      • Time Range Query Fails
      • COPY FROM Fails
      • CQL Connection Table
    • ScyllaDB Monitor and Manager
      • Manager and Monitoring integration
      • Manager lists healthy nodes as down
    • Installation and Removal
      • Removing ScyllaDB on Ubuntu breaks system packages
  • Knowledge Base
    • Upgrading from experimental CDC
    • Compaction
    • Consistency in ScyllaDB
    • Counting all rows in a table is slow
    • CQL Query Does Not Display Entire Result Set
    • When CQLSh query returns partial results with followed by “More”
    • Run ScyllaDB and supporting services as a custom user:group
    • Customizing CPUSET
    • Decoding Stack Traces
    • Snapshots and Disk Utilization
    • DPDK mode
    • Debug your database with Flame Graphs
    • Efficient Tombstone Garbage Collection in ICS
    • How to Change gc_grace_seconds for a Table
    • Gossip in ScyllaDB
    • Increase Permission Cache to Avoid Non-paged Queries
    • How does ScyllaDB LWT Differ from Apache Cassandra ?
    • Map CPUs to ScyllaDB Shards
    • ScyllaDB Memory Usage
    • NTP Configuration for ScyllaDB
    • Updating the Mode in perftune.yaml After a ScyllaDB Upgrade
    • POSIX networking for ScyllaDB
    • ScyllaDB consistency quiz for administrators
    • Recreate RAID devices
    • How to Safely Increase the Replication Factor
    • ScyllaDB and Spark integration
    • Increase ScyllaDB resource limits over systemd
    • ScyllaDB Seed Nodes
    • How to Set up a Swap Space
    • ScyllaDB Snapshots
    • ScyllaDB payload sent duplicated static columns
    • Stopping a local repair
    • System Limits
    • How to flush old tombstones from a table
    • Time to Live (TTL) and Compaction
    • ScyllaDB Nodes are Unresponsive
    • Update a Primary Key
    • Using the perf utility with ScyllaDB
    • Configure ScyllaDB Networking with Multiple NIC/IP Combinations
  • Reference
    • AWS Images
    • Azure Images
    • GCP Images
    • Configuration Parameters
    • Glossary
    • Limits
    • ScyllaDB Enterprise vs. Open Source Matrix
    • API Reference (BETA)
    • Metrics (BETA)
  • ScyllaDB University
  • ScyllaDB FAQ
  • Alternator: DynamoDB API in Scylla
    • Getting Started With ScyllaDB Alternator
    • ScyllaDB Alternator for DynamoDB users
    • Alternator-specific APIs
Docs Tutorials University Contact Us About Us
© 2025, ScyllaDB. All rights reserved. | Terms of Service | Privacy Policy | ScyllaDB, and ScyllaDB Cloud, are registered trademarks of ScyllaDB, Inc.
Last updated on 09 Apr 2025.
Powered by Sphinx 7.4.7 & ScyllaDB Theme 1.8.6