Response mapping

Mihai_Cazacu · March 10, 2013, 9:01pm

Hi,

Is there an automatic way to map a search result like http://www.elasticsearch.org/guide/reference/api/search/fields.html to the correspondig object type?
Let's say that I have stored a "Person" object with firstName, latName and age and I make a query for firstName and age fields. How can I map automatically the response to the Person?

Thanks,
Mihai

--
You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

dadoonet · March 10, 2013, 9:25pm

I suppose that you are talking about Java Beans, aren't you?
You have to do it yourself using the same tools you used when indexing.
For example, if you use Jackson use it when deserializing.

Have a look here: https://github.com/elasticsearchfr/hands-on/blob/answers/src/test/java/org/elasticsearchfr/handson/ex2/SearchTest.java#L268

HTH

David
Twitter : @dadoonet / @elasticsearchfr / @scrutmydocs

Le 10 mars 2013 à 22:01, Mihai Cazacu cazacugmihai@gmail.com a écrit :

Hi,

Is there an automatic way to map a search result like http://www.elasticsearch.org/guide/reference/api/search/fields.html to the correspondig object type?
Let's say that I have stored a "Person" object with firstName, latName and age and I make a query for firstName and age fields. How can I map automatically the response to the Person?

Thanks,
Mihai

--
You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

Mihai_Cazacu · March 11, 2013, 6:09pm

Yes, I already did this. It's simple when you have access to "getSourceAsString". But how about mapping a query response like this:

GetResponse response = client.prepareGet(index, type, id).setFields("title","name","postDate").execute().actionGet();

Thanks,
Mihai

--
You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

Mihai_Cazacu · March 11, 2013, 6:46pm

Yes, I already did this. It's simple when you have access to
"getSourceAsString". But how about mapping a
org.elasticsearch.action.search.SearchResponse?

Thanks,
Mihai

--
You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

dadoonet · March 11, 2013, 6:56pm

Did you look at the link I gave you?

github.com

elasticsearchfr/hands-on/blob/answers/src/test/java/org/elasticsearchfr/handson/ex2/SearchTest.java#L268


      
          		SearchResponse sr = node.client().prepareSearch().setQuery(qb)
          				.execute().actionGet();
          
          		Assert.assertNotNull(sr);
          		Assert.assertNotNull(sr.getHits());
          		Assert.assertTrue(sr.getHits().getTotalHits() > 0);
          
          		logger.info("We found {} beers", sr.getHits().totalHits());
          
          		for (SearchHit hit : sr.getHits()) {
          			Beer beer = BeerHelper.toBeer(hit.getSourceAsString());
          			Assert.assertEquals("Heineken", beer.getBrand());
          			Assert.assertTrue(beer.getPrice()>5 && beer.getPrice()<10);
          		}
          	}
          	
          	/**
          	 * We want to build a complex Query based on brand name and price fields and we want to filter results
          	 * to have only 1L or more beers.
          	 * <br>We must find Heineken beers with price between 5 and 10 and size more than 1.
          	 * <br>We should have some results (or we are really unlucky!).

SearchResponse sr = node.client().prepareSearch().setQuery(qb).execute().actionGet();

ObjectMapper mapper = new ObjectMapper(); // create once, reuse

for (SearchHit hit : sr.getHits()) {
Beer beer = mapper.readValue(hit.getSourceAsString().getBytes(), Beer.class);
}

It should do what you are expecting? Did I misunderstand what you are after?

--
David Pilato | Technical Advocate | Elasticsearch.com
@dadoonet | @elasticsearchfr | @scrutmydocs

Le 11 mars 2013 à 19:46, Mihai Cazacu cazacugmihai@gmail.com a écrit :

Yes, I already did this. It's simple when you have access to "getSourceAsString". But how about mapping a org.elasticsearch.action.search.SearchResponse?
Thanks,
Mihai

--
You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

--
You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

Mihai_Cazacu · March 12, 2013, 7:18am

Yes, I looked at that link but it is not related to my question.

I have a SearchResponse as a response for a query that request only some
fields from the object (I mentioned in my initial post the link to the
query type
Elasticsearch Platform — Find real-time answers at scale | Elastic):

SearchRequestBuilder requestBuilder = client.prepareSearch....

requestBuilder.addFields("field1", "field5.subField2", "field7")

Now, I want to build my objects from the response.

SearchHits hitsInfo = response.getHits()

SearchHit hits = hitsInfo.hits()
for (SearchHit hit : hits) {

// here, hit.getSourceAsString() returns null 

Map<String, SearchHitField> fields = hit.fields()

MyFullObject obj =  decodeMyFullObject(hit)

}

So, my MyFullObject must be populated with that fields (that represent a
part of all MyFullObject fields) returned by the response.

Thanks,
Mihai

--
You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

dadoonet · March 12, 2013, 8:36am

Ok. I see now. Thanks for the clarification.

I'm afraid you have to build yourself your entity using getters/setters for all individual fields or to create a new JSON with your fields and use Jackson.

One more comment, you can also ask for field _source in requestBuilder.add().

--
David
Twitter : @dadoonet / @elasticsearchfr / @scrutmydocs

Le 12 mars 2013 à 08:18, Mihai Cazacu cazacugmihai@gmail.com a écrit :

Yes, I looked at that link but it is not related to my question.

I have a SearchResponse as a response for a query that request only some fields from the object (I mentioned in my initial post the link to the query type Elasticsearch Platform — Find real-time answers at scale | Elastic):

SearchRequestBuilder requestBuilder = client.prepareSearch....
requestBuilder.addFields("field1", "field5.subField2", "field7")

Now, I want to build my objects from the response.

SearchHits hitsInfo = response.getHits()
SearchHit hits = hitsInfo.hits()
for (SearchHit hit : hits) {
// here, hit.getSourceAsString() returns null
Map<String, SearchHitField> fields = hit.fields()
MyFullObject obj = decodeMyFullObject(hit)
}

So, my MyFullObject must be populated with that fields (that represent a part of all MyFullObject fields) returned by the response.

Thanks,
Mihai

--
You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

Mihai_Cazacu · March 12, 2013, 8:49am

Thanks, David. I resorted to this solution but I thought that there is an
easy way for that mapping.

Best regards,
Mihai

On Tue, Mar 12, 2013 at 10:36 AM, David Pilato david@pilato.fr wrote:

Ok. I see now. Thanks for the clarification.

I'm afraid you have to build yourself your entity using getters/setters
for all individual fields or to create a new JSON with your fields and use
Jackson.

One more comment, you can also ask for field _source in
requestBuilder.add().

--
David
Twitter : @dadoonet / @elasticsearchfr / @scrutmydocs

Le 12 mars 2013 à 08:18, Mihai Cazacu cazacugmihai@gmail.com a écrit :

Yes, I looked at that link but it is not related to my question.

I have a SearchResponse as a response for a query that request only some
fields from the object (I mentioned in my initial post the link to the
query type Elasticsearch Platform — Find real-time answers at scale | Elastic**
fields.htmlhttp://www.elasticsearch.org/guide/reference/api/search/fields.html
):

SearchRequestBuilder requestBuilder = client.prepareSearch....

requestBuilder.addFields("field1", "field5.subField2", "field7")

Now, I want to build my objects from the response.

SearchHits hitsInfo = response.getHits()

SearchHit hits = hitsInfo.hits()
for (SearchHit hit : hits) {
// here, hit.getSourceAsString() returns null

Map<String, SearchHitField> fields = hit.fields()
MyFullObject obj =  decodeMyFullObject(hit)
}
So, my MyFullObject must be populated with that fields (that represent a
part of all MyFullObject fields) returned by the response.

Thanks,
Mihai

--
You received this message because you are subscribed to the Google Groups
"elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to elasticsearch+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

--
You received this message because you are subscribed to a topic in the
Google Groups "elasticsearch" group.
To unsubscribe from this topic, visit
https://groups.google.com/d/topic/elasticsearch/_a7NW4eZnEE/unsubscribe?hl=en-US
.
To unsubscribe from this group and all its topics, send an email to
elasticsearch+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

--
Mihai Cazacu
Software Engineer
E-mail: cazacugmihai@gmail.com
Mobile: +40 745 254 657
Skype: cazacugmihai
Twitter: cazacugmihai

--
You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

Topic		Replies	Views
How to Parse Response from Elastic Search to Java Objects (Map)? Elasticsearch	1	1951	July 6, 2017
Dynamic doc Mapping Elasticsearch	2	263	July 6, 2017
Field Mapping Elasticsearch	2	335	July 6, 2017
Map fields to String Elasticsearch	2	333	July 6, 2017
New Java API Client GetResponse Elasticsearch language-clients	9	808	September 5, 2023

Response mapping

HTH

Related topics