ICP 7 - bhargavi1411/BigDataProgramming GitHub Wiki

Name : Bhargavi Saipoojitha Chennupati

Class ID : 4

Topic

Cassandra

cqlsh is a command line shell for interacting with Cassandra through CQL.

A KEYSPACE is created with the name 'test'.

PROBLEM-1:-

List the employeeID,ename,jobtitle,hiredate of the employee from the employee table.

We have created an employee table with attributes ID,Name,Job title,Hire Date.

We have inserted the values into the employee table.

Displayed the created employee table.

PROBLEM-2:-

List the name salary of the employee who are clerks.

PROBLEM-3:-

List the name,job,salary of every employee joined on 'february12,1980' .

PROBLEM-4:-

List name,job title and salary of the employees.

PROBLEM-5:-

Display employees name,salary and manager values of those employees whose salary is 45000 from employee table using SELECT statement.

UPDATE and ALTER are used in parallel to change certain values for the table.