You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@cassandra.apache.org by Eric Martell <wo...@yahoo.com> on 2012/01/23 22:00:10 UTC
Return list by limit 1 which is NOT null
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).
Re: Return list by limit 1 which is NOT null
Posted by aaron morton <aa...@thelastpickle.com>.
Tombstoned rows are returned without any columns.
Cheers
-----------------
Aaron Morton
Freelance Developer
@aaronmorton
http://www.thelastpickle.com
On 25/01/2012, at 4:37 AM, Eric Martell wrote:
> Thanks Aaron.
>
> How do I implement that in the row? Does row will not have any tombstones?
>
> Please let me know.
> Thanks and Regards.
>
> --- On Tue, 1/24/12, aaron morton <aa...@thelastpickle.com> wrote:
>
> From: aaron morton <aa...@thelastpickle.com>
> Subject: Re: Return list by limit 1 which is NOT null
> To: user@cassandra.apache.org
> Date: Tuesday, January 24, 2012, 3:12 AM
>
> 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).
>>
>>
>>
>
Re: Return list by limit 1 which is NOT null
Posted by Eric Martell <wo...@yahoo.com>.
Thanks Aaron.
How do I implement that in the row? Does row will not have any tombstones?
Please let me know.
Thanks and Regards.
--- On Tue, 1/24/12, aaron morton <aa...@thelastpickle.com> wrote:
From: aaron morton <aa...@thelastpickle.com>
Subject: Re: Return list by limit 1 which is NOT null
To: user@cassandra.apache.org
Date: Tuesday, January 24, 2012, 3:12 AM
No, you will need to filter client side.
Can you do it in a single row ?
Cheers
-----------------Aaron MortonFreelance Developer@aaronmortonhttp://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).
Re: Return list by limit 1 which is NOT null
Posted by aaron morton <aa...@thelastpickle.com>.
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).
>
>
>