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