Add _timestamp to Elasticsearch results using Java API

Question

I have an Elasticsearch index which has _timestamp populated on every record. Using Marvel or curl I can get the _timestamp in the "fields" part of the result for example:

GET index/type/_search?fields=_timestamp,_source
{
   "took": 11,
   "timed_out": false,
   "_shards": {
      "total": 3,
      "successful": 3,
      "failed": 0
   },
   "hits": {
      "total": 116888,
      "max_score": 1,
      "hits": [
         {
            "_index": "index",
            "_type": "type",
            "_id": "mXJdWqSLSfykbMtChiCRjA",
            "_score": 1,
            "_source": {
               "results": "example",
            },
            "fields": {
               "_timestamp": 1443618319514
            }
         },...

However when doing a search using the Java API I cant get it to return the _timestamp.

SearchRequestBuilder builder= client.prepareSearch(index)
            .addFacet(facet)
            .setFrom(start)
            .setSize(limit);
SearchResponse response = builder.execute().actionGet();

Can anyone tell me how to ask for _timestamp too?

Val · Accepted Answer · 2015-11-02 19:37:25Z

1

You simply need to use the setFields() method like this:

SearchRequestBuilder builder= client.prepareSearch(index)
            .setType(type)
            .addFacet(facet)
            .setFields("_timestamp")          <--- add this line
            .setFrom(start)
            .setSize(limit);
SearchResponse response = builder.execute().actionGet();

edited Nov 2, 2015 at 19:37

answered Oct 31, 2015 at 5:07

Val

218k14 gold badges377 silver badges384 bronze badges

Sign up to request clarification or add additional context in comments.

9 Comments

llebpmac Over a year ago

.setFields is not an available method in my version of ES however I used addFields instead and it still did not return the timestamp. Any other ideas?

SearchRequestBuilder buider = client.prepareSearch(index) 				.addFacet(facet) 				.addFields("_timestamp", "_source") 				.setFrom(start) 				.setSize(limit); 			return builder;

Val Over a year ago

And what version is that?

llebpmac Over a year ago

Elasticsearch version 1.1.1. When I added .addFields('_timestamp') then the source disappeared. But when I used .addFields("timestamp", "_source") the source returns again but still no time stamp, even though it is being stored.

Val Over a year ago

1.1.1, ouch :) It's weird, though, because I could find the setFields method in the 1.1.1 release.

llebpmac Over a year ago

Unfortunately 1.1.1 :( Yes but that is for the GetRequestBuilder whereas im using the SearchRequestBuilder

|

Collectives™ on Stack Overflow

Add _timestamp to Elasticsearch results using Java API

1 Answer 1

9 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

9 Comments

Your Answer

Sign up or log in

Post as a guest

Related