From the course: Cassandra Data Modeling Essential Training
Join today to access over 24,700 courses taught by industry experts.
Secondary indexes - Cassandra Tutorial
From the course: Cassandra Data Modeling Essential Training
Secondary indexes
- [Instructor] We design Cassandra tables to answer specific queries. Ideally, our tables can be used to answer multiple queries. Sometimes this falls out naturally, for example, in this table called devices, we can answer queries about devices and their installation year as well as devices and their installation date. Let's modify the table to include the name of the server manufacturer. Now we have a table that has information about devices, location, installation date, and manufacturer. The table uses installation year as a partition key. So that determines which node stores the data. It uses installation date and ID as a clustering key. With this, we can look up rows in the table using the primary key. But if we want to select results by manufacturer name, we can't do it with that table definition. We could create another table and cluster by manufacturer with this command. This solution solves the selecting problem…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.