DataStax Academy FAQ

DataStax Academy migrated to a new learning management system (LMS) in July 2020. We are also moving to a new Cassandra Certification process so there are changes to exam bookings, voucher system and issuing of certificates.

Check out the Academy FAQ pages for answers to your questions:


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.