Combine multiple documents into one document I have a few documents, for example, 3 documents Document - 1 { ... test: "a" ... } Document - 2 { ... test: "b" ... } Document - 3 { ... test: "c" ... } ===============Output I am looking for ============== Document - { ... test…

You will need to do that in your application. You can not format results like that in Elasticsearch.

Thank you, Christian for the reply. I need some information. As per my understating, This can not be achieved using the KQL, DSL directly. This has to be done using the java rest API

You need to have a custom step to post process the response. It can as far as I know not be done in Kibana.

I got it. Thank you, Christian, for your quick reply.

You can use a transform for it. The group_by must be based on a common criteria, e.g. a common id. For the combining step, you can use a scripted metric, e.g.: "all_docs": { "scripted_metric": { "init_script": "state.docs = []", "map_script": "state.docs.add(new HashMap(params['_source']…

I am not aware of another solution and I think the painless solution should perform well. Painless is compiled into java byte code and therefore comparable in terms of speed with a pure java implementation. The only real downside I see is ease of use.

Combine multiple document into one document with limited Fields ( merging of documents )

Elastic Stack Elasticsearch

ramakrushna.sahu (rama krushna sahu) May 18, 2020, 5:54pm 7

Thank you for the information. We are able to achieve using Painless script. is there any other way as well?

Topic		Replies	Views
Merge fields between documents Elasticsearch eql-elastic-query-language	3	716	May 27, 2022
How to merge two document in logstash Logstash	2	1969	June 11, 2020
Merge search results into single document? Elasticsearch	3	556	September 20, 2019
Combining two documents within the same index Elasticsearch	3	680	November 1, 2019
Merging documents based on matched fields values Elasticsearch	2	6554	October 22, 2020

Combine multiple document into one document with limited Fields ( merging of documents )

Related topics