incubator-cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Rui Vieira <ruidevie...@googlemail.com>
Subject Re: CQL and IN
Date Thu, 04 Jul 2013 22:18:15 GMT
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
>>
>
>

Mime
View raw message