ICP7 - Hiresh12/Big-Data-Programming GitHub Wiki
ICP7
CASSANDRA
Creating Key Space:
CREATING TABLE:
CREATING TABLE employees1:
INSERTING DATA FROM External file:
QUERY1:
List the empID,ename,jobtitle,and hiredate of employee from the employee table.
QUERY2:
List the name,salary of the employees who are clerks
QUERY3:
List the name,job,salary of every employee joined on ‘february18,2000’
QUERY4:
List name and annual salary of all the employees.
QUERY5:
Display employees’ names, salary and manager values of those employees whose salary is 45000