Yes, denormalization is usually the answer to the absence of sub-queries (and joins for that matter) in Cassandra (though sometimes, simply doing 2 queries is fine, depends on your use case and performance requirements).
On Tue, Jun 25, 2013 at 6:46 PM, Tony Anecito <adanec...@yahoo.com> wrote: > 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 > > > > >