step2-cassandra.md

Exercise 3.1: User Defined Types (UDTs) ℹ️ For technical support, please contact us via email.

⬅️ Back Step 2 of 4 Next ➡️

Create a keyspace and table

✅ Start the CQL shell:

cqlsh

✅ Create a keyspace called killrvideo and switch to that keyspace. Use NetworkTopologyStrategy for the replication class and set the replication factor of 1 for datacenter DC-Houston. Remember the USE command switches keyspaces.

CREATE KEYSPACE IF NOT EXISTS killrvideo
WITH replication = {
  'class': 'NetworkTopologyStrategy', 
  'DC-Houston': 1 };

USE killrvideo;

✅ Create the original table videos:

CREATE TABLE videos (
  video_id TIMEUUID,
  added_date TIMESTAMP,
  description TEXT,
  title TEXT,
  user_id UUID,
  PRIMARY KEY (video_id)
);

⬅️ Back Next ➡️