If you want to fix routing value, then you have to send all children to the same shard than parent. So use the same _routing parameter for all documents.
If you set for parent a custom routing value, then you have to set the same one for all children.
Hi David,
Although I am not sure but it seems that the issue is due to routing value. Just keeping 1 shard and got my query partially running.
The complete list of commands to reproduce the issue are:
//create schema definition
curl -XPOST http://localhost:9200/ads -d@campaign_adgrp_schema.json
//load data
curl -XPOST http://localhost:9200/_bulk?pretty --data-binary @./fedexadgroupcampaign.txt
curl -XPOST http://localhost:9200/_bulk?pretty --data-binary @./0_comcat.txt
//search in these queries the explain shows that match for kwtargeting is not working. the query needs to be fixed
curl -XPOST "http://localhost:9200/ads/ad/_search?pretty&explain" -d@./distance-filter-query-parent-6.json
curl -XPOST "http://localhost:9200/ads/ad/_search?pretty&explain" -d@./distance-filter-query-parent-7.json
Looking forward to hear from you soon.
Regards,
Deep
On Sunday, 26 May 2013 17:43:56 UTC+5:30, David Pilato wrote:
Did you read the help page?
Please gist a full curl recreation (something we can easily replay from scratch) and we will be happy to help.
--
David
Twitter : @dadoonet / @elasticsearchfr / @scrutmydocs
Le 26 mai 2013 à 13:51, Deep ishwa...@gmail.com a écrit :
Hi David,
Thank you for your response.
I read thru the explain api documentation but it does not seem to help if the query does not return any results.
If you could help me with the query it would be highly appreciated.
I have attached my schema , dummy data and query file. I want to return all ads for which the in the parent all the targeting parameters in the parent adgroup are met (adgroup must be active, keyword must exist in kwtargetting and the publisher budget must be > 0 for a publisher).
Thanks
On Sunday, 26 May 2013 14:23:33 UTC+5:30, David Pilato wrote:
You can use explain API: Elasticsearch Platform — Find real-time answers at scale | Elastic
Or ask here for advices. See Elasticsearch Platform — Find real-time answers at scale | Elastic
--
David
Twitter : @dadoonet / @elasticsearchfr / @scrutmydocs
Le 26 mai 2013 à 10:00, Deep ishwa...@gmail.com a écrit :
Hi ,
I need help to debug my query in Elasticsearch. I have a parent / child relationship. My query is not returning any results. How can I debug issue the issue?
Regards,
--
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 elasticsearc...@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 elasticsearc...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
<campaign_adgrp_schema.json>
<distance-filter-query-parent-6.json>
--
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.
<fedexadgroupcampaign.txt><distance-filter-query-parent-6.json><distance-filter-query-parent-7.json><campaign_adgrp_schema.json><0_comcast.txt>