index creation isn't instant, no. cli describe keyspace will tell you which ones are still building.
On Sat, Feb 12, 2011 at 7:40 AM, Sasha Dolgy <[email protected]> wrote: > hi there, > was playing around today and had a simple CF with sample user data with the > following columns: > > | email | name | nickname | > > From the cassandra-cli I ran the following: > > update column family user with column_metadata=[{column_name: nickname, > validation_class: UTF8Type,index_type: KEYS}, > > {column_name: email, validation_class: UTF8Type, index_type: KEYS}]; > > Subsequently, when I tried with an index clause to retrieve the rows that > matched my email address (only 1) it returned no results. It was only after > I performed the following from the cassandra-cli: > > set user ['some-random-key']['email'] = '[email protected]'; > > That it worked. Is this normal behaviour? In that, I should clearly define > which columns I want indexed prior to data population? > Thanks in advance, > -sd > -- > Sasha Dolgy > [email protected] > -- Jonathan Ellis Project Chair, Apache Cassandra co-founder of DataStax, the source for professional Cassandra support http://www.datastax.com
