Unable to use multiple indexes on same table

[adkhare]

I am trying to create multiple indices on multiple columns and i am unable to do the same. As soon as i create a new index, it always references the first index.

[kadiyams]

There is a basic mis understanding on how you would use this feature adkhare.
If you want to use the regular indexes on CASSANDRA columns you can just use them. This would not stop you from defining multiple cassandra secondary indexes on multiple columns on a single table.

But if you are using STARGATE index, you can use it only on one column per table. You have to use all the columns in the table that you would query upon into this index.
You have to create your filter query which could span on conditions to evaluate multiple columns at a time.

So this is not an issue, but lack of proper understanding on the user part.

[adkhare]

Well, I brought this point as I thought it might help to index additional columns as and when new columns are added to the schema.

This will help to move away from re-indexing whole data whenever new columns are to the table and need them to be indexed. This is an issue with the Datastax Enterprise Solr integration as well wherein, we need to drop the configuration and reload the configuration XML.

[trulite]

One way we could achieve what you want is to have additional per column indices for each new row added (this was available in the early implementations btw) and also use that while searching the single row index. It is possible to do this efficiently. Let me know if it works for you.

P.S. When you add a new column to a row index, because of the way row indexing works in Cassandra the whole data is played back to the index. So this may not be what you are looking for.