Using ES query in Spring Boot

dadoonet · March 2, 2018, 3:40pm

We have to translate this complex and big query to JavaAPI. Which is the best way to accomplish this?

Start with the first filter and then add aggregations and subaggregations to it?

Start with the deepest subaggregation and then wrapp it in the upper level?

The former. Note that if you use the High Level Rest Client, it exposes lot of helpers to build that from Java.

I have a project example here:

github.com

dadoonet/legacy-search/blob/05-compute/src/main/java/fr/pilato/demo/legacysearch/dao/ElasticsearchDao.java#L100-L122


      
                  esClient.indices().create(cir -> cir
                          .index("person")
                          .withJson(ElasticsearchDao.class.getResourceAsStream("/person.json"))
                  );
                  logger.info("New index person has been created");
              } catch (ElasticsearchException e) {
                  if (e.status() != 400) {
                      logger.warn("can not create index and mappings", e);
                  } else {
                      logger.debug("Index person was already existing. Skipping creating it again.");
                  }
              }
          }
          
          public void saveAll(Iterable<Person> persons) throws IOException {
              esClient.bulk(br -> {
                  br.index("person");
                  persons.forEach(person -> br.operations(ops -> ops.index(i -> i.document(person))));
                  return br;
              });

This file has been truncated. show original

You can read more about this example here: https://david.pilato.fr/blog/2015-05-09-advanced-search-for-your-legacy-application/

As you can see, JSON response does not have anything to do with document saved. We have no idea how to return this data to Java.

Is it better to return plain JSON and work with it in Angular?

If you don't need to do special transformations with your data but just display the result on a page, indeed sending the JSON response as is back to the front end is the easiest way IMO.

Is it possible to create a complex POJO and marshall ES JSON to that POJO?

You can use Jackson for that.

Topic		Replies	Views
Deserializing Query DSL to Java objects Elasticsearch	2	638	June 1, 2020
JSON Query via REST from Java client Elasticsearch	5	3657	August 23, 2017
QueryParser for Java Elasticsearch	1	298	July 6, 2017
QueryParser for Java Elasticsearch	1	459	July 6, 2017
How to search with only raw query JSON with ES Java API? Elasticsearch	2	4507	July 6, 2017

Using ES query in Spring Boot

Related topics