[CASSANDRA-7314] Add keyspace option to DROP INDEX statement

• Type: Improvement
• Status: Resolved
• Priority: Low
• Resolution: Fixed
• Fix Version/s: 2.1 rc2
• Component/s: Legacy/CQL
• Labels: 2i cql3 secondary_index
• Assignee: Andres de la Peña
• Reporter: Andres de la Peña

Authors

Andres de la Peña

Reviewers

Tom Hobbs

• Created: 28/May/14 14:56
• Updated: 16/Apr/19 09:31
• Resolved: 03/Jun/14 22:35

Description

Actually drop index statement syntax is:

DROP INDEX IF EXISTS index_name

However, keyspace can be specified in drop table statement:

DROP TABLE IF EXISTS keyspace_name.table_name

And it's also used in index creation statement:

CREATE CUSTOM INDEX IF NOT EXISTS index_name
ON keyspace_name.table_name ( column_name )
USING (class_name) (WITH OPTIONS = map)

I think it could be useful add the optional keyspace name to the drop index statement:

DROP INDEX IF EXISTS keyspace_name.index_name

Thus it would be possible to delete an index without using the USE statement. I attach a patch for doing this.

Issue Links

• relates to: CASSANDRA-9247 DROP INDEX ks.index_name is a syntax error in 2.0