Is this a secondary indexer of your own design so that you know that changing the options will be safe for existing index entries?
It might be worth a Jira. Otherwise, you may jus have to manually go in and hack the information under the hood. -- Jack Krupansky On Fri, Mar 4, 2016 at 12:14 PM, DuyHai Doan <doanduy...@gmail.com> wrote: > 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 >> >> >> >> >> > >
