Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@cassandra.apache.org
Received-SPF: pass (nike.apache.org: domain of mainalimanoj@gmail.com
 designates 209.85.217.175 as permitted sender)
MIME-Version: 1.0
Date: Wed, 12 Jun 2013 15:02:53 +0900
Message-ID: 
 <CALGwdJUDgyB1F7F4Cs1Jdtt13GikVfxaajGdpkGEcewzrwE4gg@mail.gmail.com>
Subject: PerRowSecondaryIndex uses
From: Manoj Mainali <mainalimanoj@gmail.com>
To: "user@cassandra.apache.org" <user@cassandra.apache.org>
Content-Type: multipart/alternative; boundary=001a11c3e880b3c0b904deeec390

--001a11c3e880b3c0b904deeec390
Content-Type: text/plain; charset=ISO-8859-1

I am looking into the C* secondary index feature so that I could query the
rows based on the column value. In my use case, I wanted to create index of
 several columns or maybe all columns of a row. (A single row does not have
many columns, maybe around 50 - 100 columns) and was looking into
PerRowSecondaryIndex, but I could not find a way to create index using this.

First, C* does not have a default implementation of it like KeysIndex for
PerColumnSecondaryIndex, so I implemented my own. However, I could not find
a way on how I could define it on the client side.

The only way I was able to use it was to define the PerRowSecondaryIndex
class when creating a column index as follows (assuming astyanax client)

ColumnDefinition cd = cluster.makeColumnDefinition();
cd.setName("Index1");
cd.setIndex("INDEX_NAME", "CUSTOM");
cd.setValidationClass("AsciiType");
cd.setOption("class_name",
"org.apache.cassandra.db.index.PerRowSecondaryIndexImpl");
cfDef.addColumnDefinition(cd);

But, this approach would mean although I am creating a index for the whole
row I am doing it through a index creation of a single column.

Is there a better way of creating the row level index? Any examples on how
to do that, if any?

Best regards,

Manoj

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

<div dir=3D"ltr">I am looking into the C* secondary index feature so that I=
 could query the rows based on the column value. In my use case, I wanted t=
o create index of =A0several columns or maybe all columns of a row. (A sing=
le row does not have many columns, maybe around 50 - 100 columns) and was l=
ooking into PerRowSecondaryIndex, but I could not find a way to create inde=
x using this.<div>
<br></div><div>First, C* does not have a default implementation of it like =
KeysIndex for PerColumnSecondaryIndex, so I implemented my own. However, I =
could not find a way on how I could define it on the client side.</div>
<div><br></div><div style>The only way I was able to use it was to define t=
he PerRowSecondaryIndex class when creating a column index as follows (assu=
ming astyanax client)</div><div style><br></div><div style><div>ColumnDefin=
ition cd =3D cluster.makeColumnDefinition();</div>
<div>cd.setName(&quot;Index1&quot;);</div><div>cd.setIndex(&quot;INDEX_NAME=
&quot;, &quot;CUSTOM&quot;);</div><div>cd.setValidationClass(&quot;AsciiTyp=
e&quot;);</div><div>cd.setOption(&quot;class_name&quot;, &quot;org.apache.c=
assandra.db.index.PerRowSecondaryIndexImpl&quot;);</div>
<div>cfDef.addColumnDefinition(cd);</div><div><br></div><div style>But, thi=
s approach would mean although I am creating a index for the whole row I am=
 doing it through a index creation of a single column.</div><div style>
<br></div><div style>Is there a better way of creating the row level index?=
 Any examples on how to do that, if any?</div><div style><br></div><div sty=
le>Best regards,</div><div style><br></div><div style>Manoj</div></div>
<div><br></div><div><br><div><div><br></div><div><br></div></div></div></di=
v>

--001a11c3e880b3c0b904deeec390--