Understanding how Apache Cassandra organizes data under the hood is essential to knowing how to use it properly. When examining Cassandra's data organization, it is important to determine which version of Apache Cassandra you are working with. Apache Cassandra 3.0 represents a significant shift in the way data is both stored and accessed, which warrants a discussion on the evolution of CQL.
Before we get started, let's create a keyspace for this chapter's work:
CREATE KEYSPACE packt_ch3 WITH replication =
{'class': 'NetworkTopologyStrategy', 'ClockworkAngels':'1'};
To preface this discussion, let's create an example table. Let's assume that we want to store data about a music playlist, including the band's name, albums, song titles, and some additional data about the songs...