cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jacques-Henri Berthemet <>
Subject RE: Updating secondary index options
Date Fri, 04 Mar 2016 17:49:17 GMT
Indeed it’s a custom implementation of PerRowSecondaryIndex, in my case I know it’s safe
to update the particular setting I want update, and it won’t rebuild the index, just provide
the ability to tune some settings.

Even on regular Cassandra indexes that are based on SSTables you could want to update read_repair_chance,
sstable_compression, compaction, caching …

I created the below Jira “Wish”:
CASSANDRA-11306<> Add support for

For now I’ll have to hack something indeed. I tried to update system tables that holds index
options but it seems I need to restart Cassandra twice to be able to see the changes.

Jacques-Henri Berthemet

From: Jack Krupansky []
Sent: vendredi 4 mars 2016 18:40
Subject: Re: Updating secondary index options

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 <<>>
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 <<>>
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 [<>]
Sent: vendredi 4 mars 2016 14:52
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 <<>>

I’m using Cassandra 2.2.5 with a custom secondary index. It’s created with the below syntax:
CREATE CUSTOM INDEX ON users (email) USING '' WITH OPTIONS = {'some_setting':
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?


View raw message