create index on existing table does not work about cassandra-lucene-index HOT 5 CLOSED

It should be able to index already existing data. Index build take some time, depending on the amount of stored data, your hardware and your schema.

Have you seen a message like Index build of <index_name> complete in the Cassandra log file before doing your queries? Is the log file reporting any error?

from cassandra-lucene-index.

Thank for your great work, @adelapena. Yes, it did index and took some time to complete.
Here, I run on my laptop with core I5,SSD and 8GB of RAM.
I have existing table with 20 millions partition(row) after issue the command to create index
create custom index tweets.idx on tweets(lucene) using 'com.stratio.cassandra.lucene.Index' with options={'refresh_seconds':'1','schema':'{fields:{message:{type:"string"}}}'}, it took sometime, I did not check casandra log, but I wait until the CPU stop indexing, then I started to query again with no result, so I decided to leave it one more hour, still query with no result.

from cassandra-lucene-index.

It working now. Thank @adelapena

from cassandra-lucene-index.

Great! So, can we close the issue?

By the way, you can also monitor the number of indexed rows through JMX.

from cassandra-lucene-index.

Yes! thank @adelapena .

from cassandra-lucene-index.