Wide-column stores vs columnar databases — what is the difference?

Answer preview

Despite the similar names these solve opposite problems. A wide-column store (Cassandra, HBase, Bigtable) is a row-oriented OLTP store whose rows may have millions of sparse columns. Columnar storage (Parquet, Redshift, ClickHouse, BigQuery) physically stores each column separate…