Hi,I have tried the solution from your blog with my schema and with the example from the blog post, with solr-5.3.0 and with solr-5.4. 0-2015-08-12 and i get this error:
"responseHeader":{
"status":500,
"QTime":32},
"error":{
"msg":"child query must only match non-parent docs, but parent docID=2 matched
childScorer=class org.apache.lucene.search.DisjunctionSumScorer",
"trace":"java.lang.IllegalStateException: child query must only match non-parent
docs, but parent docID=2 matched childScorer=class
org.apache.lucene.search.DisjunctionSumScorer\n\tat
org.apache.lucene.search.join.ToParentBlockJoinQuery$BlockJoinScorer.nextDoc(ToParentBlockJoinQuery.java:311)\n\tat
org.apache.lucene.search.Weight$DefaultBulkScorer.scoreAll(Weight.java:216)\n\tat
org.apache.lucene.search.Weight$DefaultBulkScorer.score(Weight.java:169)\n\tat
org.apache.lucene.search.BulkScorer.score(BulkScorer.java:39)\n\tat
org.apache.lucene.search.IndexSearcher.search(IndexSearcher.java:772)\n\tat
org.apache.lucene.search.IndexSearcher.search(IndexSearcher.java:486)\n\tat
org.apache.solr.search.SolrIndexSearcher.buildAndRunCollectorChain(SolrIndexSearcher.java:200)\n\tat
org.apache.solr.search.SolrIndexSearcher.getDocListNC(SolrIndexSearcher.java:1682)\n\tat
org.apache.solr.search.SolrIndexSearcher.getDocListC(SolrIndexSearcher.java:1501)\n\tat
org.apache.solr.search.SolrIndexSearcher.search(SolrIndexSearcher.java:555)\n\tat
org.apache.solr.handler.component.QueryComponent.process(QueryComponent.java:522)\n\tat
org.apache.solr.handler.component.SearchHandler.handleRequestBody(SearchHandler.java:277)\n\tat
org.apache.solr.handler.RequestHandlerBase.handleRequest(RequestHandlerBase.java:143)\n\tat
org.apache.solr.core.SolrCore.execute(SolrCore.java:2068)\n\tat
org.apache.solr.servlet.HttpSolrCall.execute(HttpSolrCall.java:669)\n\tat
org.apache.solr.servlet.HttpSolrCall.call(HttpSolrCall.java:462)\n\tat
org.apache.solr.servlet.SolrDispatchFilter.doFilter(SolrDispatchFilter.java:210)\n\tat
org.apache.solr.servlet.SolrDispatchFilter.doFilter(SolrDispatchFilter.java:179)\n\tat
org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1652)\n\tat
org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:585)\n\tat
org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:143)\n\tat
org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:577)\n\tat
org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:223)\n\tat
org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1127)\n\tat
org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:515)\n\tat
org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:185)\n\tat
org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1061)\n\tat
org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141)\n\tat
org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:215)\n\tat
org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:110)\n\tat
org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:97)\n\tat
org.eclipse.jetty.server.Server.handle(Server.java:499)\n\tat
org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:310)\n\tat
org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:257)\n\tat
org.eclipse.jetty.io.AbstractConnection$2.run(AbstractConnection.java:540)\n\tat
org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:635)\n\tat
org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:555)\n\tat
java.lang.Thread.run(Thread.java:745)\n",
"code":500}
The query is for your example
http://localhost:8983/solr/testscore/select?q={!parent%20which=type_s:product%20score=max}+color_s:Red^=0%20{!func}price_i&wt=json&indent=true&fl=score,*,[docid]
Do you have any idea why i get this error?
Thank you
On 31.08.2015 15:48, Mikhail Khludnev wrote:
Florin, I disclosure some details in the recent post http://blog.griddynamics.com/2015/08/scoring-join-party-in-solr-53.html. Let me know if you have further questions afterwards. I also notice that you use "obvious" syntax: BuyerID=83 but it's hardly ever possible. There is a good habit of debugQuery=true, which allows to reconcile query interpretation. On Mon, Aug 31, 2015 at 2:40 PM, Florin Mandoc <flori...@mejix.com> wrote:Hi, I am trying to model am index from a relational database and i have 3 main entity types: products, buyers and sellers. I am using nested documents for sellers and buyers, as i have many sellers and many buyers for one product: { "Active" : "true", "CategoryID" : 59, "CategoryName" : "Produce", "Id" : "227686", "ManufacturerID" : 322, "ManufacturerName" : "-------", "Name" : "product name", "ProductID" : "227686", "SKU" : "DAFA2A1F047E438B8462667F987D80A5", "ShortDescription" : "s description", "type" : "product", "UOM" : "Unit", "UomSize" : "48", "_childDocuments_" : [ { "BuyerID" : 83, "DisplayOrder" : 0, "ProductID" : "227686", "id" : "227686_83", "type" : "buyer" }, { "BuyerID" : 86, "DisplayOrder" : 10, "ProductID" : "227686", "id" : "227686_86", "type" : "buyer" }, { "BuyerID" : 83, "ProductID" : "227686", "SellerID" : 84, "SellerName" : "Seller 84", "id" : "227686_83_84", "type" : "seller" }, { "BuyerID" : 83, "ProductID" : "227686", "SellerID" : 89, "SellerName" : "Seller 89", "id" : "227686_83_89", "type" : "seller" } ], "_version_" : 1509403723402575872 } To query i use: http://localhost:8983/solr/dine/select?q=Name:"product name"&fq={!parent%20which=type:product v="type:buyer AND BuyerID=83"}&wt=json&indent=true&fl=*,[child%20parentFilter=type:product%20childFilter=%22((type:buyer%20AND%20BuyerSiteID:83)%20OR%20(type:seller%20AND%20BuyerSiteID:83))]&rows=1000 and i get the product, buyer and sellers details, but i want to have the products of BuyerID:83 sorted by DisplayOrder field. Is this possible to achieve this, and how? Thank you
