incubator-cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Oleksandr Petrov <oleksandr.pet...@gmail.com>
Subject Re: CQL and IN
Date Mon, 08 Jul 2013 11:51:42 GMT
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 <ruidevieira@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 <ruidevieira@googlemail.com> wrote:
>
>> CQL does not support sub-queries.
>>
>>
>> On 4 July 2013 22:53, Tony Anecito <adanecito@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

Mime
View raw message