Ok. So if I have a composite key table instead of a nested select I will have to run 2 queries else denormalize? Unless there is something provided by CQL 3 to do the same thing?
Thanks, -Tony ________________________________ From: Sylvain Lebresne <sylv...@datastax.com> To: "user@cassandra.apache.org" <user@cassandra.apache.org>; Tony Anecito <adanec...@yahoo.com> Sent: Tuesday, June 25, 2013 9:06 AM Subject: Re: Is nexted selects supported by Cassandra JDBC?? No. CQL3 doesn't support nested selects. -- Sylvain On Tue, Jun 25, 2013 at 5:02 PM, Tony Anecito <adanec...@yahoo.com> wrote: Hi All, > > >Is nested select supported by Cassandra JDBC driver? > > >So for a simple example to get a list of user details from a users column >family: > > >Select * from user_details where user_id in (Select user_id from users) > > >Thanks!-Tony
