Cassandra Secondary Index

Author: Al-mamun Sarkar Date: 2020-09-22 08:30:56

In Cassandra, the Secondary Index is used to perform a query with a non-primary key. In this lesson, I will show you how to create and delete the secondary index.


Cassandra Secondary Index:

Creating Secondary Index:

CREATE INDEX employee_city
ON employees (city);

Now we can user city on WHERE CLAUSE:

SELECT city, name 
FROM employees 
WHERE city = 'Dhaka';

Drop a Index:

DROP INDEX employee_city ;