Difficulty: Beginner
Estimated Time: 15 minutes

In this scenario, you will:

  • Create tables for a time series use case
  • Populate tables with sample time series data
  • Design and execute CQL queries over time series data

This scenario is also available on our datastax.com/dev site, where you can find many more resources to help you succeed with Apache Cassandra™.

In this scenario, you explored:

  • Schema design for a time series use case
  • Sample time series data
  • CQL queries over time series data

Time Series Data Modeling Example for Cassandra

Step 1 of 11

Create a keyspace

Create the time_series keyspace:

cqlsh -e "

CREATE KEYSPACE time_series
WITH replication = {
  'class': 'NetworkTopologyStrategy', 
  'DC-Houston': 1 };"