As mentioned in the article you linked, index creation happens asynchronously: when you perform the schema update call to add an index, the index starts building in the background, and will not be completely valid until it finishes building. I believe there is a JMX call to check the status of this process.
On Thu, Jan 13, 2011 at 5:39 PM, Tan Yeh Zheng <yehzh...@chartnexus.com>wrote: > Hi all, > > More specifically, I added two rows of data. Row A > (users['A']['state']='UT') is added before I add indexing to the column > and the Row B (users['B']['state']='UT') after indexing. When I call > get_indexed_slices (state='UT') to query the two rows, only the Row B is > returned. It's as if Cassandra cannot automatically index rows that are > inserted before indexing. > > Thank you in advance for your help. > > On Thu, 2011-01-13 at 15:33 +0800, Tan Yeh Zheng wrote: > > I tried to run the example on > > http://www.riptano.com/blog/whats-new-cassandra-07-secondary-indexes > > programatically. > > > > After I index the column "state", I tried to get_indexed_slices (where > > state = 'UT') but it returned an empty list. But if I index first, then > > query, it'll return the correct result. Any advise is appreciated. > > > > Thanks. > > > > -- > Best Regards, > > Tan Yeh Zheng > Software Programmer > > ____________ ChartNexus® :: Chart Your Success ____________ > > ChartNexus Pte. Ltd. > > 15 Enggor Street #10-01 > Realty Center > Singapore 079716 > Tel: (65) 6491 1456 > Website: www.chartnexus.com > > Disclaimer: > This email is confidential and intended only for the use of the > individual or individuals named above and may contain information that > is privileged. If you are not the intended recipient, you are notified > that any dissemination, distribution or copying of this email is > strictly prohibited. > >
