ICP7 - gracesyl/big-data-hadoop GitHub Wiki

Hi Cassandra!! It is an open source and developed Database management system that has the ability to handle very vast data.The data can be distributed over servers; the main importance of the Cassandra is to provide service which has no failure point.

step1: Download the cassandra 3.11 with python 2.7 and java 1.8 at your local machine if these downloads are not balanced then you will not able to run queries in the cassandra terminal so make sure you do correct.

Write a document and include your CQL screen shots for the commands below. Use the datasets provided to you in class and create a KEYSPACE with the name “test” or use appropriate KEYSPACE according to your choice. You have the flexibility to change data according to your requirements.

1.List the empno,ename,jobtitle,and hiredate of employee from the employee table. 2.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 500 from EMP table using SELECT statement.