Cassandra Community Webinar | Understanding How CQL3 Maps to Cassandra's Internal Data Structure

CQL3 is the newly ordained, canonical, and best-practices means of interacting with Cassandra. Indeed, the Apache Cassandra documentation itself declares that the Thrift API as "legacy" and recommends that CQL3 be used instead. But I've heard several people express their concern over the added layer of abstraction. There seems to be an uncertainty about what's really happening inside of Cassandra.

In this presentation we will open up the hood and take a look at exactly how Cassandra is treating CQL3 queries. Our first stop will be the Cassandra data structure itself. We will briefly review the concepts of keyspaces, columnfamilies, rows, and columns. And we will explain where this data structure excels and where it does not. Composite rowkeys and columnnames are heavily used with CQL3, so we'll cover their functionality as well.

We will then turn to CQL3. I will demonstrate the basic CQL syntax and show how it maps to the underlying data structure. We will see that CQL actually serves as a sort of best practices interface to the internal Cassandra data structure. We will take this point further by demonstrating CQL3 collections (set, list, and map) and showing how they are really just a creative use of this same internal data structure.

Attendees will leave with a clear, inside-out understanding of CQL3 and will be able use CQL with a confidence that they are following best-practices.

[dineshkuruba]

This is the tutorial I was looking for ages and it cleared all my confusions around internal storage and cql queries.

[sanchitkumar]

The best explanation I can find on youtube!

[crhanks]

This video contains the detailed information I've been searching for concerning CQL3. Great Info and extremely understandable.

[bcarunmail]

This is a very good session on understanding CQL and how it transforms data to cassandra data structures.

[MrJuliancarroll]

Really good guide, and cleared up a number of questions. There is a lot of legacy stuff out there about cassandra cli, and New stuff about cql, but this is the first source to explain how the two are actually related.

[serversunny]

Really great tutorial. Clears a lot of doubt and really granular view of cassandra internals.

[psawmora]

Thanks for this mate. One of the best.

[amitasingh]

Its really help us to understand internal Data modal of Cassandra. Great Tutorial !

[vinaykumarcse]

This is a pretty good understanding on CQL3 to Cassandra internal data structure..

[advancedanalyticsbigdatada]

More detailed explanations about Cassandra read path.

[nisaradappadathil]

This is about Cassandra 2.x right Not the latest 3.x versions