cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Tyler Hobbs <ty...@riptano.com>
Subject Re: How to Load Records From ColumnFamily by Condition Based on a Column Values.
Date Mon, 27 Sep 2010 17:08:42 GMT
Of course, those slice based on the column name, not value.

So, you may want to consider using the date for the column name instead (in
a more usable form, like "YYYY/MM/DD", a timestamp, or a TimeUUID).
Alternatively, use a second ColumnFamily with those dates as column names
and use it as an index.

- Tyler

On Mon, Sep 27, 2010 at 7:18 AM, Lucas Nodine <lucasnodine@gmail.com> wrote:

> Have you looked at get_slice or multiget_slice (
> http://wiki.apache.org/cassandra/API) to see if those will fit your
> needs?  I would expect the slice_range property of the SlicePredicate might
> get you started.
>
> - Lucas Nodine
>
> On Mon, Sep 27, 2010 at 4:43 AM, sekhar kosuru <kosurusekhar@gmail.com>wrote:
>
>> Hi
>>
>> I have a ColumnFamily with 50k rows, how can i load only say some 2k or
>> so, Which are satisfied some Criteria on a Single  Column Values.
>>
>> For Example, In the ColumnFamily normal column named CreatedDate, i need
>> to load the satisfied criteria like this. 1-sep-2009 to 3-july-2010.
>>
>>
>> /Regards
>> Sekhar.
>>
>
>
>
> --
> Lucas J. Nodine
> Assistant Labette County Attorney
> 201 S. Central, Suite B
> Parsons, KS 67357
> (620) 421-6370
>

Mime
View raw message