Re: CQL and IN

2013-07-04 Thread Rui Vieira
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 *

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 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