Are secondary index's available in .6.5? or are they only in .7? On Oct 6, 2010, at 1:15 PM, Tyler Hobbs wrote:
> If you're interested in only checking part of a column's value, you can > generally > just store that part of the value in a different column. So, have an > "email_addr" column > and a "email_domain" column, which stores "aol.com", for example. > > Then you can just use a secondary index on the "email_domain" column. > > - Tyler > > On Wed, Oct 6, 2010 at 10:33 AM, Brayton Thompson <thomp...@grnoc.iu.edu> > wrote: > -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA1 > > Ok, I am VERY new to Cassandra and trying to get my head around its core > ideas. > > So lets say I have a CF of Users that contains all the info I would ever want > to know about them. One day I decide(for some reason) that I want to send a > mass email to only the users with AOL email addresses. Is there a mechanism > for getting only keys whose email attribute contains the string @aol.com ? Or > is this frowned upon? I could also envision separate CF's for each email > type; that stored values to use as keys into my Users CF. Say the AOL CF > contains the usernames of everyone that has an aol account. So I would pull > all of the keys from that CF and then use them to index into the Users CF to > pull their email addresses. It seems to me that this is redundant. So I > would like your thoughts on my example. > > Thank you, > Brayton Thompson > thomp...@grnoc.iu.edu > Global Research Network Operation Center > Indiana University > -----BEGIN PGP SIGNATURE----- > Version: GnuPG/MacGPG2 v2.0.14 (Darwin) > > iQIcBAEBAgAGBQJMrJa1AAoJENisXTckM+p9ffcP/1UmNDyWxDnOu41ZRcVwmJiE > +47QxqNc57WmdXX86FUvcauhPFFNZfbrbGwA61sof1sktSOL83osOXQuOfGr5GvT > tulU3+rQ1B+ea0x+aBESbKZwXHxckLGdst2Hro1eCVXEna+VvqkxNJ2rvYzE3hNM > FTNBWDIv3JbOChTYBnycBqg1iG5yMDkc2xEHlaiw9S/VsOPU18pPYrf42eoSqgnk > /rZDCxxiThznuaLI70QnU3O7ZTiyXpavN8BUW6KoeDZNAypgg1AayhEL2d67zZWu > qtnGEpoIeieinjccWMpkUrv2f14CZQ5gbJSLwPdoNLItYLnFvGHg0Ca/hXhrkIDr > BqnA0R5w2YHB+5p84gvj1NTRE0O2kXcUHkLDDBvnlLKUOUkoDyqr5tGAIwHhIwA7 > hpko76CyGN84bS8Kma+1D6e8wg9zqfiS9mvvErJCUOwyU5e+XeoiCdyhwgDHJKlW > T5UjMXdAHwyZly48J5l6jEJastHsL1wKAHeV/NlQ1gEx2CmnnJ0lBPDPqlT5Lxdb > uQFzS/YhFzxWL2gApHKF8EdCz4jFbPUggYYPsVgfYkNNBISgcIiQaEIIPkri96vb > V/xhnxLrFCO20NnGQ5PCTzCnZptyc3V+9WI542fnRGcS8SbF+N5BdLzoJBjtidrI > a/Nps/KUhJ5kVzJ0o8H3 > =oBhH > -----END PGP SIGNATURE----- >
