Follow along to learn about creating data structures for time-series data.
- [Instructor] In this exercise,…we'll create a time series table.…Now I've opened a terminal window…in my Ubuntu that's running on VirtualBox.…Now I'm going to start the CQL shell.…I'm going to use the keyspace I created…in the previous exercise.…It's called perfmonitor.…The first thing I want to do is create a table.…I'm going to clear my screen…and issue the Create Table command.…The table I'm going to create is called…server_cpu_utilization.…
This will have several columns.…We'll have a server_id…which we'll make a varchar.…We'll have a measure_time…which we will make a timestamp.…We'll have cpu_utilization…which we'll make an int.…Then we'll define a primary key…to be the server_id…and the measure_time.…
We'll just double-check…using the Describe.…As expected,…it has the three attributes that we defined,…server_id, measure_time,…and cpu_utilization.…The primary key is as expected.…Then there's the other configuration information…that we've seen previously.…Now the next step is to insert some data into this table.…I'll clear the screen again.…
- 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.