incubator-cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Yang <>
Subject "select * from A join B using(common_id) where == a and == 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 and 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 +,
then do the get(a+b)


View raw message