# Is it possible to combine some MultiSearchResponse to one SearchResponse? **URL:** \ **Category:** Elasticsearch\ **Created:** [July 18, 2012, 4:14pm UTC](https://discuss.elastic.co/t/is-it-possible-to-combine-some-multisearchresponse-to-one-searchresponse/8449 "2012-07-18T16:14:09Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![Yang](https://avatars.discourse-cdn.com/v4/letter/y/77aa72/32.png) [@Yang](https://discuss.elastic.co/u/Yang)\ **Post date:** [July 18, 2012, 4:14pm UTC](https://discuss.elastic.co/t/is-it-possible-to-combine-some-multisearchresponse-to-one-searchresponse/8449/1 "2012-07-18T16:14:09Z")
Dear all, I met a ver special use case, here is my example: I use user's name as a value of elasticsearch index, and the document type as a value of elasticsearch type, here we go: index: john type: email the example above means, here is a user who is John, and we store all his emails under type _email_. For easily understand, I would say there is only one field in document which is _subject_. Then, my data structure may like this: index: john type: email documents: \_id:1, subject:BB11, create\_date: 2012-05-01 \_id:2, subject:BBAA, create\_date: 2012-02-18 \_id:3, subject:BB12, create\_date: 2012-06-07 \_id:4, subject:CC11, create\_date: 2012-01-05 Then, another user came here with his data: index: harry type: essay documents: \_id:a, title: AACC, create\_date: 2012-03-08 \_id:b, title: BBCC, create\_date: 2012-07-01 \_id:c, title: DD11, create\_date: 2012-01-16 \_id:d, title: BB11, create\_date: 2012-02-01 I rise 2 search requests for John and Harry separately like: SearchResponse searchResponseForJohn = getSearchRequestBuilder().index("\* john\*").type("_email_").query(generateQuery("_bb_")).execute().actionGet(); //3 records are returned: \_id=1, 2, 3 SearchResponse searchResponseForHarry = getSearchRequestBuilder().index("\* harry\*").type("_essay_").query(generateQuery("_cc_")).execute().actionGet(); //2 records are returned: \_id=a, b After I got the two searchResponse, I wanted to display these 5 records in one page, but I cannot order these 5 records by _create\_date_, because they are in two search responses. You may say that I could write my code like this: SearchResponse searchResponseForJohnAndHarry = getSearchRequestBuilder().index(" _john_", "_harry_").type("_email_", "_essay_").query(generateQuery("_bb or cc_")).execute().actionGet(); //but 7 records are returned: \_id=1, 2, 3, b, d, 4, a, b See, the result is not what I want. Then I found a function "_Multi Search_", but after I gave a quick try, it seems it's the same as I send 2 separate search request. I got an MultiSearchResponse with two search response in it. For some other reasons, I do have to send 2 search request, no matter request one by one or using _MultiSearchRequest_. I'm wondering, is there a way that I can combine all the search result records and make them ordered by _create\_date_? At last, THANK YOU VERY MUCH for reading all my boring content, I APPRECIATE~ best, -- YANG. ---
**Author:** ![kimchy](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/kimchy/32/44952_2.png) [@kimchy](https://discuss.elastic.co/u/kimchy)\ **Post date:** [July 18, 2012, 8:39pm UTC](https://discuss.elastic.co/t/is-it-possible-to-combine-some-multisearchresponse-to-one-searchresponse/8449/2 "2012-07-18T20:39:41Z")
If you want order between the two search responses, then it needs to be a single search request. The mulit search API simply executes several search requests and each one has its own search response. On Wed, Jul 18, 2012 at 9:14 AM, Yang [yuyang030405@gmail.com](mailto:yuyang030405@gmail.com) wrote: > Dear all, > > I met a ver special use case, here is my example: > > I use user's name as a value of elasticsearch index, and the document type > as a value of elasticsearch type, here we go: > > index: john > > type: email > > the example above means, here is a user who is John, and we store all his > emails under type _email_. For easily understand, I would say there is > only one field in document which is _subject_. Then, my data structure > may like this: > > index: john > > type: email > > documents: > > \_id:1, subject:BB11, create\_date: 2012-05-01 > > \_id:2, subject:BBAA, create\_date: 2012-02-18 > > \_id:3, subject:BB12, create\_date: 2012-06-07 > > \_id:4, subject:CC11, create\_date: 2012-01-05 > > Then, another user came here with his data: > > index: harry > > type: essay > > documents: > > \_id:a, title: AACC, create\_date: 2012-03-08 > > \_id:b, title: BBCC, create\_date: 2012-07-01 > > \_id:c, title: DD11, create\_date: 2012-01-16 > > \_id:d, title: BB11, create\_date: 2012-02-01 > > I rise 2 search requests for John and Harry separately like: > > SearchResponse searchResponseForJohn = getSearchRequestBuilder().index("\* > john\*").type("_email_").query(generateQuery("_bb_")).execute().actionGet(); > //3 records are returned: \_id=1, 2, 3 > > SearchResponse searchResponseForHarry = getSearchRequestBuilder().index("\* > harry\*").type("_essay_").query(generateQuery("_cc_")).execute().actionGet(); > //2 records are returned: \_id=a, b > > After I got the two searchResponse, I wanted to display these 5 records in > one page, but I cannot order these 5 records by _create\_date_, because > they are in two search responses. You may say that I could write my code > like this: > > SearchResponse searchResponseForJohnAndHarry = > getSearchRequestBuilder().index(" > _john_", "_harry_").type("_email_", "_essay_").query(generateQuery("_bb > or cc_")).execute().actionGet(); //but 7 records are returned: \_id=1, 2, > 3, b, d, 4, a, b > > See, the result is not what I want. Then I found a function "\*Multi Search > \*", but after I gave a quick try, it seems it's the same as I send 2 > separate search request. I got an MultiSearchResponse with two search > response in it. > > For some other reasons, I do have to send 2 search request, no matter > request one by one or using _MultiSearchRequest_. I'm wondering, is there > a way that I can combine all the search result records and make them > ordered by _create\_date_? > > At last, THANK YOU VERY MUCH for reading all my boring content, I > APPRECIATE~ > > best, > > -- > YANG. ---
**Author:** ![Yang](https://avatars.discourse-cdn.com/v4/letter/y/77aa72/32.png) [@Yang](https://discuss.elastic.co/u/Yang)\ **Post date:** [July 19, 2012, 3:54am UTC](https://discuss.elastic.co/t/is-it-possible-to-combine-some-multisearchresponse-to-one-searchresponse/8449/3 "2012-07-19T03:54:17Z")
So I assume no matter I use "Multi Search Request" or not, there is no way to satisfy the requirement I mentioned above, right? If it is, I may need to focus on other things. On Thursday, July 19, 2012 4:39:41 AM UTC+8, kimchy wrote: > If you want order between the two search responses, then it needs to be a > single search request. The mulit search API simply executes several search > requests and each one has its own search response. > > On Wed, Jul 18, 2012 at 9:14 AM, Yang [yuyang030405@gmail.com](mailto:yuyang030405@gmail.com) wrote: > > > Dear all, > > > > I met a ver special use case, here is my example: > > > > I use user's name as a value of elasticsearch index, and the document > > type as a value of elasticsearch type, here we go: > > > > index: john > > > > type: email > > > > the example above means, here is a user who is John, and we store all his > > emails under type _email_. For easily understand, I would say there is > > only one field in document which is _subject_. Then, my data structure > > may like this: > > > > index: john > > > > type: email > > > > documents: > > > > \_id:1, subject:BB11, create\_date: 2012-05-01 > > > > \_id:2, subject:BBAA, create\_date: 2012-02-18 > > > > \_id:3, subject:BB12, create\_date: 2012-06-07 > > > > \_id:4, subject:CC11, create\_date: 2012-01-05 > > > > Then, another user came here with his data: > > > > index: harry > > > > type: essay > > > > documents: > > > > \_id:a, title: AACC, create\_date: 2012-03-08 > > > > \_id:b, title: BBCC, create\_date: 2012-07-01 > > > > \_id:c, title: DD11, create\_date: 2012-01-16 > > > > \_id:d, title: BB11, create\_date: 2012-02-01 > > > > I rise 2 search requests for John and Harry separately like: > > > > SearchResponse searchResponseForJohn = getSearchRequestBuilder().index("\* > > john\*").type("_email_").query(generateQuery("_bb_")).execute().actionGet(); > > //3 records are returned: \_id=1, 2, 3 > > > > SearchResponse searchResponseForHarry = getSearchRequestBuilder().index(" > > _harry_").type("_essay_").query(generateQuery("_cc_")).execute().actionGet(); > > //2 records are returned: \_id=a, b > > > > After I got the two searchResponse, I wanted to display these 5 records > > in one page, but I cannot order these 5 records by _create\_date_, > > because they are in two search responses. You may say that I could write my > > code like this: > > > > SearchResponse searchResponseForJohnAndHarry = > > getSearchRequestBuilder().index(" > > _john_", "_harry_").type("_email_", "_essay_").query(generateQuery("_bb > > or cc_")).execute().actionGet(); //but 7 records are returned: \_id=1, 2, > > 3, b, d, 4, a, b > > > > See, the result is not what I want. Then I found a function "_Multi > > Search_", but after I gave a quick try, it seems it's the same as I send > > 2 separate search request. I got an MultiSearchResponse with two search > > response in it. > > > > For some other reasons, I do have to send 2 search request, no matter > > request one by one or using _MultiSearchRequest_. I'm wondering, is > > there a way that I can combine all the search result records and make them > > ordered by _create\_date_? > > > > At last, THANK YOU VERY MUCH for reading all my boring content, I > > APPRECIATE~ > > > > best, > > > > -- > > YANG. ---
**Author:** ![Igor\_Motov](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/igor_motov/32/45193_2.png) [@Igor\_Motov](https://discuss.elastic.co/u/Igor_Motov)\ **Post date:** [July 20, 2012, 8:00pm UTC](https://discuss.elastic.co/t/is-it-possible-to-combine-some-multisearchresponse-to-one-searchresponse/8449/4 "2012-07-20T20:00:56Z")
I think you can achieve this by combining several "indices queries[http://www.elasticsearch.org/guide/reference/query-dsl/indices-query.html](http://www.elasticsearch.org/guide/reference/query-dsl/indices-query.html)" into a single bool query: [gist:927ce430436ad48dd863 · GitHub](https://gist.github.com/927ce430436ad48dd863) On Wednesday, July 18, 2012 11:54:17 PM UTC-4, Yang wrote: > So I assume no matter I use "Multi Search Request" or not, there is no way > to satisfy the requirement I mentioned above, right? > > If it is, I may need to focus on other things. > > On Thursday, July 19, 2012 4:39:41 AM UTC+8, kimchy wrote: > > > If you want order between the two search responses, then it needs to be a > > single search request. The mulit search API simply executes several search > > requests and each one has its own search response. > > > > On Wed, Jul 18, 2012 at 9:14 AM, Yang [yuyang030405@gmail.com](mailto:yuyang030405@gmail.com) wrote: > > > > > Dear all, > > > > > > I met a ver special use case, here is my example: > > > > > > I use user's name as a value of elasticsearch index, and the document > > > type as a value of elasticsearch type, here we go: > > > > > > index: john > > > > > > type: email > > > > > > the example above means, here is a user who is John, and we store all > > > his emails under type _email_. For easily understand, I would say there > > > is only one field in document which is _subject_. Then, my data > > > structure may like this: > > > > > > index: john > > > > > > type: email > > > > > > documents: > > > > > > \_id:1, subject:BB11, create\_date: 2012-05-01 > > > > > > \_id:2, subject:BBAA, create\_date: 2012-02-18 > > > > > > \_id:3, subject:BB12, create\_date: 2012-06-07 > > > > > > \_id:4, subject:CC11, create\_date: 2012-01-05 > > > > > > Then, another user came here with his data: > > > > > > index: harry > > > > > > type: essay > > > > > > documents: > > > > > > \_id:a, title: AACC, create\_date: 2012-03-08 > > > > > > \_id:b, title: BBCC, create\_date: 2012-07-01 > > > > > > \_id:c, title: DD11, create\_date: 2012-01-16 > > > > > > \_id:d, title: BB11, create\_date: 2012-02-01 > > > > > > I rise 2 search requests for John and Harry separately like: > > > > > > SearchResponse searchResponseForJohn = getSearchRequestBuilder().index(" > > > _john_").type("_email_").query(generateQuery("_bb_")).execute().actionGet(); > > > //3 records are returned: \_id=1, 2, 3 > > > > > > SearchResponse searchResponseForHarry = getSearchRequestBuilder().index(" > > > _harry_").type("_essay_").query(generateQuery("_cc_")).execute().actionGet(); > > > //2 records are returned: \_id=a, b > > > > > > After I got the two searchResponse, I wanted to display these 5 records > > > in one page, but I cannot order these 5 records by _create\_date_, > > > because they are in two search responses. You may say that I could write my > > > code like this: > > > > > > SearchResponse searchResponseForJohnAndHarry = > > > getSearchRequestBuilder().index(" > > > _john_", "_harry_").type("_email_", "_essay_").query(generateQuery("_bb > > > or cc_")).execute().actionGet(); //but 7 records are returned: \_id=1, > > > 2, 3, b, d, 4, a, b > > > > > > See, the result is not what I want. Then I found a function "_Multi > > > Search_", but after I gave a quick try, it seems it's the same as I > > > send 2 separate search request. I got an MultiSearchResponse with two > > > search response in it. > > > > > > For some other reasons, I do have to send 2 search request, no matter > > > request one by one or using _MultiSearchRequest_. I'm wondering, is > > > there a way that I can combine all the search result records and make them > > > ordered by _create\_date_? > > > > > > At last, THANK YOU VERY MUCH for reading all my boring content, I > > > APPRECIATE~ > > > > > > best, > > > > > > -- > > > YANG. ---
**Author:** ![Yang](https://avatars.discourse-cdn.com/v4/letter/y/77aa72/32.png) [@Yang](https://discuss.elastic.co/u/Yang)\ **Post date:** [July 24, 2012, 2:49pm UTC](https://discuss.elastic.co/t/is-it-possible-to-combine-some-multisearchresponse-to-one-searchresponse/8449/5 "2012-07-24T14:49:48Z")
Dear Motov, I cannot say more thanks to you, it's really a great idea. I'll make it work in my code and let you and other guys know the solution who meet the same problem that I met. Again, thanks very much~ best, On Saturday, July 21, 2012 4:00:56 AM UTC+8, Igor Motov wrote: > I think you can achieve this by combining several "indices queries[http://www.elasticsearch.org/guide/reference/query-dsl/indices-query.html](http://www.elasticsearch.org/guide/reference/query-dsl/indices-query.html)" > into a single bool query: [gist:927ce430436ad48dd863 · GitHub](https://gist.github.com/927ce430436ad48dd863) > > On Wednesday, July 18, 2012 11:54:17 PM UTC-4, Yang wrote: > > > So I assume no matter I use "Multi Search Request" or not, there is no > > way to satisfy the requirement I mentioned above, right? > > > > If it is, I may need to focus on other things. > > > > On Thursday, July 19, 2012 4:39:41 AM UTC+8, kimchy wrote: > > > > > If you want order between the two search responses, then it needs to be > > > a single search request. The mulit search API simply executes several > > > search requests and each one has its own search response. > > > > > > On Wed, Jul 18, 2012 at 9:14 AM, Yang [yuyang030405@gmail.com](mailto:yuyang030405@gmail.com) wrote: > > > > > > > Dear all, > > > > > > > > I met a ver special use case, here is my example: > > > > > > > > I use user's name as a value of elasticsearch index, and the document > > > > type as a value of elasticsearch type, here we go: > > > > > > > > index: john > > > > > > > > type: email > > > > > > > > the example above means, here is a user who is John, and we store all > > > > his emails under type _email_. For easily understand, I would say > > > > there is only one field in document which is _subject_. Then, my data > > > > structure may like this: > > > > > > > > index: john > > > > > > > > type: email > > > > > > > > documents: > > > > > > > > \_id:1, subject:BB11, create\_date: 2012-05-01 > > > > > > > > \_id:2, subject:BBAA, create\_date: 2012-02-18 > > > > > > > > \_id:3, subject:BB12, create\_date: 2012-06-07 > > > > > > > > \_id:4, subject:CC11, create\_date: 2012-01-05 > > > > > > > > Then, another user came here with his data: > > > > > > > > index: harry > > > > > > > > type: essay > > > > > > > > documents: > > > > > > > > \_id:a, title: AACC, create\_date: 2012-03-08 > > > > > > > > \_id:b, title: BBCC, create\_date: 2012-07-01 > > > > > > > > \_id:c, title: DD11, create\_date: 2012-01-16 > > > > > > > > \_id:d, title: BB11, create\_date: 2012-02-01 > > > > > > > > I rise 2 search requests for John and Harry separately like: > > > > > > > > SearchResponse searchResponseForJohn = getSearchRequestBuilder().index(" > > > > _john_").type("_email_").query(generateQuery("_bb_")).execute().actionGet(); > > > > //3 records are returned: \_id=1, 2, 3 > > > > > > > > SearchResponse searchResponseForHarry = > > > > getSearchRequestBuilder().index("_harry_").type("_essay_ > > > > ").query(generateQuery("_cc_")).execute().actionGet(); //2 records are > > > > returned: \_id=a, b > > > > > > > > After I got the two searchResponse, I wanted to display these 5 records > > > > in one page, but I cannot order these 5 records by _create\_date_, > > > > because they are in two search responses. You may say that I could write my > > > > code like this: > > > > > > > > SearchResponse searchResponseForJohnAndHarry = > > > > getSearchRequestBuilder().index(" > > > > _john_", "_harry_").type("_email_", "_essay_").query(generateQuery("_bb > > > > or cc_")).execute().actionGet(); //but 7 records are returned: \_id=1, > > > > 2, 3, b, d, 4, a, b > > > > > > > > See, the result is not what I want. Then I found a function "_Multi > > > > Search_", but after I gave a quick try, it seems it's the same as I > > > > send 2 separate search request. I got an MultiSearchResponse with two > > > > search response in it. > > > > > > > > For some other reasons, I do have to send 2 search request, no matter > > > > request one by one or using _MultiSearchRequest_. I'm wondering, is > > > > there a way that I can combine all the search result records and make them > > > > ordered by _create\_date_? > > > > > > > > At last, THANK YOU VERY MUCH for reading all my boring content, I > > > > APPRECIATE~ > > > > > > > > best, > > > > > > > > -- > > > > YANG. ---
**Author:** ![phill](https://avatars.discourse-cdn.com/v4/letter/p/779978/32.png) [@phill](https://discuss.elastic.co/u/phill)\ **Post date:** [March 7, 2013, 8:47am UTC](https://discuss.elastic.co/t/is-it-possible-to-combine-some-multisearchresponse-to-one-searchresponse/8449/6 "2013-03-07T08:47:34Z")
Several things here. You can issue _one_ search across multiple indices. I would not put each person's e-mails in a separate index. I would have an index of all e-mails with a field for the owner of an e-mail. There are also parent and child relationships that can be established between two types in the same index, but nothing you said suggests you need that yet. -Paul On 3/4/2013 12:25 PM, eric sanford wrote: > So I assume no matter I use "Multi Search Request" or not, there is no > way to satisfy the requirement I mentioned above, right? > > If it is, I may need to focus on other things. > > On Thursday, July 19, 2012 4:39:41 AM UTC+8, kimchy wrote: > > ``` > If you want order between the two search responses, then it needs > to be a single search request. The mulit search API simply > executes several search requests and each one has its own search > response. > > On Wed, Jul 18, 2012 at 9:14 AM, Yang > wrote: > > Dear all, > > I met a ver special use case, here is my example: > > I use user's name as a value of elasticsearch index, and > the document type as a value of elasticsearch type, here > we go: > > index: john > > type: email > > the example above means, here is a user who is John, and > we store all his emails under type /email/. For easily > understand, I would say there is only one field in > document which is /subject/. Then, my data structure may > like this: > > index: john > > type: email > > documents: > > _id:1, subject:BB11, create_date: 2012-05-01 > > _id:2, subject:BBAA, create_date: 2012-02-18 > > _id:3, subject:BB12, create_date: 2012-06-07 > > _id:4, subject:CC11, create_date: 2012-01-05 > > Then, another user came here with his data: > > index: harry > > type: essay > > documents: > > _id:a, title: AACC, create_date: 2012-03-08 > > _id:b, title: BBCC, create_date: 2012-07-01 > > _id:c, title: DD11, create_date: 2012-01-16 > > _id:d, title: BB11, create_date: 2012-02-01 > > I rise 2 search requests for John and Harry separately like: > > SearchResponse searchResponseForJohn = > getSearchRequestBuilder().index("*john*").type("*email*").query(generateQuery("*bb*")).execute().actionGet(); > //3 records are returned: _id=1, 2, 3 > > SearchResponse searchResponseForHarry = > getSearchRequestBuilder().index("*harry*").type("*essay*").query(generateQuery("*cc*")).execute().actionGet(); > //2 records are returned: _id=a, b > > After I got the two searchResponse, I wanted to display > these 5 records in one page, but I cannot order these 5 > records by /create_date/, because they are in two search > responses. You may say that I could write my code like this: > > SearchResponse searchResponseForJohnAndHarry = > getSearchRequestBuilder().index(" > *john*", "*harry*").type("*email*", > "*essay*").query(generateQuery("*bb or > cc*")).execute().actionGet(); //but 7 records are > returned: _id=1, 2, 3, b, d, 4, a, b > > See, the result is not what I want. Then I found a > function "/Multi Search/", but after I gave a quick try, > it seems it's the same as I send 2 separate search > request. I got an MultiSearchResponse with two search > response in it. > > For some other reasons, I do have to send 2 search > request, no matter request one by one or using > /MultiSearchRequest/. I'm wondering, is there a way that I > can combine all the search result records and make them > ordered by /create_date/? > > At last, THANK YOU VERY MUCH for reading all my boring > content, I APPRECIATE~ > > best, > > -- > YANG. > > ``` -- 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](mailto:elasticsearch+unsubscribe@googlegroups.com). For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out). ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [July 6, 2017, 2:47am UTC](https://discuss.elastic.co/t/is-it-possible-to-combine-some-multisearchresponse-to-one-searchresponse/8449/7 "2017-07-06T02:47:51Z")