Andrés de la Peña created CASSANDRA-7314:
--------------------------------------------
Summary: Add keyspace option to DROP INDEX statement
Key: CASSANDRA-7314
URL: https://issues.apache.org/jira/browse/CASSANDRA-7314
Project: Cassandra
Issue Type: Improvement
Components: API
Reporter: Andrés de la Peña
Priority: Minor
Attachments: drop-index-with-keyspace.diff.txt
Actually drop index statement syntax is:
{code}
DROP INDEX IF EXISTS index_name
{code}
However, keyspace can be specified in drop table statement:
{code}
DROP TABLE IF EXISTS keyspace_name.table_name
{code}
And it's also used in index creation statement:
{code}
CREATE CUSTOM INDEX IF NOT EXISTS index_name
ON keyspace_name.table_name ( column_name )
USING (class_name) (WITH OPTIONS = map)
{code}
I think it could be useful add the optional keyspace name to the drop index
statement:
{code}
DROP INDEX IF EXISTS keyspace_name.index_name
{code}
Thus it would be possible to delete an index without using the USE statement. I
attach a patch for doing this.
--
This message was sent by Atlassian JIRA
(v6.2#6252)
