4. IMPLEMENTATION OF BASIC OPERATIONS IN
CASSANDRA
1. CREATE KEYSPACES :-
CREATE KEYSPACE emp WITH replication = {'class':
'SimpleStrategy', 'replication_factor': 3};
Output:
2. KEYSPACE VERIFICATION :-
DESCRIBE keyspaces;
Output:
system_auth system "OpsCenter" emp system_distributed
system_traces
3. SELECTION OF KEYSPACE :-
USE emp;
Output:
cqlsh:emp>
4. TABLE CREATION :-
CREATE TABLE emp (
eid int PRIMARY KEY,
ename text,
"variant_ecity" text,
"variant_ephone" bigint,
esal int
);
5. DATA INSERTION :-
INSERT INTO emp(eid, ename, "variant_ecity",
"variant_ephone", esal) VALUES (1, 'ram', 'Hyderbad',
9876543257, 50000);
INSERT INTO emp(eid, ename, "variant_ecity",
"variant_ephone", esal) VALUES (2, 'arun', 'Chennai',
98765437357, 90000);
INSERT INTO emp(eid, ename, "variant_ecity",
"variant_ephone", esal) VALUES (3, 'varun', 'Hyderbad',
9872643257, 80000);
6. READING DATA :-
SELECT * FROM emp;
Output:
eid | ename | esal | variant_ecity | variant_ephone
----+-------+-------+---------------+----------------
1 | ram | 50000 | Hyderbad | 9876543257
2 | arun | 90000 | Chennai | 98765437357
3 | varun | 80000 | Hyderbad | 9872643257
7. READING DATA USING WHERE CLAUSE :-
CREATE INDEX ON emp(esal);
SELECT * FROM emp WHERE esal = 50000;
Output:
eid | ename | esal | variant_ecity | variant_ephone
----+-------+-------+---------------+----------------
1 | ram | 50000 | Hyderbad | 9876543257
8. UPDATION OPERATIONS :-
UPDATE emp SET "variant_ecity" = 'Hyderbad', esal = 40000
WHERE eid = 3;
9. UPDATION VERIFICATION :-
SELECT * FROM emp;
Output:
eid | ename | esal | variant_ecity | variant_ephone
----+-------+-------+---------------+----------------
1 | ram | 50000 | Hyderbad | 9876543257
2 | arun | 90000 | Chennai | 98765437357
3 | varun | 40000 | Hyderbad | 9872643257
10. DELETION OPERATION :-
DELETE esal FROM emp WHERE eid = 3;
11. DELETE VERIFICATION :-
SELECT * FROM emp;
Output:
eid | ename | esal | variant_ecity | variant_ephone
----+-------+-------+---------------+----------------
1 | ram | 50000 | Hyderbad | 9876543257
2 | arun | 90000 | Chennai | 98765437357
3 | varun | null | Hyderbad | 9872643257
