ICP 1 Cassandra CQL - Ruthvicp/CS5590_BigDataProgramming GitHub Wiki

Submitted by Ruthvic Punyamurtula

Create a table

Copy content from csv file into the table

Inserting a new row into the table

Updating the table data

Now as the data is ready, proceed with the below queries

  1. List the empno,ename,jobtitle,and hiredate of employee from the employee table

  1. List the name,salary of the employees who are clerks

3.List the name,job,salary of every employee joined on ‘december 17,1980’

4.List name and annual salary of all the employees

5.List the department name & deptno for departments having deptno.>=20

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