Re: Creating and using indices

2010-10-07 Thread Petr Odut
What I've tested you must include at least one expression with EQ operator On Thu, Oct 7, 2010 at 3:45 PM, Matthew Dennis wrote: > If I remember correctly the only operator supported for secondary indexes > right now is EQ, not LTE (or the others). > > > On Thu, Oct 7, 2010 at 6:13 AM, Christian

Re: Cassandra + Pig + PHP

2010-10-06 Thread Petr Odut
ple in > contrib/hadoop . > > What role did you want PHP to fill? > > Aaron > > > > On 06 Oct, 2010,at 06:05 AM, Petr Odut wrote: > > Is there any example / tutorial combining these technologies? > > Thanks > > -- > Petr Odut [petr.o...@gmail.com] > > -- Petr Odut [petr.o...@gmail.com]

Cassandra + Pig + PHP

2010-10-05 Thread Petr Odut
Is there any example / tutorial combining these technologies? Thanks -- Petr Odut [petr.o...@gmail.com]

Re: first step with Cassandra

2010-10-04 Thread Petr Odut
t; > Thanks very much and best regards > Himanshu > > -- > Even IMPOSSIBLE says I M POSSIBLE > -- Petr Odut [petr.o...@gmail.com]

Re: Secondary Indexes aren't updated when removing whole row

2010-10-04 Thread Petr Odut
https://issues.apache.org/jira/browse/CASSANDRA-1571 On Fri, Oct 1, 2010 at 3:41 PM, Jonathan Ellis wrote: > Yes, this is a bug. Can you create a ticket? > > On Fri, Oct 1, 2010 at 4:02 AM, Petr Odut wrote: > > Hi, > > I have CF User with secondary index on "email&qu

Re: Sorting by secondary index

2010-10-04 Thread Petr Odut
partly good news, thanks Petr Odut On Mon, Oct 4, 2010 at 5:40 PM, Jonathan Ellis wrote: > Yes, but probably not in 0.7.0. > > On Sun, Oct 3, 2010 at 12:08 PM, Petr Odut wrote: > > Thanks for the info. Will be ever possible to going throught a secondary > > index (

Re: Sorting by secondary index

2010-10-03 Thread Petr Odut
Thanks for the info. Will be ever possible to going throught a secondary index (since SI is sorted by default)? My use case is to display newest comments, users, etc. SI from my point of view perfectly fits here. Thanks :) Petr Odut. Dne 2010 10 1 18:26 "Jonathan Ellis" nap

Re: Sorting by secondary index

2010-10-01 Thread Petr Odut
client. > > On Fri, Oct 1, 2010 at 10:13 AM, Petr Odut wrote: > > Hi, > > is it possible to sort results based on secondary index search? > > Typical use case is to get most recent comments from specified group > > CF: comments > > * SI: group > > * SI:

Sorting by secondary index

2010-10-01 Thread Petr Odut
Hi, is it possible to sort results based on secondary index search? Typical use case is to get most recent comments from specified group CF: comments * SI: group * SI: timestamp I've asked before, but I can't still found any information. Thanks -- Petr Odut [petr.o...@gmail.com]

Secondary Indexes aren't updated when removing whole row

2010-10-01 Thread Petr Odut
Hi, I have CF User with secondary index on "email" column. When I remove a whole row, del User['row'] SI is not updated and get_indexed_slices still returns the deleted data. Is it still open bug? Using latest nightly build. -- Petr Odut [petr.o...@gmail.com]

Re: buggy secondary indexes?

2010-09-13 Thread Petr Odut
crash on thrift, it seems to be cassandra issue. Petr On Mon, Sep 13, 2010 at 11:26 AM, Mike Peters < cassan...@softwareprojects.com> wrote: > Sounds like you may need to patch your php thrift > > See > http://www.softwareprojects.com/resources/programming/t-php-thrift-library-for

buggy secondary indexes?

2010-09-13 Thread Petr Odut
Hi, let's have CF User with indexed column email. Now i insert new user: "user":{"email":"s...@email.com"} finding user by email address by get_indexed_slices ... everything works all right updating email value (via batch_mutate) ends with TTransportException (TSocket: timed out reading 4 bytes f

get_indexed_slices && sorting

2010-09-11 Thread Petr Odut
Hi, I can't test new IndexOperators so I would like to ask you whether new Cassandra 0.7 sorts the results - i.e. I have an secondary index on "age" of "user" cf and I want to get top 10 oldest users. Can cassandra do this? Thanks, Petr

Re: Cassandra 0.7 + secondary indexes + thrift

2010-08-31 Thread Petr Odut
Thanks, that's what I needed! On Tue, Aug 31, 2010 at 10:05 PM, Jonathan Ellis wrote: > there are a couple examples in test/system/test_thrift_server.py for now > > On Tue, Aug 31, 2010 at 1:50 PM, Petr Odut wrote: > > Hi, > > is there any info / documentation for

Cassandra 0.7 + secondary indexes + thrift

2010-08-31 Thread Petr Odut
Hi, is there any info / documentation for secondary index feature? I can't google even any examples. Thanks Petr

SEO friendly pagination

2010-08-25 Thread Petr Odut
Hi, I've read about pagination in cassandra. My current implementation is get_range_slices with startKey = lastKey + 1, but I need to get the specified page directly. Is it any chance to do this? If you look at twitter, it has direct pagination too: http://twitter.com/PetrOdut?page=1 http://twitte