Follow along to learn how to create universally unique identifiers (UUIDs), and delete columns and rows in Cassandra.
- [Instructor] In this exercise,…we're going to start our CQL shell,…using the cqlsh command.…And I'm just going to clear this.…And I'm going to maximize the size.…There.…Okay, so now we're in Cassandra.…What I want to do, is first of all…I want to use the key space, perfmonitor;…which I created in our previous exercise.…And I've created that,…and now I'm using that by default.…
Now what I'd like to do in this exercise…is create a table and show you…how to use the UUID function…to create universally unique identifiers…and also, how do delete a column from a single row,…and then also how to delete an entire row.…So we'll start by creating a table called devices,…and I'll use the create table command.…And I'll name this table devices.…And I'm going to add an ID,…which is a UUID;…and that'll be our primary key…which I'll specify later.…
And we'll give each device a name,…which will be text.…And we can have IP addresses.…Now, there can be multiple IP addresses,…if sometimes network devices are multi-homed.…So I'm going to use a set for this.…
- Cassandra architecture
- Keyspaces, tables, and columns
- Installing Java and Cassandra
- CQL data types
- Designing Cassandra tables
- Tuning tables to optimize queries
- When to use secondary indexes and materialized views
- Physical data modeling and distributing data
- Cassandra architecture and its impact on data modeling
Skill Level Intermediate
1. Cassandra Architecture
2. Cassandra Query Language Data Types
3. Designing Cassandra Tables
4. Physical Data Modeling and Distributing Data
Replication in Cassandra2m 1s
5. Cassandra Architecture and Its Impact on Data Modeling
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.