Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@cassandra.apache.org
Received-SPF: pass (athena.apache.org: domain of norman.maurer@googlemail.com
 designates 209.85.214.172 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=googlemail.com; s=gamma;
        h=mime-version:sender:in-reply-to:references:date
         :x-google-sender-auth:message-id:subject:from:to:content-type
         :content-transfer-encoding;
        b=Pl++keR4M6evBJlIkIag4nvGhn9jxIp/Dgl92NTj8cg9s0ilGl5VgdjOA7NDCRQeas
         zbMOsxd/WKv+q8bKR5uKd0Y8OuUzwX+tOe5xxlemtxuSIuDkjnlWoYos7T0xJw7+Y9Lj
         Tue2y2WIYnZvIjvxuiwnj2mEyaSkvJgzlhHmY=
MIME-Version: 1.0
Sender: norman.maurer@googlemail.com
In-Reply-To: <F8B9AA28-B484-4275-95F6-3493179484BF@grnoc.iu.edu>
References: <649A15D5-25BF-47A0-B6D0-007EA1C93947@grnoc.iu.edu>
	<AANLkTi=-8xN1tn3zvOLpO6KxyuOm9k3xuWYsrqHxLw-O@mail.gmail.com>
	<F8B9AA28-B484-4275-95F6-3493179484BF@grnoc.iu.edu>
Date: Wed, 6 Oct 2010 19:58:36 +0200
Message-ID: <AANLkTin7iDx8Q_w0NcepUXUafFD2h2i6OiKVKaUpXBu8@mail.gmail.com>
Subject: Re: get keys based on values??
From: Norman Maurer <norman@apache.org>
To: user@cassandra.apache.org
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

Only in 0.7

Bye,
Norman

2010/10/6 Brayton Thompson <thompsbp@grnoc.iu.edu>:
> 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.=A0 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 t=
o
>> 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 strin=
g
>> @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. =A0It 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
>> =3DoBhH
>> -----END PGP SIGNATURE-----
>
>
>