Return-Path: 
 <user-return-32492-apmail-cassandra-user-archive=cassandra.apache.org@cassandra.apache.org>
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 D1A82D0DE
	for <apmail-cassandra-user-archive@www.apache.org>;
 Fri,  8 Mar 2013 07:29:49 +0000 (UTC)
Received: (qmail 79386 invoked by uid 500); 8 Mar 2013 07:29:47 -0000
Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org
Received: (qmail 78661 invoked by uid 500); 8 Mar 2013 07:29:45 -0000
Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:user-help@cassandra.apache.org>
List-Unsubscribe: <mailto:user-unsubscribe@cassandra.apache.org>
List-Post: <mailto:user@cassandra.apache.org>
List-Id: <user.cassandra.apache.org>
Reply-To: user@cassandra.apache.org
Delivered-To: mailing list user@cassandra.apache.org
Received: (qmail 78600 invoked by uid 99); 8 Mar 2013 07:29:44 -0000
Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230)
    by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 08 Mar 2013 07:29:44 +0000
X-ASF-Spam-Status: No, hits=1.5 required=5.0
	tests=HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_PASS
X-Spam-Check-By: apache.org
Received-SPF: pass (nike.apache.org: domain of sylvain@datastax.com designates
 209.85.160.54 as permitted sender)
Received: from [209.85.160.54] (HELO mail-pb0-f54.google.com) (209.85.160.54)
    by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 08 Mar 2013 07:29:38 +0000
Received: by mail-pb0-f54.google.com with SMTP id rr4so996731pbb.27
        for <user@cassandra.apache.org>; Thu, 07 Mar 2013 23:29:17 -0800 (PST)
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=google.com; s=20120113;
        h=mime-version:x-received:in-reply-to:references:date:message-id
         :subject:from:to:content-type:x-gm-message-state;
        bh=kYh+Bb+eSXMS6uy83Qo1eIShxOWPpPvxKg4xkO057cY=;
        b=NyT86D0cgbiN5brfEX2a8PEhnz70gLxHkjKZzgn6PE1nJgZ/OqPE6P2/TuYvgfr2gD
         FU9MTDehLiTTfCd0sElTC1rIufCtmt0b2mvOSCak7V4rwTdFv5HqutePr/GwFdds2w5Z
         7vVO8R2eU2Xu8Y5sn+e00cjBeNBAuQ6DVgawLGBPIOS87WPs2LsB4QDloNKjJJIyWE0/
         /hvQ7JHtq5zh+S+uYS2V76r7aSNMvkLUHZ17PsrQMNWsYcol4HAkilaDKB/l2k+nFV25
         ziQR9CeiGEv3mHKjeA4qtTt8da7Qtoc/Q1O6JM0cb0f6H+QBGLvGpP7Mngz56U21Gq5k
         CsKA==
MIME-Version: 1.0
X-Received: by 10.66.193.42 with SMTP id hl10mr2662253pac.62.1362727756825;
 Thu, 07 Mar 2013 23:29:16 -0800 (PST)
Received: by 10.68.223.197 with HTTP; Thu, 7 Mar 2013 23:29:16 -0800 (PST)
In-Reply-To: 
 <CAH4ZcEsFhZ-8YDON1n7VjKQS7c2tOiTim+sT4oxkXPVOR4UUtw@mail.gmail.com>
References: 
 <CAH4ZcEsFhZ-8YDON1n7VjKQS7c2tOiTim+sT4oxkXPVOR4UUtw@mail.gmail.com>
Date: Fri, 8 Mar 2013 08:29:16 +0100
Message-ID: 
 <CAKkz8Q0LHLPHkRuuK8YXbr6hFciK4q=ztqGrPwxwcenLnd8fHQ@mail.gmail.com>
Subject: Re: Limitations on secondary indexes
From: Sylvain Lebresne <sylvain@datastax.com>
To: "user@cassandra.apache.org" <user@cassandra.apache.org>
Content-Type: multipart/alternative; boundary=047d7bdc7f76df19b104d764c712
X-Gm-Message-State: 
 ALoCoQl21BOuyLDHNTm8F7VPRhEX1nIgLVMGGvGXS+40LERZWucVfcMQsO1AUX705LSogt05KKul
X-Virus-Checked: Checked by ClamAV on apache.org

--047d7bdc7f76df19b104d764c712
Content-Type: text/plain; charset=ISO-8859-1

Not exactly. Each replica only indexes the rows that it is a replica for.
So there is a limitation currently indeed, but it is of 2 billion indexed
rows per-node.


On Thu, Mar 7, 2013 at 8:05 PM, Edward Sargisson <esarge@pobox.com> wrote:

> Hi,
> Please correct me if this statement is wrong.
>
> Secondary indexes are limited to indexing 2 billion rows - because they
> turn a row into a column and C* has a limit of 2 billion columns.
>
> Cheers,
> Edward
>

--047d7bdc7f76df19b104d764c712
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">Not exactly. Each replica only indexes the rows that it is=
 a replica for. So there is a limitation currently indeed, but it is of 2 b=
illion indexed rows per-node.=A0</div><div class=3D"gmail_extra"><br><br><d=
iv class=3D"gmail_quote">
On Thu, Mar 7, 2013 at 8:05 PM, Edward Sargisson <span dir=3D"ltr">&lt;<a h=
ref=3D"mailto:esarge@pobox.com" target=3D"_blank">esarge@pobox.com</a>&gt;<=
/span> wrote:<br><blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8=
ex;border-left:1px #ccc solid;padding-left:1ex">
<div dir=3D"ltr"><div><div><div>Hi,<br></div>Please correct me if this stat=
ement is wrong.<br><br></div>Secondary indexes are limited to indexing 2 bi=
llion rows - because they turn a row into a column and C* has a limit of 2 =
billion columns.<br>

<br></div>Cheers,<br>Edward<br></div>
</blockquote></div><br></div>

--047d7bdc7f76df19b104d764c712--