Hacker News Reader

Cassandra isn't columnar, it's row-oriented. The original authors coined a new term "column family" which is just a nonsense (and confusing) term, meant to describe its original relatively unstructured API, which has unfortunately stuck in all descriptions of the database, and leads to confusion like this.

Cassandra is also not an analytics database, it is intended for "OLTP"-like workloads.

View on HN

Thanks. I wanted another example other than Snowflake so I did a quick Google search and grabbed the first example from the top search summary box that I recognized.

I always considered Cassandra's 'column' designation a guarantee that OLTP transactions will apply atomically to column groups; or that you'll minimize IO writes for a row to the column group (as opposed to writing a new version of the entire row). But this is actually just a wild guess. Anyone want to chime in and confirm/deny?

Reply on news.ycombinator.com