Return-Path: Delivered-To: apmail-incubator-cassandra-user-archive@minotaur.apache.org Received: (qmail 42173 invoked from network); 6 Jul 2009 23:32:10 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3) by minotaur.apache.org with SMTP; 6 Jul 2009 23:32:10 -0000 Received: (qmail 84784 invoked by uid 500); 6 Jul 2009 23:32:20 -0000 Delivered-To: apmail-incubator-cassandra-user-archive@incubator.apache.org Received: (qmail 84766 invoked by uid 500); 6 Jul 2009 23:32:20 -0000 Mailing-List: contact cassandra-user-help@incubator.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: cassandra-user@incubator.apache.org Delivered-To: mailing list cassandra-user@incubator.apache.org Received: (qmail 84757 invoked by uid 99); 6 Jul 2009 23:32:20 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 06 Jul 2009 23:32:20 +0000 X-ASF-Spam-Status: No, hits=2.2 required=10.0 tests=HTML_MESSAGE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of vijay2win@gmail.com designates 209.85.210.191 as permitted sender) Received: from [209.85.210.191] (HELO mail-yx0-f191.google.com) (209.85.210.191) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 06 Jul 2009 23:32:12 +0000 Received: by yxe29 with SMTP id 29so6257314yxe.32 for ; Mon, 06 Jul 2009 16:31:51 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:in-reply-to:references :from:date:message-id:subject:to:content-type; bh=QMMaF4k8ICwz/+YEnHn5m5k+HDif7AVECAXcNRiI4YY=; b=ttrdFLDI6GQbzqaL1FPzOmRHvb8Eenzm0Vcgb2QtUifekoa8M853QnHRcofKKa6rGB NW9KItlJfHjRrBu3nLWp7Hil2CpjZ2rkMoLv1QC1l+Ka/OLrO4hN/T/75Pv+N8HOm4VH 60Ouq6heOS5ETonjMHhy0YcnMRIaue6zNHYjI= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:from:date:message-id:subject:to :content-type; b=WP28ZIpcGgOlryXzMF7VaHpcVirkf1EBTHAN3o1+68STa+s6nPx54DG+RGlZRnSmMH 3x9NzF8UiV02iuOSTvYzlzXIXwtlwOZxveqKyq9ltxPS4X+/AGdJNapVHzLVcCv48+wv innQrqbCLdKTobz3HLvnTZqhOyFMS6z+l193A= MIME-Version: 1.0 Received: by 10.100.92.2 with SMTP id p2mr9552065anb.7.1246923111179; Mon, 06 Jul 2009 16:31:51 -0700 (PDT) In-Reply-To: References: <9b40bc2a0907061559u4a8811aco6275b758a7e2cc9d@mail.gmail.com> From: Vijay Date: Mon, 6 Jul 2009 16:31:31 -0700 Message-ID: <9b40bc2a0907061631t5f671678hd29f0b305e6922e9@mail.gmail.com> Subject: Re: Table Index To: cassandra-user@incubator.apache.org Content-Type: multipart/alternative; boundary=0016e645ab301adc62046e11e930 X-Virus-Checked: Checked by ClamAV on apache.org --0016e645ab301adc62046e11e930 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit Thanks Sandeep for your response, but how do i get to the data, when i dont know the rowid? i have a unique value which i am querying for in the table.... but i dont know the ROWNAME..... Is there a way? or should i just create another table and store the name in there? "The indexing you see in the code is just a mechanism to get at the (known) keys and columns quickly." I saw your presentation in NOSQL meet in which you said something about supercoulmn that was intresting.... but in your presentation rowid was the usernames of who intracted? The reason i am asking is i have multiple columns which a user can query on like UID, URL, TAGS (all of them are unique).... but how can i get to them without getting stuck with the rowid? coz rowid can be one of those.... and the user at any time can know only one.... Thanks for your time.... Regards, On Mon, Jul 6, 2009 at 4:17 PM, Sandeep Tata wrote: > Cassandra does not currently have secondary indexes. > > The indexing you see in the code is just a mechanism to get at the > (known) keys and columns quickly. > > On Mon, Jul 6, 2009 at 3:59 PM, Vijay wrote: > > Hi, > > I think this is a very simple question and might have been asked > before.... > > but couldn't find answer elsewhere.... Sorry if it is repetitive. We are > > trying to use Cassandre and i am stuck in the datamodel..... > > Do we have indexed table? i see some classes but dont know what they will > be > > used for.... Is the index tell Casandra where exactly the column and the > > value in the column family is located? Say i do a query for which i dont > > have the rowid, i am looking for and i want to get a value of a coumn > with a > > specific value.... will the secoundry index help on it? or should i use > > lucene to do that? > > What exactly the index will do and help on? > > Thanks in advance.... May be i am confused because my understanding is > > completely wrong abt the index. > > Regards, > > > --0016e645ab301adc62046e11e930 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Thanks Sandeep for your response,

but how do i get to th= e data, when i dont know the rowid? i have a unique value which i am queryi= ng for in the table.... but i dont know the ROWNAME..... Is there a way? or= should i just create another table and store the name in there?

"The indexing you see in the code is just a mechanism = to get at the
(known) keys and columns quickly."=C2=A0<= div> I saw= your presentation in NOSQL meet in which you said something about supercou= lmn that was intresting.... but in your presentation rowid was the username= s of who intracted?=C2=A0
=
The reason i am asking is i have multiple columns which a = user can query on like UID, URL, TAGS (all of them are unique).... but how = can i get to them without getting stuck with the rowid? coz rowid can be on= e of those.... and the user at any time can know only one....
=
Thanks for your time....

Regards,
</VJ>



On Mon, Jul 6, 2009 at 4:17 PM, Sandeep = Tata <sandee= p.tata@gmail.com> wrote:
Cassandra does not currently have secondary indexes.

The indexing you see in the code is just a mechanism to get at the
(known) keys and columns quickly.

On Mon, Jul 6, 2009 at 3:59 PM, Vijay<vijay2win@gmail.com> wrote:
> Hi,
> I think this is a very simple question and might have been asked befor= e....
> but=C2=A0couldn't=C2=A0find answer elsewhere.... Sorry if it is=C2= =A0repetitive. We are
> trying to use=C2=A0Cassandre=C2=A0and i am stuck in the datamodel.....=
> Do we have indexed table? i see some classes but dont know what they w= ill be
> used for.... Is the index tell=C2=A0Casandra=C2=A0where exactly the co= lumn and the
> value in the column family is located? Say i do a query for which i do= nt
> have the rowid, i am looking for and i want to get a value of a coumn = with a
> specific value.... will the secoundry index help on it? or should i us= e
> lucene to do that?
> What exactly the index will do and help on?
> Thanks in advance.... May be i am confused because my understanding is=
> completely wrong abt the index.
> Regards,
> </VJ>

--0016e645ab301adc62046e11e930--