Unfortunately for you, ALTER INDEX does not exist. And anyway, even if it exists, altering an index option is going likely to require index rebuild so you can't cut it anyway
On Fri, Mar 4, 2016 at 4:59 PM, Jacques-Henri Berthemet < jacques-henri.berthe...@genesys.com> wrote: > It’s not possible, it’s a PerRowSecondary index, potentially as big as the > table itself (few TBs) it will take a very long time to drop and re-create. > > > > *--* > > *Jacques-Henri Berthemet* > > > > *From:* DuyHai Doan [mailto:doanduy...@gmail.com] > *Sent:* vendredi 4 mars 2016 14:52 > *To:* user@cassandra.apache.org > *Subject:* Re: Updating secondary index options > > > > DROP and re-create the index with the new options > > > > On Fri, Mar 4, 2016 at 3:45 PM, Jacques-Henri Berthemet < > jacques-henri.berthe...@genesys.com> wrote: > > Hi, > > > > I’m using Cassandra 2.2.5 with a custom secondary index. It’s created with > the below syntax: > > https://docs.datastax.com/en/cql/3.1/cql/cql_reference/create_index_r.html > > *CREATE* *CUSTOM* *INDEX* *ON* *users* (email) *USING* > 'path.to.the.IndexClass' *WITH* OPTIONS = {'some_setting': 'value'}; > > I’d like to update those settings, I tried the below command based on > ALTER TABLE but it does not work: > > cqlsh:test> alter index table_idx WITH OPTIONS = {'some_setting': 'value'}; > > SyntaxException: <ErrorMessage code=2000 [Syntax error in CQL query] > message="line 1:6 no viable alternative at input 'index' ([alter] > index...)"> > > > > Is there a way to send such updates? > > > > Regards, > > Jacques-Henri > > > > >
