Latest Post

Monday, 19 December 2016

How to DROP INDEX in Cassandra Database

DROP INDEX
We can drop a secondary index by using the DROP INDEX statement.

Syntax:- 

DROP INDEX index_name

Example:-
cqlsh:payroll> CREATE INDEX erank ON exam_year_name (rank);
cqlsh:payroll> select * from exam_year_name where rank=1;
 
 exam_year | exam_name                 | rank | examlist_name
-----------+---------------------------+------+---------------
      2015 | Public Service Commission |    1 |         UPPSC
      2015 |  Teacher Eligibility Test |    1 |          CTET
 
(2 rows)
cqlsh:payroll> Drop index erank;
cqlsh:payroll>

Keep in Mind:-
  • The DROP INDEX statement is used to drop an existing secondary index
  • If the index does not exist, the statement will return an error. to avoid this use IF EXISTS

Government Jobs