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.
 
Regards,
-Tony
 
 
From: Oleksandr Petrov <oleksandr.pet...@gmail.com>
To: user@cassandra.apache.org 
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.



On Fri, Jul 5, 2013 at 12:18 AM, Rui Vieira <ruidevie...@googlemail.com> wrote:

You can use the actual item_ids however,  
>
>
>Select * from items Where item_id IN (1, 2, 3, ..., n)
>
>
>
>On 4 July 2013 23:16, Rui Vieira <ruidevie...@googlemail.com> wrote:
>
>CQL does not support sub-queries.
>>
>>
>>
>>On 4 July 2013 22:53, Tony Anecito <adanec...@yahoo.com> wrote:
>>
>>Hi All,
>>>
>>>I am using the DataStax driver and got prepared to work. When I tried to use 
>>>the "IN" keyword with a SQL it did not work. According to DataStax IN should 
>>>work.
>>>
>>>So if I tried:
>>>
>>>Select * from items Where item_id IN (Select item_id FROM users where 
>>>user_id = ?)
>>>
>>>
>>>Thanks for the feedback.-Tony
>>
>


-- 
alex p 

Reply via email to