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).
