cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Yang <teddyyyy...@gmail.com>
Subject "select * from A join B using(common_id) where A.id == a and B.id == b "
Date Fri, 22 Jul 2011 22:41:58 GMT
this is a common pattern used in RDMS,
is there some existing idiom to do it in cassandra ?


if the size of "select * from A where id == a " is very large, and
similarly for B, while the join of A.id == a and B.id==b is small,
then doing a get() for both and then merging seems excessively slow.


my fall-back approach is, since A and B do not change a lot, I'll
pre-generate the join of A and B (not very large) keyed on A.id +
B.id,
then do the get(a+b)


thanks
Yang

Mime
View raw message