From user-return-35074-apmail-cassandra-user-archive=cassandra.apache.org@cassandra.apache.org Fri Jul 5 13:43:15 2013 Return-Path: X-Original-To: apmail-cassandra-user-archive@www.apache.org Delivered-To: apmail-cassandra-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 1DBFCF2E6 for ; Fri, 5 Jul 2013 13:43:15 +0000 (UTC) Received: (qmail 92391 invoked by uid 500); 5 Jul 2013 13:43:12 -0000 Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org Received: (qmail 92103 invoked by uid 500); 5 Jul 2013 13:43:12 -0000 Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@cassandra.apache.org Delivered-To: mailing list user@cassandra.apache.org Received: (qmail 92095 invoked by uid 99); 5 Jul 2013 13:43:11 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 05 Jul 2013 13:43:11 +0000 X-ASF-Spam-Status: No, hits=2.2 required=5.0 tests=HTML_MESSAGE,RCVD_IN_DNSWL_NONE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: local policy) Received: from [98.138.229.147] (HELO nm38-vm3.bullet.mail.ne1.yahoo.com) (98.138.229.147) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 05 Jul 2013 13:43:04 +0000 Received: from [98.138.90.56] by nm38.bullet.mail.ne1.yahoo.com with NNFMP; 05 Jul 2013 13:42:42 -0000 Received: from [98.138.101.173] by tm9.bullet.mail.ne1.yahoo.com with NNFMP; 05 Jul 2013 13:42:42 -0000 Received: from [127.0.0.1] by omp1084.mail.ne1.yahoo.com with NNFMP; 05 Jul 2013 13:42:42 -0000 X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 905045.74212.bm@omp1084.mail.ne1.yahoo.com Received: (qmail 23444 invoked by uid 60001); 5 Jul 2013 13:42:42 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s1024; t=1373031762; bh=aln7RYWScr7+EnYEDfqw55152bfAztPWoX5jB4QPUa8=; h=X-YMail-OSG:Received:X-Rocket-MIMEInfo:X-Mailer:References:Message-ID:Date:From:Reply-To:Subject:To:In-Reply-To:MIME-Version:Content-Type; b=tYy4u5GmbBhvcCHdSiGEDipJcLSGrsvQhK+nyrd50t2sbeDKcfLzycA5OYH4+reQUbQj9k9O6uXf5qrpG0B0RW9yYd+FXMO0hUF4pZPhv4KRnkqEU+UVBpGngUTp+YESyqNNTV38VytelHyvTga4PoFEyJu3e9iN4AMJtx1Ccmw= DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:X-Rocket-MIMEInfo:X-Mailer:References:Message-ID:Date:From:Reply-To:Subject:To:In-Reply-To:MIME-Version:Content-Type; b=3dqmoAFPPPtvUYmY/OZ4qrnEFZngarK6Q5dGaJgYJ6XfHCJe6v+HlpZ2HRS7x9w+uMH8yZmEiojOfxle/1mlvhc4AXmyLrJEEh11IM8sf7Vu+qfSNgM+K01yF+nFVUdnaqEAunfpPWOXbbDudthOIDT7sZMQacBfYYJK8iNUVow= ; X-YMail-OSG: q6_MWiQVM1muPTZ4djxguHclPy4h15vGGeICTXC6Jl4IvKq fa4rnO.tzGrsmlqkF7XihZnh_icxvaU.Cu_PJaMxj3H4DiOurfswOYIVkSVH lFZ.AASxgVBCS47kjWYPJfDhqoDKoBIq4c0QpjK.lA22y9dYlgjHaiK0YFCL 2VS1erve4E_UON0eoilRHI.YDtGJ65o6_V5ApyP.vys.ZkUzWNriUyDn0_n5 vdeShMoNpVBoIwFIUKWttlDL2RQdE4DMc8AmrAVS07sR.RSUDGb6syXYCV9h unYqWNbyIjzwGxFxPkZw_iwC9_fgAMQmDdQA95anq4.NELjCB10h9rXgncaO S0ldC0nzYWAA1QcLMJGHIjPwYVnxX3JZdp9Sz6G.840n8YqZPhjDwiyI5gZR dQlQlipf3vjWbt.z6R0XL.T9DtX0oDVB97MyXWaxdp54K60XwTdMYDLqloeN VgyRDV19liN7_bR4VU_bB.4J2fuNUosDL36GQ2C6Oh6aVZz6s4ajrSmCQugh xkNXvAMNXMDzcUACmqdeK3He4gWmmV9g46PWI0v5buuKTnpkBfzTk_yaDz8C o2ciCtAZV8uiud2gDAWqGlO.OB9Wd_49qvPhmZXEXxQUETQk6 Received: from [204.228.207.218] by web121806.mail.ne1.yahoo.com via HTTP; Fri, 05 Jul 2013 06:42:42 PDT X-Rocket-MIMEInfo: 002.001,VGhhbmtzLApBcHBhcmVudGx5IGZvciAxLjIuNSBpdCBkaWQgbm90IGJ1aWxkIGF1dG9tYXRpY2FsbHkuIERpZXNjcmliZSBzaG93cyBpbmRleFtdIHdoaWNoIGluZGljYXRlcyBpdCB3YXMgbm90IGJ1aWx0LgrCoApJIHdpbGwgdHJ5IHRoZSBub2RldG9vbCBjb21tYW5kLiBJIGRkIG5vdCBzZWUgaXQgaW4gdGhlIGhlcCBsaXN0IHRob3VnaC4KwqAKQmVzdCBSZWdhcmRzLAotVG9ueQoKRnJvbTogU3lsdmFpbiBMZWJyZXNuZSA8c3lsdmFpbkBkYXRhc3RheC5jb20.ClRvOiAidXNlckBjYXNzYW5kcmEuYXBhY2gBMAEBAQE- X-Mailer: YahooMailWebService/0.8.148.557 References: <1372991769.38783.YahooMailNeo@web121802.mail.ne1.yahoo.com> Message-ID: <1373031762.23202.YahooMailNeo@web121806.mail.ne1.yahoo.com> Date: Fri, 5 Jul 2013 06:42:42 -0700 (PDT) From: Tony Anecito Reply-To: Tony Anecito Subject: Re: How to build indexes? To: "user@cassandra.apache.org" In-Reply-To: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="836554814-1148437787-1373031762=:23202" X-Virus-Checked: Checked by ClamAV on apache.org --836554814-1148437787-1373031762=:23202 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable Thanks,=0AApparently for 1.2.5 it did not build automatically. Diescribe sh= ows index[] which indicates it was not built.=0A=A0=0AI will try the nodeto= ol command. I dd not see it in the hep list though.=0A=A0=0ABest Regards,= =0A-Tony=0A=0AFrom: Sylvain Lebresne =0ATo: "user@cas= sandra.apache.org" ; Tony Anecito =0ASent: Friday, July 5, 2013 3:12 AM=0ASubject: Re: How to build i= ndexes?=0A=0A=0A=0ACreating a secondary index will trigger the build of tha= t index automatically.=0A=0AHowever, that built is done asynchronously and = can take some time if you have lots of existing data to index. To know when= that building is done, you can check the nodes log for an entry looking li= ke "Index build of complete" (you can also check the IndexInfo= system table (SELECT * FROM system."IndexInfo", the quotes matter for back= ward compatibility reason), a row for the new index will appear in that tab= le when it's built).=0A=0AYou can also force a rebuild however if you want = using nodetool rebuild_index.=0A=0A=0A=0A=0AOn Fri, Jul 5, 2013 at 4:36 AM,= Tony Anecito wrote:=0A=0AHi All,=0A>=0A>I updated a = table with a secondary index. I discovered using CLI describe that the inde= x was not built.=0A>=0A>How do I build an index after I have altered an exi= sting table with data?=0A>=0A>I looked at nodetool and cli and saw no comma= nd that had the word build index associated with it. And most of the postin= gs I have found so far cover creating an index but not building it or verif= ying the index was built.=0A>=0A>Thanks,=0A>-Tony=0A>=0A>=0A> --836554814-1148437787-1373031762=:23202 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable
Thanks,
Apparently for 1.2.5 it did n= ot build automatically. Diescribe shows index[] which indicates it was not = built.
 
I will try the nodetool comma= nd. I dd not see it in the hep list though.
 
Best Regards,
-Tony=

From: Sylvain Lebresne <sylvain@datast= ax.com>
To: "user@cas= sandra.apache.org" <user@cassandra.apache.org>; Tony Anecito <adan= ecito@yahoo.com>
Sent: Friday, July 5, 2013 3:12 AM
Sub= ject: Re: How to build indexes?

Creating a secondary index will trigger the build of that index automa= tically.

However, that built is done asynchronously and can take some time if y= ou have lots of existing data to index. To know when that building is done,= you can check the nodes log for an entry looking like "Index build of <= index_name> complete" (you can also check the IndexInfo system table (SE= LECT * FROM system."IndexInfo", the quotes matter for backward compatibilit= y reason), a row for the new index will appear in that table when it's buil= t).

You can also force a rebuild however if you want using nodetool rebuil= d_index.



On Fri, Jul 5, 2013 at 4:36 AM, Tony = Anecito <adanecito@yah= oo.com> wrote:
Hi All,

I updated a table with a secondary index. I discov= ered using CLI describe that the index was not built.

How do I build= an index after I have altered an existing table with data?

I looked= at nodetool and cli and saw no command that had the word build index assoc= iated with it. And most of the postings I have found so far cover creating = an index but not building it or verifying the index was built.

Thank= s,
-Tony




--836554814-1148437787-1373031762=:23202--