Skip to Content
Mastering Apache Cassandra 3.x - Third Edition
book

Mastering Apache Cassandra 3.x - Third Edition

by Aaron Ploetz, Tejaswi Malepati
October 2018
Beginner to intermediate content levelBeginner to intermediate
348 pages
10h
English
Packt Publishing
Content preview from Mastering Apache Cassandra 3.x - Third Edition

Dropping an index

Dropping a secondary index on a table is a simple task:

DROP INDEX [index_name]

If you do not know the name of the index (or created it without a name), you can describe the table to find it. Indexes on a table will appear at the bottom of the definition. Then you can DROP it:

CREATE INDEX ON query_test(c5);DESC TABLE query_test ;CREATE TABLE packt_ch3.query_test (   pk1 text,   pk2 text,   ck3 text,   ck4 text,   c5 text,   PRIMARY KEY ((pk1, pk2), ck3, ck4)) WITH CLUSTERING ORDER BY (ck3 DESC, ck4 ASC)...   AND speculative_retry = '99PERCENTILE';CREATE INDEX query_test_c5_idx ON packt_ch3.query_test (c5);DROP INDEX query_test_c5_idx ;
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Mastering Apache Cassandra - Second Edition

Mastering Apache Cassandra - Second Edition

Nishant Neeraj

Publisher Resources

ISBN: 9781789131499Supplemental Content