How to get last indexed record in Solr?

java apache solr indexing solrj
milind_db picture milind_db · Sep 10, 2012 · Viewed 11.1k times · Source

I want to know how to get/search last indexed record in Apache Solr..?

When the existing record is updated then it goes to end of all the records...so I want to get that last indexed record.

thanks..

Answer

prunge picture prunge · Sep 10, 2012

You could add a 'timestamp' field to your Solr schema that puts the current date/time into the record when it is added.

<field name="timestamp" type="date" indexed="true" stored="true" default="NOW" multiValued="false"/>

Then, do a sort in descending order by this field and the first record will be the latest one. A query like this should do it:-

http://localhost:8080/solr/core-name/select/q=*%3A*&start=0&rows=1&sort=timestamp+desc

Related questions

What is the advantage of storing schema in avro?

We need to serialize some data for putting into solr as well as hadoop. I am evaluating serialization tools for the same. The top two in my list are Gson and Avro. As far as I understand, Avro = Gson + Schema-In-JSON …

Read More
how to make log4j to write to the console as well

Is there any way to tell to log4j to write its log to the file and to the console? thanks there are my properties: log4j.rootLogger=DEBUG,console,R log4j.rootLogger=INFO, FILE log4j.appender.CONSOLE=…

Read More
Tomcat is not running even though JAVA_HOME path is correct

When I am trying to run tomcat using startup.bat I get the following error, The JAVA_HOME environment variable is not defined correctly This environment variable is needed to run this program NB: JAVA_HOME should point to a …

Read More