I suspect URL encoding might mess with MUST (+) clause. Can you post debugQuery=true output to make sure that the query parsed right. Then make sure that chid query and parent filter are fully orthogonal. eg +type_s:product +color_s:Red returns no result. Last check to check, make sure that you don't have deleted document in the index for a while. You can check in at SolrAdmin.
On Tue, Sep 1, 2015 at 1:42 PM, Florin Mandoc <flori...@mejix.com> wrote: > 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 > <http://localhost:8983/solr/testscore/select?q=%7B!parent%20which=type_s:product%20score=max%7D+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 >>> >>> >> >> > -- Sincerely yours Mikhail Khludnev Principal Engineer, Grid Dynamics <http://www.griddynamics.com> <mkhlud...@griddynamics.com>