Cassandra

Apache Cassandra is a free and open-source, distributed, wide column store, NoSQL database management system designed to handle large amounts of data across many commodity servers, providing high availability with no single point of failure.

Task1:

Creating a KEYSPACE and creating a table emp in the KEYSPACE named as a test and retrieving id, name,jobtitle, and hiredate of an employee from the emp table.

Task2:

Listing the name, salary of the employees who are clerks.

Task 3:

List the name,job,salary of every employee joined on ‘february18,2000’

Task 4:

List name and annual salary of all the employees

Task 5:

Display employees’ names, salary and manager values of those employees whose salary is 45000 from EMP table using SELECT statement.

Bonus

• Import any data from the given data set and apply any commands like above.

Queries: