You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@cassandra.apache.org by Tan Yeh Zheng <ye...@chartnexus.com> on 2011/01/13 08:33:24 UTC
Old data not indexed
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.
Re: Old data not indexed
Posted by Stu Hood <st...@gmail.com>.
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 <ye...@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.
>
>
Re: Old data not indexed
Posted by Tan Yeh Zheng <ye...@chartnexus.com>.
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.