cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From aaron morton <aa...@thelastpickle.com>
Subject Re: Return list by limit 1 which is NOT null
Date Tue, 24 Jan 2012 08:12:45 GMT
No, you will need to filter client side.

Can you do it in a single row ? 

Cheers
 
-----------------
Aaron Morton
Freelance Developer
@aaronmorton
http://www.thelastpickle.com

On 24/01/2012, at 10:00 AM, Eric Martell wrote:

> HI,
>   I am trying to create a keys list which I will fetch the key and then delete the same
key in the subsequent call.
> 
> When I use the CLI list, It always returns first row due to tombstone. Is there a way
I can specify to use the limit 1 and return NOT null value.
> 
> Please let me now.
> 
> Thanks and Regards.
> 
> 
> [default@test_keyspace] list test_kms_keys;           
> Using default limit of 100
> -------------------
> RowKey: 33
> -------------------
> RowKey: 04
> => (column=key_id, value=4, timestamp=1327349351200000)
> -------------------
> RowKey: 32
> => (column=key_id, value=2, timestamp=1326231507383000)
> -------------------
> RowKey: 31
> -------------------
> RowKey: 311313
> 
> 5 Rows Returned.
> Elapsed time: 6 msec(s).
> [default@test_keyspace] list test_kms_keys limit 1;
> -------------------
> RowKey: 33
> 
> 1 Row Returned.
> Elapsed time: 2 msec(s).
> 
> 
> 


Mime
View raw message