incubator-cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Sylvain Lebresne <sylv...@datastax.com>
Subject Re: Is nexted selects supported by Cassandra JDBC??
Date Tue, 25 Jun 2013 16:58:26 GMT
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 <adanecito@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 <sylvain@datastax.com>
> *To:* "user@cassandra.apache.org" <user@cassandra.apache.org>; Tony
> Anecito <adanecito@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 <adanecito@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
>
>
>
>
>

Mime
View raw message