Re: CQL 'IN' predicate

2013-11-07 Thread Dan Gould
the tasks to be completed. So i tend to like asking for fewer rows. Cheers - Aaron Morton New Zealand @aaronmorton Co-Founder Principal Consultant Apache Cassandra Consulting http://www.thelastpickle.com On 7/11/2013, at 12:19 pm, Dan Gould d...@chill.com mailto:d...@chill.com wrote

CQL 'IN' predicate

2013-11-06 Thread Dan Gould
I was wondering if anyone had a sense of performance/best practices around the 'IN' predicate. I have a list of up to potentially ~30k keys that I want to look up in a table (typically queries will have 500, but I worry about the long tail). Most of them will not exist in the table, but, say,

Re: CQL 'IN' predicate

2013-11-06 Thread Dan Gould
havent tried with IN clause - don't see why it would not work though). On Wed, Nov 6, 2013 at 4:08 PM, Dan Gould d...@chill.com mailto:d...@chill.com wrote: I was wondering if anyone had a sense of performance/best practices around the 'IN' predicate. I have a list of up