Return-Path: 
 <user-return-9729-apmail-cassandra-user-archive=cassandra.apache.org@cassandra.apache.org>
Delivered-To: apmail-cassandra-user-archive@www.apache.org
Received: (qmail 2182 invoked from network); 7 Oct 2010 13:46:09 -0000
Received: from unknown (HELO mail.apache.org) (140.211.11.3)
  by 140.211.11.9 with SMTP; 7 Oct 2010 13:46:09 -0000
Received: (qmail 20517 invoked by uid 500); 7 Oct 2010 13:46:08 -0000
Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org
Received: (qmail 20464 invoked by uid 500); 7 Oct 2010 13:46:06 -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 20456 invoked by uid 99); 7 Oct 2010 13:46:05 -0000
Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136)
    by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 07 Oct 2010 13:46:05 +0000
X-ASF-Spam-Status: No, hits=2.9 required=10.0
	tests=HTML_MESSAGE,RCVD_IN_DNSWL_NONE,SPF_NEUTRAL
X-Spam-Check-By: apache.org
Received-SPF: neutral (athena.apache.org: local policy)
Received: from [209.85.215.44] (HELO mail-ew0-f44.google.com) (209.85.215.44)
    by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 07 Oct 2010 13:45:59 +0000
Received: by ewy21 with SMTP id 21so268418ewy.31
        for <user@cassandra.apache.org>; Thu, 07 Oct 2010 06:45:37 -0700 (PDT)
MIME-Version: 1.0
Received: by 10.213.28.205 with SMTP id n13mr1583744ebc.5.1286459132954; Thu,
 07 Oct 2010 06:45:32 -0700 (PDT)
Received: by 10.14.29.66 with HTTP; Thu, 7 Oct 2010 06:45:32 -0700 (PDT)
X-Originating-IP: [108.117.88.249]
In-Reply-To: <AANLkTik7Mrgs+bseNKBh-WYc7Zu2ycOAS287V-ZxecVy@mail.gmail.com>
References: <AANLkTik7Mrgs+bseNKBh-WYc7Zu2ycOAS287V-ZxecVy@mail.gmail.com>
Date: Thu, 7 Oct 2010 08:45:32 -0500
Message-ID: <AANLkTi=ZZeLZ4pGWhpmFKJytxqC=MYJdjcQAzf74z7gh@mail.gmail.com>
Subject: Re: Creating and using indices
From: Matthew Dennis <mdennis@riptano.com>
To: user@cassandra.apache.org
Content-Type: multipart/alternative; boundary=0015174c3960a347c00492071b8e

--0015174c3960a347c00492071b8e
Content-Type: text/plain; charset=ISO-8859-1

If I remember correctly the only operator supported for secondary indexes
right now is EQ, not LTE (or the others).

On Thu, Oct 7, 2010 at 6:13 AM, Christian Decker <decker.christian@gmail.com
> wrote:

> I'm currently trying to get started on secondary indices in Cassandra
> 0.7.0svn, but without any luck so far. I have the following code that should
> create an index on ColA:
>
>         KsDef ksDef = client.describe_keyspace("MyKeyspace");
>>         List<CfDef> cfs = ksDef.cf_defs;
>>         String columnFamily = "MyCF";
>>         for(CfDef cf : ksDef.cf_defs){
>>             if(cf.getName().equals(columnFamily)){
>>                 ColumnDef cd1 = new ColumnDef("ColA".getBytes(),
>> "org.apache.cassandra.db.marshal.UTF8Type");
>>                 cd1.index_type = IndexType.KEYS;
>>                 cf.column_metadata.add(cd1);
>>                 // Write changes back to DB
>>                 client.system_update_column_family(cf);
>>             }
>>         }
>>
>
> which seems to work nicely since when turning up the logging level of
> Cassandra it appears to apply some migrations, but then when I try to use a
> pycassa client to read an indexed_slice I only get an
> InvalidRequestException(why='No indexed columns present in index clause with
> operator EQ'):
>
> cf = pycassa.ColumnFamily(client, "MyCF")
>> ex = pycassa.index.create_index_expression('ColA', '50000000000000',
>> pycassa.index.IndexOperator.LTE)
>> clause = pycassa.index.create_index_clause([ex])
>> cf.get_indexed_slices(clause)
>>
>
>  Am I missing something?
>
> Regards,
> Chris
>



-- 
Riptano
Software and Support for Apache Cassandra
http://www.riptano.com/
mdennis@riptano.com
m: 512.587.0900 f: 866.583.2068

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

If I remember correctly the only operator supported for secondary indexes r=
ight now is EQ, not LTE (or the others).<br><br><div class=3D"gmail_quote">=
On Thu, Oct 7, 2010 at 6:13 AM, Christian Decker <span dir=3D"ltr">&lt;<a h=
ref=3D"mailto:decker.christian@gmail.com">decker.christian@gmail.com</a>&gt=
;</span> wrote:<br>
<blockquote class=3D"gmail_quote" style=3D"margin: 0pt 0pt 0pt 0.8ex; borde=
r-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">I&#39;m currently=
 trying to get started on secondary indices in Cassandra 0.7.0svn, but with=
out any luck so far. I have the following code that should create an index =
on ColA:<br>
<br><blockquote style=3D"margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid =
rgb(204, 204, 204); padding-left: 1ex;" class=3D"gmail_quote">

=A0=A0=A0 =A0=A0=A0 KsDef ksDef =3D client.describe_keyspace(&quot;MyKeyspa=
ce&quot;);<br>=A0=A0=A0 =A0=A0=A0 List&lt;CfDef&gt; cfs =3D ksDef.cf_defs;<=
br>=A0=A0=A0 =A0=A0=A0 String columnFamily =3D &quot;MyCF&quot;;<br>=A0=A0=
=A0 =A0=A0=A0 for(CfDef cf : ksDef.cf_defs){<br>=A0=A0=A0 =A0=A0=A0 =A0=A0=
=A0 if(cf.getName().equals(columnFamily)){<br>


=A0=A0=A0 =A0=A0=A0 =A0=A0=A0 =A0=A0=A0 ColumnDef cd1 =3D new ColumnDef(&qu=
ot;ColA&quot;.getBytes(), &quot;org.apache.cassandra.db.marshal.UTF8Type&qu=
ot;);<br>=A0=A0=A0 =A0=A0=A0 =A0=A0=A0 =A0=A0=A0 cd1.index_type =3D IndexTy=
pe.KEYS;<br>=A0=A0=A0 =A0=A0=A0 =A0=A0=A0 =A0=A0=A0 cf.column_metadata.add(=
cd1);<br>


=A0=A0=A0 =A0=A0=A0 =A0=A0=A0 =A0=A0=A0 // Write changes back to DB<br>=A0=
=A0=A0 =A0=A0=A0 =A0=A0=A0 =A0=A0=A0 client.system_update_column_family(cf)=
;<br>=A0=A0=A0 =A0=A0=A0 =A0=A0=A0 }<br>=A0=A0=A0 =A0=A0=A0 }<br></blockquo=
te><div><br>which seems to work nicely since when turning up the logging le=
vel of Cassandra it appears to apply some migrations, but then when I try t=
o use a pycassa client to read an indexed_slice I only get an InvalidReques=
tException(why=3D&#39;No indexed columns present in index clause with opera=
tor EQ&#39;):<br>


<br><blockquote style=3D"margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid =
rgb(204, 204, 204); padding-left: 1ex;" class=3D"gmail_quote">cf =3D pycass=
a.ColumnFamily(client, &quot;MyCF&quot;)<br>ex =3D pycassa.index.create_ind=
ex_expression(&#39;ColA&#39;, &#39;50000000000000&#39;, pycassa.index.Index=
Operator.LTE)<br>


clause =3D pycassa.index.create_index_clause([ex])<br>cf.get_indexed_slices=
(clause)<br></blockquote><div><br>=A0Am I missing something?<br><br>Regards=
,<br>Chris<br></div></div>
</blockquote></div><br><br clear=3D"all"><br>-- <br>Riptano<br>Software and=
 Support for Apache Cassandra<br><a href=3D"http://www.riptano.com/" target=
=3D"_blank">http://www.riptano.com/</a><br><a href=3D"mailto:mdennis@riptan=
o.com" target=3D"_blank">mdennis@riptano.com</a><br>
m: 512.587.0900 f: 866.583.2068<br>

--0015174c3960a347c00492071b8e--