cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Brayton Thompson <thomp...@grnoc.iu.edu>
Subject Re: get keys based on values??
Date Wed, 06 Oct 2010 17:56:49 GMT
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 <thompsbp@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
> thompsbp@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-----
> 


Mime
View raw message