Query This Cassandra Database on Linux

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 named users in the demo keyspace:

USE demo;

CREATE TABLE users (ID int PRIMARY KEY, Name text, Department text, ExpenseCode int);

DESCRIBE users;

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 database and print only the name and department for all users:

SELECT Name, Department from users;