Why Wide-Column Stores Like Cassandra, Bigtable, and ScyllaDB Dominate High-Throughput Firehose Workloads
Wide-column stores such as Cassandra, Bigtable and ScyllaDB are built for firehose-scale writes and predictable single-partition reads, making them the go-to choice for services like Netflix, Discord and Google Search indexing. They sacrifice ad-hoc SQL, joins and multi-partition transactions, so you must design tables around exact query patterns.