PerRowSecondaryIndex uses

[Manoj Mainali <ma...@gmail.com>]

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