Query This Cassandra Database on Linux

15 minutes
  • 4 Learning Objectives

About this Hands-on Lab

In this activity you are working as a Systems Administrator and have been tasked with querying an existing Cassandra database.

Learning Objectives

Successfully complete this lab by achieving the following learning objectives:

Connect to the Database and Create a New Keyspace

Note: The version of Cassandra has been updated to 3.11.8.

Start the Cassandra Query Language shell:

/home/cloud_user/apache-cassandra-3.11.8/bin/cqlsh

Create a new keyspace named demo with a SimpleStrategy replication and 1 node:

CREATE KEYSPACE demo WITH replication = {'class':'SimpleStrategy', 'replication_factor' : 1};

Note This replication configuration is for demonstration only and is not recommended for production use.

Create a Table

Create a table named users in the demo keyspace:

USE demo;
CREATE TABLE users (ID int PRIMARY KEY, Name text, Department text, ExpenseCode int);
DESCRIBE users;
Insert Some Data
INSERT INTO users (ID, Name, Department, ExpenseCode) values (0, 'David', 'Engineering', 200);

then

INSERT INTO users (ID, Name, Department, ExpenseCode) values (1, 'Clay', 'HR', 100);

then

INSERT INTO users (ID, Name, Department, ExpenseCode) values (2, 'Sue', 'Sales', 300);

then

INSERT INTO users (ID, Name, Department, ExpenseCode) values (3, 'Betty', 'Marketing', 400);

once you have inserted the above information, run a query to see the data entered into the table with
SELECT * from users;

Query the Data

Query the database and print only the name and department for all users:

SELECT Name, Department from users;

Additional Resources

Note: The version of Cassandra has been updated to 3.11.8.

You will need to complete the following tasks to accomplish this:

  1. Connect to the database and create a new keyspace:
    • Connect using the Cassandra Query Language shell.
    • The cqlsh binary is located in /home/cloud_user/apache-cassandra-3.11.8/bin/cqlsh.
    • Create a new keyspace named demo with a SimpleStrategy replication and 1 node.
      Note This replication configuration is for demonstration only and is not recommended for production use.
  2. Create a table:
    • Create a table with the following columns in the demo keyspace:
      ID of type int (This column should be the primary key)
      Name of type text
      Department of type text
      ExpenseCode of type int
  3. Insert some data:
    • Insert the following data into the users table:
      ID,Name,Department,ExpenseCode
      0,David,Engineering,200
      1,Clay,HR,100
      2,Sue,Sales,300
      3,Betty,Marketing,400
  4. Query the data:
    • Query the database and print only the name and department for all users.

What are Hands-on Labs

Hands-on Labs are real environments created by industry experts to help you learn. These environments help you gain knowledge and experience, practice without compromising your system, test without risk, destroy without fear, and let you learn from your mistakes. Hands-on Labs: practice your skills before delivering in the real world.

Get Started
Who’s going to be learning?

How many seats do you need?

  • $499 USD per seat per year
  • Billed Annually
  • Renews in 12 months

Ready to accelerate learning?

For over 25 licenses, a member of our sales team will walk you through a custom tailored solution for your business.


$2,495.00

Checkout
Sign In
Welcome Back!

Psst…this one if you’ve been moved to ACG!