Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@cassandra.apache.org
Received-SPF: pass (nike.apache.org: local policy)
From: Brayton Thompson <thompsbp@grnoc.iu.edu>
Mime-Version: 1.0 (Apple Message framework v1081)
Content-Type: multipart/alternative; boundary=Apple-Mail-2-990448313
Subject: Re: get keys based on values??
Date: Wed, 6 Oct 2010 13:56:49 -0400
In-Reply-To: <AANLkTi=-8xN1tn3zvOLpO6KxyuOm9k3xuWYsrqHxLw-O@mail.gmail.com>
To: user@cassandra.apache.org
References: <649A15D5-25BF-47A0-B6D0-007EA1C93947@grnoc.iu.edu>
 <AANLkTi=-8xN1tn3zvOLpO6KxyuOm9k3xuWYsrqHxLw-O@mail.gmail.com>
Message-Id: <F8B9AA28-B484-4275-95F6-3493179484BF@grnoc.iu.edu>


--Apple-Mail-2-990448313
Content-Transfer-Encoding: quoted-printable
Content-Type: text/plain;
	charset=us-ascii

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.
>=20
> Then you can just use a secondary index on the "email_domain" column.
>=20
> - Tyler
>=20
> On Wed, Oct 6, 2010 at 10:33 AM, Brayton Thompson =
<thompsbp@grnoc.iu.edu> wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>=20
> Ok, I am VERY new to Cassandra and trying to get my head around its =
core ideas.
>=20
> 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.
>=20
> 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)
>=20
> 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
> =3DoBhH
> -----END PGP SIGNATURE-----
>=20


--Apple-Mail-2-990448313
Content-Transfer-Encoding: 7bit
Content-Type: text/html;
	charset=us-ascii

<html><head></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">Are secondary index's available in .6.5? or are they only in .7?<div><br><div><div>On Oct 6, 2010, at 1:15 PM, Tyler Hobbs wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite">If you're interested in only checking part of a column's value, you can generally<br>just store that part of the value in a different column.&nbsp; So, have an "email_addr" column<br>and a "email_domain" column, which stores "<a href="http://aol.com/">aol.com</a>", for example.<br>
<br>Then you can just use a secondary index on the "email_domain" column.<br><br>- Tyler<br><br><div class="gmail_quote">On Wed, Oct 6, 2010 at 10:33 AM, Brayton Thompson <span dir="ltr">&lt;<a href="mailto:thompsbp@grnoc.iu.edu">thompsbp@grnoc.iu.edu</a>&gt;</span> wrote:<br>
<blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">-----BEGIN PGP SIGNED MESSAGE-----<br>
Hash: SHA1<br>
<br>
Ok, I am VERY new to Cassandra and trying to get my head around its core ideas.<br>
<br>
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 @<a href="http://aol.com/" target="_blank">aol.com</a> ? 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. &nbsp;It seems to me that this is redundant. So I would like your thoughts on my example.<br>

<br>
Thank you,<br>
Brayton Thompson<br>
<a href="mailto:thompsbp@grnoc.iu.edu">thompsbp@grnoc.iu.edu</a><br>
Global Research Network Operation Center<br>
Indiana University<br>
-----BEGIN PGP SIGNATURE-----<br>
Version: GnuPG/MacGPG2 v2.0.14 (Darwin)<br>
<br>
iQIcBAEBAgAGBQJMrJa1AAoJENisXTckM+p9ffcP/1UmNDyWxDnOu41ZRcVwmJiE<br>
+47QxqNc57WmdXX86FUvcauhPFFNZfbrbGwA61sof1sktSOL83osOXQuOfGr5GvT<br>
tulU3+rQ1B+ea0x+aBESbKZwXHxckLGdst2Hro1eCVXEna+VvqkxNJ2rvYzE3hNM<br>
FTNBWDIv3JbOChTYBnycBqg1iG5yMDkc2xEHlaiw9S/VsOPU18pPYrf42eoSqgnk<br>
/rZDCxxiThznuaLI70QnU3O7ZTiyXpavN8BUW6KoeDZNAypgg1AayhEL2d67zZWu<br>
qtnGEpoIeieinjccWMpkUrv2f14CZQ5gbJSLwPdoNLItYLnFvGHg0Ca/hXhrkIDr<br>
BqnA0R5w2YHB+5p84gvj1NTRE0O2kXcUHkLDDBvnlLKUOUkoDyqr5tGAIwHhIwA7<br>
hpko76CyGN84bS8Kma+1D6e8wg9zqfiS9mvvErJCUOwyU5e+XeoiCdyhwgDHJKlW<br>
T5UjMXdAHwyZly48J5l6jEJastHsL1wKAHeV/NlQ1gEx2CmnnJ0lBPDPqlT5Lxdb<br>
uQFzS/YhFzxWL2gApHKF8EdCz4jFbPUggYYPsVgfYkNNBISgcIiQaEIIPkri96vb<br>
V/xhnxLrFCO20NnGQ5PCTzCnZptyc3V+9WI542fnRGcS8SbF+N5BdLzoJBjtidrI<br>
a/Nps/KUhJ5kVzJ0o8H3<br>
=oBhH<br>
-----END PGP SIGNATURE-----<br>
</blockquote></div><br>
</blockquote></div><br></div></body></html>
--Apple-Mail-2-990448313--