From user-return-35067-apmail-cassandra-user-archive=cassandra.apache.org@cassandra.apache.org Fri Jul 5 02:36:43 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 D1133104FD for ; Fri, 5 Jul 2013 02:36:43 +0000 (UTC) Received: (qmail 44308 invoked by uid 500); 5 Jul 2013 02:36:40 -0000 Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org Received: (qmail 44263 invoked by uid 500); 5 Jul 2013 02:36:39 -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 44255 invoked by uid 99); 5 Jul 2013 02:36:37 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 05 Jul 2013 02:36:37 +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 (athena.apache.org: local policy) Received: from [98.138.90.153] (HELO nm5-vm2.bullet.mail.ne1.yahoo.com) (98.138.90.153) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 05 Jul 2013 02:36:30 +0000 Received: from [98.138.90.48] by nm5.bullet.mail.ne1.yahoo.com with NNFMP; 05 Jul 2013 02:36:09 -0000 Received: from [98.138.89.253] by tm1.bullet.mail.ne1.yahoo.com with NNFMP; 05 Jul 2013 02:36:09 -0000 Received: from [127.0.0.1] by omp1045.mail.ne1.yahoo.com with NNFMP; 05 Jul 2013 02:36:09 -0000 X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 430389.35644.bm@omp1045.mail.ne1.yahoo.com Received: (qmail 39310 invoked by uid 60001); 5 Jul 2013 02:36:09 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s1024; t=1372991769; bh=Cxm9s7k3DBTQwXb3Yul4rdHYWkVrbdPpru2TswDaYOY=; h=X-YMail-OSG:Received:X-Rocket-MIMEInfo:X-Mailer:Message-ID:Date:From:Reply-To:Subject:To:MIME-Version:Content-Type; b=jUItCvwdJIgpPPRfjep1i7aIB6A8X3LCWBDboqLCdFO61WaBrmepxRdIM53AZk5nzJ1IfrkL+J8O6zWka6rrHsv8N52qKZPen4okN7rXQsP7Fg5kvRlEir/2hXAgdtgr9afotUEk2zho0HB8xiuRfY44CSdXppV7xxdzOp2ygB0= DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:X-Rocket-MIMEInfo:X-Mailer:Message-ID:Date:From:Reply-To:Subject:To:MIME-Version:Content-Type; b=i0rqk2N1We9qxx3vJUduiW8VGwd8wwI86LM6bLX20fQcRr3d5V2QR4ucEbmOew5riNYCy6ijRqgAyChz66tql5dkFEk0cEFylkCzloPsWXRXXnvdQPEZf2ztBY0t8PkGayO6hCpVWiCiDA8QkKopS8y75w/hDOsjCNteUMeJ/bY= ; X-YMail-OSG: dOpOM1gVM1nlzY7FGGmED2Gsz40Nv6w_Tn3MXr7wYcsndPv .0gCKHeabX9_zYWt_EBd99QPfzIJRQa2DWa_I31WiTdJR8KFduptNFQoANH_ xDKZMXFhC7OtYethef4Bv5w99ProKgwZVgwyiwHLpsxEU.BB9Esg8a8rQz5J akormh7_oFhFYXJkrOrYrOnIaxjqguED.OexSywSlem7SKqtnGjel8X05Dfa s3kkwtx0kRKxfKBFzrsCTTqioV7w8OzSl00GKg3pVwnllU3Tat.RkQOLdqbF 8NVPqT3oRXrqwuRLJrXjOKaImT6ZL2.qORvmWQ1VfHQnijCqByGXMuIg4J8G PyZkdnK7UpEBNWe2iwJgjhWbQlsoMPpQ8x4ev4HPMexsNwzbir6BR3mtX1Dn KZWOfCgu4TgDhxEfkKtGlcChJcV8tPwnS3OtEbOJZlwWUPMBVAKvZMWalip2 mrK6_RWOkPlnsesE_WrCA4SphSofqcSyiIxtZWn4.AeGWd63EIlhnK3PK9Ud kXXj_k_EGIwPl70l1oGVSW_JcW..2WEpB.q3mxaIfmED5oTYLfHJEwNT4hMu V2uOlXXIw930lNjt44i3kFdChMvWTQxc- Received: from [204.228.207.218] by web121802.mail.ne1.yahoo.com via HTTP; Thu, 04 Jul 2013 19:36:09 PDT X-Rocket-MIMEInfo: 002.001,SGkgQWxsLAoKSSB1cGRhdGVkIGEgdGFibGUgd2l0aCBhIHNlY29uZGFyeSBpbmRleC4gSSBkaXNjb3ZlcmVkIHVzaW5nIENMSSBkZXNjcmliZSB0aGF0IHRoZSBpbmRleCB3YXMgbm90IGJ1aWx0LgoKSG93IGRvIEkgYnVpbGQgYW4gaW5kZXggYWZ0ZXIgSSBoYXZlIGFsdGVyZWQgYW4gZXhpc3RpbmcgdGFibGUgd2l0aCBkYXRhPwoKSSBsb29rZWQgYXQgbm9kZXRvb2wgYW5kIGNsaSBhbmQgc2F3IG5vIGNvbW1hbmQgdGhhdCBoYWQgdGhlIHdvcmQgYnVpbGQgaW5kZXggYXNzb2NpYXRlZCB3aXRoIGl0LiBBbmQBMAEBAQE- X-Mailer: YahooMailWebService/0.8.148.557 Message-ID: <1372991769.38783.YahooMailNeo@web121802.mail.ne1.yahoo.com> Date: Thu, 4 Jul 2013 19:36:09 -0700 (PDT) From: Tony Anecito Reply-To: Tony Anecito Subject: How to build indexes? To: Users-Cassandra MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="-509655459-1427198826-1372991769=:38783" X-Virus-Checked: Checked by ClamAV on apache.org ---509655459-1427198826-1372991769=:38783 Content-Type: text/plain; charset=us-ascii Hi All, I updated a table with a secondary index. I discovered 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 associated 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. Thanks, -Tony ---509655459-1427198826-1372991769=:38783 Content-Type: text/html; charset=us-ascii
Hi All,

I updated a table with a secondary index. I discovered 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 associated 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.

Thanks,
-Tony

---509655459-1427198826-1372991769=:38783--