question

Aravind Palani avatar image
Aravind Palani asked Erick Ramirez answered

Is Cassandra column-oriented?

How come Cassandra column oriented since sstable storing records as rows

cassandra
1 comment
10 |1000

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

Erick Ramirez avatar image Erick Ramirez ♦♦ commented ·

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 ·
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

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

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

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