What You’ll Learn: Gain an understanding of what a ‘keyspace’ is in Cassandra and its similarities to a database schema, as well as creating tables in your Cassandra database.

Note: We recommend you download and run the Cassandra OVA, to make the following course interactive.

In Cassandra, a keyspace is a container for your application data. It is similar to the schema in a relational database.

 From the CQL shell, type:

Your result should be:

The keyspace can include operational elements, such as replication factor and data center awareness. Let’s create a keyspace called “demo”. We will include replication strategy class and factor; details that will be covered in a future tutorial.

To create the keyspace “demo”, at the CQL shell prompt, type:

To use the keyspace we’ve just created, type:

Now we have we have a keyspace, we can create tables within that keyspace to store our data in. Tables, or column families, consist of columns and rows.

Create a “users” table within the keyspace “demo” so that we can insert some data into our database:

We have created a table with a single primary key, lastname.

To see the various attributes of the users table we have just created, type: