cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Roshni Rajagopal <>
Subject Re: Secondary index partially created
Date Fri, 24 Aug 2012 18:02:55 GMT
What does List my_column_family in CLI show on all the nodes?
Perhaps the syntax u're using isn't correct?  You should be getting the
same data on all the nodes irrespective of which node's CLI you use.
The replication factor is for redundancy to have copies of the data on
different nodes to help if nodes go down. Even if you had a replication
factor of 1 you should still get the same data on all nodes.

On 24/08/12 11:05 PM, "Richard Crowley" <> wrote:

>On Thu, Aug 23, 2012 at 6:54 PM, Richard Crowley <> wrote:
>> I have a three-node cluster running Cassandra 1.0.10.  In this cluster
>> is a keyspace with RF=3.  I *updated* a column family via Astyanax to
>> add a column definition with an index on that column.  Then I ran a
>> backfill to populate the column in every row.  Then I tried to query
>> the index from Java and it failed but so did cassandra-cli:
>>     get my_column_family where my_column = 'my_value';
>> Two out of the three nodes are unable to query the new index and throw
>> this error:
>>     InvalidRequestException(why:No indexed columns present in index
>> clause with operator EQ)
>> The third is able to query the new index happily but doesn't find any
>> results, even when I expect it to.
>This morning the one node that's able to query the index is also able
>to produce the expected results.  I'm a dummy and didn't use science
>so I don't know if the `nodetool compact` I ran across the cluster had
>anything to do with it.  Regardless, it did not change the situation
>in any other way.
>> `describe cluster;` in cassandra-cli confirms that all three nodes
>> have the same schema and `show schema;` confirms that schema includes
>> the new column definition and its index.
>> The my_column_family.my_index-hd-* files only exist on that one node
>> that can query the index.
>> I ran `nodetool repair` on each node and waited for `nodetool
>> compactionstats` to report zero pending tasks.  Ditto for `nodetool
>> compact`.  The nodes that failed still fail.  The node that succeeded
>> still succeed.
>> Can anyone shed some light?  How do I convince it to let me query the
>> index from any node?  How do I get it to find results?
>> Thanks,
>> Richard

This email and any files transmitted with it are confidential and intended solely for the
individual or entity to whom they are addressed. If you have received this email in error
destroy it immediately. *** Walmart Confidential ***

View raw message