Re: CQL and IN

2013-07-08 Thread Tony Anecito
: Oleksandr Petrov 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

Re: CQL and IN

2013-07-08 Thread Oleksandr Petrov
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

Re: CQL and IN

2013-07-04 Thread Rui Vieira
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 wrote: > CQL does not support sub-queries. > > > On 4 July 2013 22:53, Tony Anecito wrote: > >> Hi All, >> >> I am using the DataStax driver and got prepared to wor

Re: CQL and IN

2013-07-04 Thread Rui Vieira
CQL does not support sub-queries. On 4 July 2013 22:53, Tony Anecito 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 item

CQL and IN

2013-07-04 Thread Tony Anecito
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 feedb