[ https://issues.apache.org/jira/browse/CASSANDRA-5484?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13646445#comment-13646445 ]
Sylvain Lebresne commented on CASSANDRA-5484: --------------------------------------------- bq. I'd like options to be a map (and replace 'class_name' key with 'class' internally, also for consistency) Make sense to me. bq. just treating CREATE INDEX with non-null options as custom, implicitly That would work now, but that slightly frighten me for the future because: * what if we add some other type of non custom indexes, like say bitmap indexes. * what if we want to add options for non custom indexes (while this is nice to avoid option when we can, it's not hard to imagine that future improvements to the 2ndary index code might require tweaking knobs for instance). bq. every time we add a keyword to CQL, even an unreserved one, a kitten dies somewhere I agree we should avoid new keyword when possible. But that being said, when we add unreserved ones I think there is no real downside for clients. Yes it add some marginal delta to the parser and it's definitively sad for the kitten, but typically I'm not sold that it's worth taking the risk of being blocked if we want to add options to non-custom index later just to avoid adding an unreserved keyword now. > Support custom secondary indexes in CQL > --------------------------------------- > > Key: CASSANDRA-5484 > URL: https://issues.apache.org/jira/browse/CASSANDRA-5484 > Project: Cassandra > Issue Type: Bug > Components: Core > Affects Versions: 1.2.4 > Reporter: Benjamin Coverston > Assignee: Aleksey Yeschenko > > Through thrift users can add custom secondary indexes to the column metadata. > The following syntax is used in PLSQL, and I think we could use something > similar. > CREATE INDEX <NAME> ON <TABLE> (<COLUMN>) [INDEXTYPE IS (<TYPENAME>) > [PARAMETERS (<PARAM>[, <PARAM>])] -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira