[
https://issues.apache.org/jira/browse/CASSANDRA-7314?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Tyler Hobbs updated CASSANDRA-7314:
-----------------------------------
Reviewer: Tyler Hobbs
> 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
> Assignee: Andrés de la Peña
> Priority: Minor
> Labels: 2i, cql3, secondary_index
> 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)
