Re: Querying for rows without a particular column

2012-02-14 Thread aaron morton
I would try to come up with a different model. Expired columns are essentially deleted columns. Can you create a manual secondary index that uses the time the column will have expired at. e.g. row: column: When you write the row with the expiry time also write a column here that says this

Re: Querying for rows without a particular column

2012-02-14 Thread Narendra Sharma
This is an interesting usecase. If you implement it correctly then you may end up getting all the rows in your cluster for certain bad queries :)...so be careful. I would ask why do you want to know such rows and what will you do with them? -Naren On Mon, Feb 13, 2012 at 12:16 PM, Asankha C. Pe

Re: Querying for rows without a particular column

2012-02-14 Thread R. Verlangen
One option might be to maintain an index containing the keys of the rows. The index would then have the same TTL as the row itself so when you iterate over the index columns you'll find exactly the same results. Although I'm not really sure whether this is the best option. Another might be to use

Querying for rows without a particular column

2012-02-13 Thread Asankha C. Perera
Hi All I am using expiring columns in my column family, and need to search for the rows where a particular column expired (and no longer exists).. I am using Hector client. How can I make a query to find the rows of my interest? thanks asankha -- Asankha C. Perera AdroitLogic, http://adroitl