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 > > >