Thanks Petrov I will read what you sent a link to. I am trying to find out what capability CQL wise is truely available in order to determine my end state for my data model.
Last night after I discovered the cashing issues that affected queries I was able to create two queries one to get a list of ids then from that built up the IN list for the second query to get detail data from a master column family. Prevously in SQL Server I would use one query using IN and nested select. Hopefully tonight I will be able to compare the performance of the two.
From: Oleksandr Petrov <email@example.com>
Sent: Monday, July 8, 2013 5:51 AM
Subject: Re: CQL and IN
Hi Tony, you can check out a guide here: http://clojurecassandra.info/articles/kv.html
which explains pretty most of things you need to know about queries for starters.
It includes CQL code examples, just disregard Clojure ones, there's nothing strictly Clojure-driver specific in that guide.