Bringing together the Apache Cassandra experts from the community and DataStax.

Want to learn? Have a question? Want to share your expertise? You are in the right place!

Not sure where to begin? Getting Started

 

question

Aravind Palani avatar image
Aravind Palani asked ·

Is Cassandra column-oriented?

How come Cassandra column oriented since sstable storing records as rows

cassandra
1 comment
10 |1000 characters needed characters left characters exceeded

Up to 8 attachments (including images) can be used with a maximum of 1.0 MiB each and 10.0 MiB total.

Just letting you know that we've had a high volume of questions in the last 48 hours and we've been caught up with the FREE Cassandra Workshop Series so our responses are delayed but we will get to them in the next few hours. Cheers!

0 Likes 0 ·
Erick Ramirez avatar image
Erick Ramirez answered ·

Unfortunately, the term column-oriented (or columnar) gets mixed a lot with column family for databases. Apache Cassandra is not a column-oriented database.

Cassandra stores data in column families -- a collection of rows which can contain any columns in a sparse fashion. Storage is sparse since only columns that exist are stored in rows. Rows can have any number of columns unlike tables in relational databases which have a fixed size.

In contrast, column-oriented databases store data by field (instead of rows) and are designed for analytics workloads since performing operations such as aggregation is much faster when the all the field (column) values is easily retrieved from disk. Cassandra doesn't store data in this way at all so there's no relation to this kind of database. Cheers!

Share
10 |1000 characters needed characters left characters exceeded

Up to 8 attachments (including images) can be used with a maximum of 1.0 MiB each and 10.0 MiB total.

laxmikant.hcl_32751 avatar image
laxmikant.hcl_32751 answered ·

No. Cassandra is basically a column-family store . This guy has explained the difference clearly.

Share
10 |1000 characters needed characters left characters exceeded

Up to 8 attachments (including images) can be used with a maximum of 1.0 MiB each and 10.0 MiB total.