cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Sébastien Pierre <sebastien.pie...@gmail.com>
Subject Re: How to retrieve keys from Cassandra ?
Date Tue, 02 Feb 2010 16:05:07 GMT
Hi all,

It's basically for "knowing what's inside the db", as I've been toying with
Cassandra for some time, I have keys that are no longer useful and should be
removed.

I'm also storing HTTP logs in cassandra, where keys follow this convention
"campaign:<CAMPAIGN_ID>:<YYYYMMDD>". So for instance, if I'd like to know
what logs are available I just have to do:

   client.get_keys("Keyspace1", "Logs", "", "", 100, ConsistencyLevel.ONE)

However, I have to use an OrderPreservingPartitioner to do so, which is
(from my understanding) bad for load in this case.

 -- Sébastien


2010/2/2 Erik Holstad <erikholstad@gmail.com>

> Hi Sebastien!
> I'm totally new to Cassandra, but as far as I know there is no way of
> getting just the keys that are in the
> database, they are not stored separately but only with the data itself.
>
> Why do you want a list of keys, what are you going to use them for? Maybe
> there is another way of solving
> your problem.
>
> What you are describing, getting all the keys/rows for a given column
> sounds like you have to fetch all the
> data that you have and then filter every key on your column, I don't think
> that get_key_range will do that for
> you even, says that it takes column_family, but like I said I'm totally new
>
> Erik
>
> 2010/2/2 Sébastien Pierre <sebastien.pierre@gmail.com>
>
>> Hi all,
>>
>> I would like to know how to retrieve the list of available keys available
>> for a specific column. There is the get_key_range method, but it is only
>> available when using the OrderPreservingPartitioner -- I use a
>> RandomPartitioner.
>>
>> Does this mean that when using a RandomPartitioner, you cannot see which
>> keys are available in the database ?
>>
>>  -- Sébastien
>>
>
>
>
> --
> Regards Erik
>

Mime
View raw message