Mmmm,
In fact, if I running a json facet query the result count is 5 for both of them, this is consistent with the debug query. What I don't understand is from where these documents are. I pre-clean the colection several time with a delete query (id:*) and index always 31814269823181426982280 and 31814269823181426982281 as a children of 3181426982318142698228 Can this issue be related to SOLR-5211?. —/Yago Riveiro On Fri, Dec 11, 2015 at 8:46 PM, Mikhail Khludnev <mkhlud...@griddynamics.com> wrote: > On Fri, Dec 11, 2015 at 11:05 PM, Yago Riveiro <yago.rive...@gmail.com> > wrote: >> When do you say that I have duplicates, what do you mean? >> > I mean > http: //node-01:8983/solr/ecommerce-15_shard1_replica2/: { > QTime: "0", > ElapsedTime: "2", > RequestPurpose: "GET_TOP_IDS", > NumFound: "11", > Response: > "{responseHeader={status=0,QTime=0,params={df=_text_,distrib=false,debug=[false, > timing, track],qt=/query,fl=[id, > score],shards.purpose=4,start=0,fsv=true,shard.url= > http://node-01:8983/solr/ecommerce-15_shard1_replica2/,rid=node-01-ecommerce-15_shard1_replica2-1449842438070-0,rows=10,version=2,q=id:3181426982318142698228*,requestPurpose=GET_TOP_IDS,NOW=1449842438070,isShard=true,wt=javabin,debugQuery=false} > },response={numFound=11,start=0,maxScore=1.0,*docs=[**SolrDocument{id=**31814269823181426982280, > score=1.0}, SolrDocument{id=**31814269823181426982280, score=1.0}, > SolrDocument{id=**31814269823181426982280, score=1.0}, > SolrDocument{id=**31814269823181426982280, > score=1.0}, SolrDocument{id=**31814269823181426982280, score=1.0}, > SolrDocument{id=**31814269823181426982281, score=1.0}, > SolrDocument{id=**31814269823181426982281, > score=1.0}, SolrDocument{id=**31814269823181426982281, score=1.0}, > SolrDocument{id=**31814269823181426982281, score=1.0}, > SolrDocument{id=**31814269823181426982281, > score=1.0}]}* > ,sort_values={},debug={timing={time=0.0,prepare={time=0.0,query={time=0.0},facet={time=0.0},facet_module={time=0.0},mlt={time=0.0},highlight={time=0.0},stats={time=0.0},expand={time=0.0},debug={time=0.0}},process={time=0.0,query={time=0.0},facet={time=0.0},facet_module={time=0.0},mlt={time=0.0},highlight={time=0.0},stats={time=0.0},expand={time=0.0},debug={time=0.0}}}}}" > Perhaps, it's worth to verify shards one by one sending requests with > distrib=false. >> >> >> If I have duplicate documents is not intentional, each document must be >> unique. >> >> >> Running a query for each id: >> >> >> >> >> >> - Parent : 3181426982318142698228 >> >> - Child_1 : 31814269823181426982280 >> >> - Child_2 : 31814269823181426982281 >> >> >> >> >> The result is one document for each … >> >> >> >> >> >> responseHeader: >> { >> status: 0, >> >> >> >> QTime: 3, >> >> >> >> params: >> { >> q: "id:3181426982318142698228", >> >> >> >> fl: "id", >> >> >> >> q.op: "AND" >> >> >> >> } >> >> >> }, >> >> >> >> response: >> { >> numFound: 1, >> >> >> >> start: 0, >> >> >> >> maxScore: 11.017976, >> >> >> >> docs: >> [ >> >> { >> id: "3181426982318142698228" >> >> >> } >> >> ] >> >> >> } >> >> >> >> >> >> >> >> responseHeader: >> { >> status: 0, >> >> >> >> QTime: 3, >> >> >> >> params: >> { >> q: "id:31814269823181426982280", >> >> >> >> fl: "id", >> >> >> >> q.op: "AND" >> >> >> >> } >> >> >> }, >> >> >> >> response: >> { >> numFound: 1, >> >> >> >> start: 0, >> >> >> >> maxScore: 9.919363, >> >> >> >> docs: >> [ >> >> { >> id: "31814269823181426982280" >> >> >> } >> >> ] >> >> >> } >> >> >> >> >> >> >> responseHeader: >> { >> status: 0, >> >> >> >> QTime: 3, >> >> >> >> params: >> { >> q: "id:31814269823181426982281", >> >> >> >> fl: "id", >> >> >> >> q.op: "AND" >> >> >> >> } >> >> >> }, >> >> >> >> response: >> { >> numFound: 1, >> >> >> >> start: 0, >> >> >> >> maxScore: 9.919363, >> >> >> >> docs: >> [ >> >> { >> id: "31814269823181426982281" >> >> >> } >> >> ] >> >> >> } >> >> >> >> >> >> >> >> >> >> >> —/Yago Riveiro >> >> >> >> >> >> Ok. I got it. SolrCloud relies on uniqueKey (id) for merging shard results, >> >> but in your examples it doesn't work, because nested documents disables >> >> this. And you have duplicates, which make merge heap mad: >> >> >> false} >> >> < >> http://node-01:8983/solr/ecommerce-15_shard1_replica2/,rid=node-01-ecommerce-15_shard1_replica2-1449842438070-0,rows=10,version=2,q=id:3181426982318142698228*,requestPurpose=GET_TOP_IDS,NOW=1449842438070,isShard=true,wt=javabin,debugQuery=false%7D >> >},response={numFound=11,start=0,maxScore=1.0,docs=[SolrDocument{id=31814269823181426982280, >> >> score=1.0}, SolrDocument{id=31814269823181426982280, score=1.0}, >> >> SolrDocument{id=31814269823181426982280, score=1.0}, >> >> SolrDocument{id=31814269823181426982280, score=1.0}, >> >> SolrDocument{id=31814269823181426982280, score=1.0}, >> >> SolrDocument{id=31814269823181426982281, score=1.0}, >> >> SolrDocument{id=31814269823181426982281, score=1.0}, >> >> SolrDocument{id=31814269823181426982281, score=1.0}, >> >> SolrDocument{id=31814269823181426982281, score=1.0}, >> >> >> Yago, you encounter a quite curious fact. Congratulation! >> >> You can only retrieve parent document with SolrCloud, hence use {!parent >> >> ..}.. of fq=type:parent. >> >> >> ccing Devs: >> >> Shouldn't it prosecute ID dupes explicitly? Is it a known feature? >> >> >> >> On Fri, Dec 11, 2015 at 5:08 PM, Yago Riveiro <yago.rive...@gmail.com> >> >> wrote: >> >> >> > This: >> >> > >> >> > >> >> > >> >> > >> >> > >> >> > { >> >> > >> >> > >> >> > responseHeader: { >> >> > >> >> > >> >> > status: 0, >> >> > >> >> > >> >> > QTime: 10, >> >> > >> >> > >> >> > params: { >> >> > >> >> > >> >> > q: "id:3181426982318142698228*", >> >> > >> >> > >> >> > debugQuery: "true" >> >> > >> >> > >> >> > } >> >> > >> >> > >> >> > }, >> >> > >> >> > >> >> > response: { >> >> > >> >> > >> >> > numFound: 3, >> >> > >> >> > >> >> > start: 0, >> >> > >> >> > >> >> > maxScore: 1, >> >> > >> >> > >> >> > docs: [{ >> >> > >> >> > >> >> > id: "31814269823181426982280", >> >> > >> >> > >> >> > child_type: "ecommerce_product", >> >> > >> >> > >> >> > qty: 1, >> >> > >> >> > >> >> > product_price: 49.99 >> >> > >> >> > >> >> > }, { >> >> > >> >> > >> >> > id: "31814269823181426982281", >> >> > >> >> > >> >> > child_type: "ecommerce_product", >> >> > >> >> > >> >> > qty: 1, >> >> > >> >> > >> >> > product_price: 139.9 >> >> > >> >> > >> >> > }] >> >> > >> >> > >> >> > }, >> >> > >> >> > >> >> > debug: { >> >> > >> >> > >> >> > track: { >> >> > >> >> > >> >> > rid: >> >> > "node-01-ecommerce-15_shard1_replica2-1449842438070-0", >> >> > >> >> > >> >> > EXECUTE_QUERY: { >> >> > >> >> > >> >> > http: >> >> > //node-17:8983/solr/ecommerce-15_shard2_replica1/: { >> >> > >> >> > >> >> > QTime: "0", >> >> > >> >> > >> >> > ElapsedTime: "2", >> >> > >> >> > >> >> > RequestPurpose: "GET_TOP_IDS", >> >> > >> >> > >> >> > NumFound: "0", >> >> > >> >> > >> >> > Response: >> >> > >> "{responseHeader={status=0,QTime=0,params={df=_text_,distrib=false,debug=[false, >> >> > timing, track],qt=/query,fl=[id, >> >> > score],shards.purpose=4,start=0,fsv=true,shard.url= >> >> > >> http://node-17:8983/solr/ecommerce-15_shard2_replica1/,rid=node-01-ecommerce-15_shard1_replica2-1449842438070-0,rows=10,version=2,q=id:3181426982318142698228*,requestPurpose=GET_TOP_IDS,NOW=1449842438070,isShard=true,wt=javabin,debugQuery=false >> } >> >> > >> },response={numFound=0,start=0,maxScore=0.0,docs=[]},sort_values={},debug={timing={time=0.0,prepare={time=0.0,query={time=0.0},facet={time=0.0},facet_module={time=0.0},mlt={time=0.0},highlight={time=0.0},stats={time=0.0},expand={time=0.0},debug={time=0.0}},process={time=0.0,query={time=0.0},facet={time=0.0},facet_module={time=0.0},mlt={time=0.0},highlight={time=0.0},stats={time=0.0},expand={time=0.0},debug={time=0.0}}}}}" >> >> > >> >> > >> >> > }, >> >> > >> >> > >> >> > http: >> >> > //node-01:8983/solr/ecommerce-15_shard1_replica2/: { >> >> > >> >> > >> >> > QTime: "0", >> >> > >> >> > >> >> > ElapsedTime: "2", >> >> > >> >> > >> >> > RequestPurpose: "GET_TOP_IDS", >> >> > >> >> > >> >> > NumFound: "11", >> >> > >> >> > >> >> > Response: >> >> > >> "{responseHeader={status=0,QTime=0,params={df=_text_,distrib=false,debug=[false, >> >> > timing, track],qt=/query,fl=[id, >> >> > score],shards.purpose=4,start=0,fsv=true,shard.url= >> >> > >> http://node-01:8983/solr/ecommerce-15_shard1_replica2/,rid=node-01-ecommerce-15_shard1_replica2-1449842438070-0,rows=10,version=2,q=id:3181426982318142698228*,requestPurpose=GET_TOP_IDS,NOW=1449842438070,isShard=true,wt=javabin,debugQuery=false} >> },response={numFound=11,start=0,maxScore=1.0,docs=[SolrDocument{id=31814269823181426982280, >> >> > score=1.0}, SolrDocument{id=31814269823181426982280, score=1.0}, >> >> > SolrDocument{id=31814269823181426982280, score=1.0}, >> >> > SolrDocument{id=31814269823181426982280, score=1.0}, >> >> > SolrDocument{id=31814269823181426982280, score=1.0}, >> >> > SolrDocument{id=31814269823181426982281, score=1.0}, >> >> > SolrDocument{id=31814269823181426982281, score=1.0}, >> >> > SolrDocument{id=31814269823181426982281, score=1.0}, >> >> > SolrDocument{id=31814269823181426982281, score=1.0}, >> >> > SolrDocument{id=31814269823181426982281, >> >> > >> score=1.0}]},sort_values={},debug={timing={time=0.0,prepare={time=0.0,query={time=0.0},facet={time=0.0},facet_module={time=0.0},mlt={time=0.0},highlight={time=0.0},stats={time=0.0},expand={time=0.0},debug={time=0.0}},process={time=0.0,query={time=0.0},facet={time=0.0},facet_module={time=0.0},mlt={time=0.0},highlight={time=0.0},stats={time=0.0},expand={time=0.0},debug={time=0.0}}}}}" >> >> > >> >> > >> >> > }, >> >> > >> >> > >> >> > http: //node-14:8983/solr/ecommerce-15_shard4_replica1/: >> { >> >> > >> >> > >> >> > QTime: "0", >> >> > >> >> > >> >> > ElapsedTime: "2", >> >> > >> >> > >> >> > RequestPurpose: "GET_TOP_IDS", >> >> > >> >> > >> >> > NumFound: "0", >> >> > >> >> > >> >> > Response: >> >> > >> "{responseHeader={status=0,QTime=0,params={df=_text_,distrib=false,debug=[false, >> >> > timing, track],qt=/query,fl=[id, >> >> > score],shards.purpose=4,start=0,fsv=true,shard.url= >> >> > >> http://node-14:8983/solr/ecommerce-15_shard4_replica1/,rid=node-01-ecommerce-15_shard1_replica2-1449842438070-0,rows=10,version=2,q=id:3181426982318142698228*,requestPurpose=GET_TOP_IDS,NOW=1449842438070,isShard=true,wt=javabin,debugQuery=false >> } >> >> > >> },response={numFound=0,start=0,maxScore=0.0,docs=[]},sort_values={},debug={timing={time=0.0,prepare={time=0.0,query={time=0.0},facet={time=0.0},facet_module={time=0.0},mlt={time=0.0},highlight={time=0.0},stats={time=0.0},expand={time=0.0},debug={time=0.0}},process={time=0.0,query={time=0.0},facet={time=0.0},facet_module={time=0.0},mlt={time=0.0},highlight={time=0.0},stats={time=0.0},expand={time=0.0},debug={time=0.0}}}}}" >> >> > >> >> > >> >> > }, >> >> > >> >> > >> >> > http: //node-06:8983/solr/ecommerce-15_shard5_replica1/: { >> >> > >> >> > >> >> > QTime: "0", >> >> > >> >> > >> >> > ElapsedTime: "2", >> >> > >> >> > >> >> > RequestPurpose: "GET_TOP_IDS", >> >> > >> >> > >> >> > NumFound: "0", >> >> > >> >> > >> >> > Response: >> >> > >> "{responseHeader={status=0,QTime=0,params={df=_text_,distrib=false,debug=[false, >> >> > timing, track],qt=/query,fl=[id, >> >> > score],shards.purpose=4,start=0,fsv=true,shard.url= >> >> > >> http://node-06:8983/solr/ecommerce-15_shard5_replica1/,rid=node-01-ecommerce-15_shard1_replica2-1449842438070-0,rows=10,version=2,q=id:3181426982318142698228*,requestPurpose=GET_TOP_IDS,NOW=1449842438070,isShard=true,wt=javabin,debugQuery=false >> } >> >> > >> },response={numFound=0,start=0,maxScore=0.0,docs=[]},sort_values={},debug={timing={time=0.0,prepare={time=0.0,query={time=0.0},facet={time=0.0},facet_module={time=0.0},mlt={time=0.0},highlight={time=0.0},stats={time=0.0},expand={time=0.0},debug={time=0.0}},process={time=0.0,query={time=0.0},facet={time=0.0},facet_module={time=0.0},mlt={time=0.0},highlight={time=0.0},stats={time=0.0},expand={time=0.0},debug={time=0.0}}}}}" >> >> > >> >> > }, >> >> > >> >> > http: //node-13:8983/solr/ecommerce-15_shard3_replica1/: { >> >> > >> >> > >> >> > QTime: "0", >> >> > >> >> > >> >> > ElapsedTime: "2", >> >> > >> >> > >> >> > RequestPurpose: "GET_TOP_IDS", >> >> > >> >> > >> >> > NumFound: "0", >> >> > >> >> > >> >> > Response: >> >> > >> "{responseHeader={status=0,QTime=0,params={df=_text_,distrib=false,debug=[false, >> >> > timing, track],qt=/query,fl=[id, >> >> > score],shards.purpose=4,start=0,fsv=true,shard.url= >> >> > >> http://node-13:8983/solr/ecommerce-15_shard3_replica1/,rid=node-01-ecommerce-15_shard1_replica2-1449842438070-0,rows=10,version=2,q=id:3181426982318142698228*,requestPurpose=GET_TOP_IDS,NOW=1449842438070,isShard=true,wt=javabin,debugQuery=false >> } >> >> > >> },response={numFound=0,start=0,maxScore=0.0,docs=[]},sort_values={},debug={timing={time=0.0,prepare={time=0.0,query={time=0.0},facet={time=0.0},facet_module={time=0.0},mlt={time=0.0},highlight={time=0.0},stats={time=0.0},expand={time=0.0},debug={time=0.0}},process={time=0.0,query={time=0.0},facet={time=0.0},facet_module={time=0.0},mlt={time=0.0},highlight={time=0.0},stats={time=0.0},expand={time=0.0},debug={time=0.0}}}}}" >> >> > >> >> > }, >> >> > >> >> > http: //node-05:8983/solr/ecommerce-15_shard6_replica1/: { >> >> > >> >> > >> >> > QTime: "0", >> >> > >> >> > >> >> > ElapsedTime: "2", >> >> > >> >> > >> >> > RequestPurpose: "GET_TOP_IDS", >> >> > >> >> > >> >> > NumFound: "0", >> >> > >> >> > >> >> > Response: >> >> > >> "{responseHeader={status=0,QTime=0,params={df=_text_,distrib=false,debug=[false, >> >> > timing, track],qt=/query,fl=[id, >> >> > score],shards.purpose=4,start=0,fsv=true,shard.url= >> >> > >> http://node-05:8983/solr/ecommerce-15_shard6_replica1/,rid=node-01-ecommerce-15_shard1_replica2-1449842438070-0,rows=10,version=2,q=id:3181426982318142698228*,requestPurpose=GET_TOP_IDS,NOW=1449842438070,isShard=true,wt=javabin,debugQuery=false >> } >> >> > >> },response={numFound=0,start=0,maxScore=0.0,docs=[]},sort_values={},debug={timing={time=0.0,prepare={time=0.0,query={time=0.0},facet={time=0.0},facet_module={time=0.0},mlt={time=0.0},highlight={time=0.0},stats={time=0.0},expand={time=0.0},debug={time=0.0}},process={time=0.0,query={time=0.0},facet={time=0.0},facet_module={time=0.0},mlt={time=0.0},highlight={time=0.0},stats={time=0.0},expand={time=0.0},debug={time=0.0}}}}}" >> >> > >> >> > }, >> >> > >> >> > http: //node-04:8983/solr/ecommerce-15_shard7_replica2/: { >> >> > >> >> > >> >> > QTime: "0", >> >> > >> >> > >> >> > ElapsedTime: "2", >> >> > >> >> > >> >> > RequestPurpose: "GET_TOP_IDS", >> >> > >> >> > >> >> > NumFound: "0", >> >> > >> >> > >> >> > Response: >> >> > >> "{responseHeader={status=0,QTime=0,params={df=_text_,distrib=false,debug=[false, >> >> > timing, track],qt=/query,fl=[id, >> >> > score],shards.purpose=4,start=0,fsv=true,shard.url= >> >> > >> http://node-04:8983/solr/ecommerce-15_shard7_replica2/,rid=node-01-ecommerce-15_shard1_replica2-1449842438070-0,rows=10,version=2,q=id:3181426982318142698228*,requestPurpose=GET_TOP_IDS,NOW=1449842438070,isShard=true,wt=javabin,debugQuery=false >> } >> >> > >> },response={numFound=0,start=0,maxScore=0.0,docs=[]},sort_values={},debug={timing={time=0.0,prepare={time=0.0,query={time=0.0},facet={time=0.0},facet_module={time=0.0},mlt={time=0.0},highlight={time=0.0},stats={time=0.0},expand={time=0.0},debug={time=0.0}},process={time=0.0,query={time=0.0},facet={time=0.0},facet_module={time=0.0},mlt={time=0.0},highlight={time=0.0},stats={time=0.0},expand={time=0.0},debug={time=0.0}}}}}" >> >> > >> >> > }, >> >> > >> >> > http: //node-15:8983/solr/ecommerce-15_shard10_replica1/: { >> >> > >> >> > >> >> > QTime: "0", >> >> > >> >> > >> >> > ElapsedTime: "2", >> >> > >> >> > >> >> > RequestPurpose: "GET_TOP_IDS", >> >> > >> >> > >> >> > NumFound: "0", >> >> > >> >> > >> >> > Response: >> >> > >> "{responseHeader={status=0,QTime=0,params={df=_text_,distrib=false,debug=[false, >> >> > timing, track],qt=/query,fl=[id, >> >> > score],shards.purpose=4,start=0,fsv=true,shard.url= >> >> > >> http://node-15:8983/solr/ecommerce-15_shard10_replica1/,rid=node-01-ecommerce-15_shard1_replica2-1449842438070-0,rows=10,version=2,q=id:3181426982318142698228*,requestPurpose=GET_TOP_IDS,NOW=1449842438070,isShard=true,wt=javabin,debugQuery=false >> } >> >> > >> },response={numFound=0,start=0,maxScore=0.0,docs=[]},sort_values={},debug={timing={time=0.0,prepare={time=0.0,query={time=0.0},facet={time=0.0},facet_module={time=0.0},mlt={time=0.0},highlight={time=0.0},stats={time=0.0},expand={time=0.0},debug={time=0.0}},process={time=0.0,query={time=0.0},facet={time=0.0},facet_module={time=0.0},mlt={time=0.0},highlight={time=0.0},stats={time=0.0},expand={time=0.0},debug={time=0.0}}}}}" >> >> > >> >> > }, >> >> > >> >> > http: //node-18:8983/solr/ecommerce-15_shard11_replica1/: { >> >> > >> >> > >> >> > QTime: "0", >> >> > >> >> > >> >> > ElapsedTime: "2", >> >> > >> >> > >> >> > RequestPurpose: "GET_TOP_IDS", >> >> > >> >> > >> >> > NumFound: "0", >> >> > >> >> > >> >> > Response: >> >> > >> "{responseHeader={status=0,QTime=0,params={df=_text_,distrib=false,debug=[false, >> >> > timing, track],qt=/query,fl=[id, >> >> > score],shards.purpose=4,start=0,fsv=true,shard.url= >> >> > >> http://node-18:8983/solr/ecommerce-15_shard11_replica1/,rid=node-01-ecommerce-15_shard1_replica2-1449842438070-0,rows=10,version=2,q=id:3181426982318142698228*,requestPurpose=GET_TOP_IDS,NOW=1449842438070,isShard=true,wt=javabin,debugQuery=false >> } >> >> > >> },response={numFound=0,start=0,maxScore=0.0,docs=[]},sort_values={},debug={timing={time=0.0,prepare={time=0.0,query={time=0.0},facet={time=0.0},facet_module={time=0.0},mlt={time=0.0},highlight={time=0.0},stats={time=0.0},expand={time=0.0},debug={time=0.0}},process={time=0.0,query={time=0.0},facet={time=0.0},facet_module={time=0.0},mlt={time=0.0},highlight={time=0.0},stats={time=0.0},expand={time=0.0},debug={time=0.0}}}}}" >> >> > >> >> > }, >> >> > >> >> > http: //node-03:8983/solr/ecommerce-15_shard9_replica1/: { >> >> > >> >> > >> >> > QTime: "0", >> >> > >> >> > >> >> > ElapsedTime: "2", >> >> > >> >> > >> >> > RequestPurpose: "GET_TOP_IDS", >> >> > >> >> > >> >> > NumFound: "0", >> >> > >> >> > >> >> > Response: >> >> > >> "{responseHeader={status=0,QTime=0,params={df=_text_,distrib=false,debug=[false, >> >> > timing, track],qt=/query,fl=[id, >> >> > score],shards.purpose=4,start=0,fsv=true,shard.url= >> >> > >> http://node-03:8983/solr/ecommerce-15_shard9_replica1/,rid=node-01-ecommerce-15_shard1_replica2-1449842438070-0,rows=10,version=2,q=id:3181426982318142698228*,requestPurpose=GET_TOP_IDS,NOW=1449842438070,isShard=true,wt=javabin,debugQuery=false >> } >> >> > >> },response={numFound=0,start=0,maxScore=0.0,docs=[]},sort_values={},debug={timing={time=0.0,prepare={time=0.0,query={time=0.0},facet={time=0.0},facet_module={time=0.0},mlt={time=0.0},highlight={time=0.0},stats={time=0.0},expand={time=0.0},debug={time=0.0}},process={time=0.0,query={time=0.0},facet={time=0.0},facet_module={time=0.0},mlt={time=0.0},highlight={time=0.0},stats={time=0.0},expand={time=0.0},debug={time=0.0}}}}}" >> >> > >> >> > }, >> >> > >> >> > http: //node-02:8983/solr/ecommerce-15_shard8_replica1/: { >> >> > >> >> > >> >> > QTime: "0", >> >> > >> >> > >> >> > ElapsedTime: "2", >> >> > >> >> > >> >> > RequestPurpose: "GET_TOP_IDS", >> >> > >> >> > >> >> > NumFound: "0", >> >> > >> >> > >> >> > Response: >> >> > >> "{responseHeader={status=0,QTime=0,params={df=_text_,distrib=false,debug=[false, >> >> > timing, track],qt=/query,fl=[id, >> >> > score],shards.purpose=4,start=0,fsv=true,shard.url= >> >> > >> http://node-02:8983/solr/ecommerce-15_shard8_replica1/,rid=node-01-ecommerce-15_shard1_replica2-1449842438070-0,rows=10,version=2,q=id:3181426982318142698228*,requestPurpose=GET_TOP_IDS,NOW=1449842438070,isShard=true,wt=javabin,debugQuery=false >> } >> >> > >> },response={numFound=0,start=0,maxScore=0.0,docs=[]},sort_values={},debug={timing={time=0.0,prepare={time=0.0,query={time=0.0},facet={time=0.0},facet_module={time=0.0},mlt={time=0.0},highlight={time=0.0},stats={time=0.0},expand={time=0.0},debug={time=0.0}},process={time=0.0,query={time=0.0},facet={time=0.0},facet_module={time=0.0},mlt={time=0.0},highlight={time=0.0},stats={time=0.0},expand={time=0.0},debug={time=0.0}}}}}" >> >> > >> >> > }, >> >> > >> >> > http: //node-16:8983/solr/ecommerce-15_shard12_replica1/: { >> >> > >> >> > >> >> > QTime: "0", >> >> > >> >> > >> >> > ElapsedTime: "2", >> >> > >> >> > >> >> > RequestPurpose: "GET_TOP_IDS", >> >> > >> >> > >> >> > NumFound: "0", >> >> > >> >> > >> >> > Response: >> >> > >> "{responseHeader={status=0,QTime=0,params={df=_text_,distrib=false,debug=[false, >> >> > timing, track],qt=/query,fl=[id, >> >> > score],shards.purpose=4,start=0,fsv=true,shard.url= >> >> > >> http://node-16:8983/solr/ecommerce-15_shard12_replica1/,rid=node-01-ecommerce-15_shard1_replica2-1449842438070-0,rows=10,version=2,q=id:3181426982318142698228*,requestPurpose=GET_TOP_IDS,NOW=1449842438070,isShard=true,wt=javabin,debugQuery=false >> } >> >> > >> },response={numFound=0,start=0,maxScore=0.0,docs=[]},sort_values={},debug={timing={time=0.0,prepare={time=0.0,query={time=0.0},facet={time=0.0},facet_module={time=0.0},mlt={time=0.0},highlight={time=0.0},stats={time=0.0},expand={time=0.0},debug={time=0.0}},process={time=0.0,query={time=0.0},facet={time=0.0},facet_module={time=0.0},mlt={time=0.0},highlight={time=0.0},stats={time=0.0},expand={time=0.0},debug={time=0.0}}}}}" >> >> > >> >> > } >> >> > >> >> > }, >> >> > >> >> > GET_FIELDS: { >> >> > >> >> > >> >> > http: //node-01:8983/solr/ecommerce-15_shard1_replica2/: { >> >> > >> >> > >> >> > QTime: "3", >> >> > >> >> > >> >> > ElapsedTime: "4", >> >> > >> >> > >> >> > RequestPurpose: "GET_FIELDS,GET_DEBUG", >> >> > >> >> > >> >> > NumFound: "2", >> >> > >> >> > >> >> > Response: >> >> > >> "{responseHeader={status=0,QTime=3,params={df=_text_,distrib=false,debug=[timing, >> >> > track],qt=/query,shards.purpose=320,shard.url= >> >> > >> http://node-01:8983/solr/ecommerce-15_shard1_replica2/,rid=node-01-ecommerce-15_shard1_replica2-1449842438070-0,version=2,q=id:3181426982318142698228*,requestPurpose=GET_FIELDS,GET_DEBUG,NOW=1449842438070,ids=31814269823181426982281,31814269823181426982280,isShard=true,wt=javabin,debugQuery=true} >> },response={numFound=2,start=0,docs=[SolrDocument{id=31814269823181426982281, >> >> > child_type=ecommerce_product, ref=5545562, name=smartphone vodafone >> samsung >> >> > galaxy core prime branco, name_raw=Smartphone VODAFONE SAMSUNG Galaxy >> Core >> >> > Prime Branco, cat=vodafone, cat_raw=Vodafone, qty=1, >> product_price=139.9}, >> >> > SolrDocument{id=31814269823181426982280, child_type=ecommerce_product, >> >> > ref=5439705, name=liquidificadora moulinex faciclic glass lm310e1, >> >> > name_raw=Liquidificadora MOULINEX Faciclic Glass LM310E1, >> >> > cat=liquidificadores, cat_raw=Liquidificadores, qty=1, >> >> > >> product_price=49.99}]},debug={rawquerystring=id:3181426982318142698228*,querystring=id:3181426982318142698228*,parsedquery=id:3181426982318142698228*,parsedquery_toString=id:3181426982318142698228*,explain={31814269823181426982281= >> >> > 1.0 = id:3181426982318142698228*, product of: 1.0 = boost 1.0 = queryNorm >> >> > ,31814269823181426982280= 1.0 = id:3181426982318142698228*, product of: >> 1.0 >> >> > = boost 1.0 = queryNorm >> >> > >> },QParser=LuceneQParser,timing={time=3.0,prepare={time=0.0,query={time=0.0},facet={time=0.0},facet_module={time=0.0},mlt={time=0.0},highlight={time=0.0},stats={time=0.0},expand={time=0.0},debug={time=0.0}},process={time=3.0,query={time=0.0},facet={time=0.0},facet_module={time=0.0},mlt={time=0.0},highlight={time=0.0},stats={time=0.0},expand={time=0.0},debug={time=3.0}}}}}" >> >> > >> >> > } >> >> > >> >> > } >> >> > >> >> > }, >> >> > >> >> > timing: { >> >> > >> >> > >> >> > time: 3, >> >> > >> >> > >> >> > prepare: { >> >> > >> >> > >> >> > time: 0, >> >> > >> >> > >> >> > query: { >> >> > >> >> > >> >> > time: 0 >> >> > >> >> > >> >> > }, >> >> > >> >> > >> >> > facet: { >> >> > >> >> > >> >> > time: 0 >> >> > >> >> > >> >> > }, >> >> > >> >> > >> >> > facet_module: { >> >> > >> >> > >> >> > time: 0 >> >> > >> >> > >> >> > }, >> >> > >> >> > >> >> > mlt: { >> >> > >> >> > >> >> > time: 0 >> >> > >> >> > >> >> > }, >> >> > >> >> > >> >> > highlight: { >> >> > >> >> > >> >> > time: 0 >> >> > >> >> > >> >> > }, >> >> > >> >> > >> >> > stats: { >> >> > >> >> > >> >> > time: 0 >> >> > >> >> > >> >> > }, >> >> > >> >> > >> >> > expand: { >> >> > >> >> > >> >> > time: 0 >> >> > >> >> > >> >> > }, >> >> > >> >> > >> >> > debug: { >> >> > >> >> > >> >> > time: 0 >> >> > >> >> > >> >> > } >> >> > >> >> > >> >> > }, >> >> > >> >> > >> >> > process: { >> >> > >> >> > >> >> > time: 3, >> >> > >> >> > >> >> > query: { >> >> > >> >> > >> >> > time: 0 >> >> > >> >> > >> >> > }, >> >> > >> >> > >> >> > facet: { >> >> > >> >> > >> >> > time: 0 >> >> > >> >> > >> >> > }, >> >> > >> >> > >> >> > facet_module: { >> >> > >> >> > >> >> > time: 0 >> >> > >> >> > >> >> > }, >> >> > >> >> > >> >> > mlt: { >> >> > >> >> > >> >> > time: 0 >> >> > >> >> > >> >> > }, >> >> > >> >> > >> >> > highlight: { >> >> > >> >> > >> >> > time: 0 >> >> > >> >> > >> >> > }, >> >> > >> >> > >> >> > stats: { >> >> > >> >> > >> >> > time: 0 >> >> > >> >> > >> >> > }, >> >> > >> >> > >> >> > expand: { >> >> > >> >> > >> >> > time: 0 >> >> > >> >> > >> >> > }, >> >> > >> >> > >> >> > debug: { >> >> > >> >> > >> >> > time: 3 >> >> > >> >> > >> >> > } >> >> > >> >> > >> >> > } >> >> > >> >> > >> >> > }, >> >> > >> >> > >> >> > rawquerystring: "id:3181426982318142698228*", >> >> > >> >> > >> >> > querystring: "id:3181426982318142698228*", >> >> > >> >> > >> >> > parsedquery: "id:3181426982318142698228*", >> >> > >> >> > >> >> > parsedquery_toString: "id:3181426982318142698228*", >> >> > >> >> > >> >> > QParser: "LuceneQParser", >> >> > >> >> > >> >> > explain: { >> >> > >> >> > >> >> > 31814269823181426982280: " 1.0 = >> >> > id:3181426982318142698228*, product of: 1.0 = boost 1.0 = queryNorm ", >> >> > >> >> > >> >> > 31814269823181426982281: " 1.0 = >> >> > id:3181426982318142698228*, product of: 1.0 = boost 1.0 = queryNorm " >> >> > >> >> > >> >> > } >> >> > >> >> > } >> >> > >> >> > } >> >> > >> >> > >> >> > >> >> > >> >> > —/Yago Riveiro >> >> > >> >> > On Fri, Dec 11, 2015 at 12:53 PM, Mikhail Khludnev >> >> > <mkhlud...@griddynamics.com> wrote: >> >> > >> >> > > what do you see with debugQuery=true ? >> >> > > On Fri, Dec 11, 2015 at 2:02 PM, Yago Riveiro <yago.rive...@gmail.com> >> >> > > wrote: >> >> > >> Hi, >> >> > >> >> >> > >> I'm playing with the nested documents feature and after run this >> query: >> >> > >> >> >> > >> >> >> > >> http://localhost:8983/solr/ecommerce-15/query?q=id:3181426982318142698228* >> >> > >> >> >> > >> The documents has the IDs: >> >> > >> >> >> > >> - Parent : 3181426982318142698228 >> >> > >> - Child_1 : 31814269823181426982280 >> >> > >> - Child_2 : 31814269823181426982281 >> >> > >> >> >> > >> >> >> > >> I have this return: >> >> > >> >> >> > >> { >> >> > >> responseHeader: { >> >> > >> status: 0, >> >> > >> QTime: 3, >> >> > >> params: { >> >> > >> q: "id:3181426982318142698228*" >> >> > >> } >> >> > >> }, >> >> > >> response: { >> >> > >> numFound: 3, >> >> > >> start: 0, >> >> > >> maxScore: 1, >> >> > >> docs: [{ >> >> > >> id: "31814269823181426982280", >> >> > >> child_type: "ecommerce_product", >> >> > >> qty: 1, >> >> > >> product_price: 49.99 >> >> > >> }, { >> >> > >> id: "31814269823181426982281", >> >> > >> child_type: "ecommerce_product", >> >> > >> qty: 1, >> >> > >> product_price: 139.9 >> >> > >> }] >> >> > >> } >> >> > >> } >> >> > >> >> >> > >> As you can see the numFound is 3, and I have only 2 child documents, >> >> > it's >> >> > >> not supposed to ignore the parent document? >> >> > >> >> >> > >> >> >> > >> >> >> > >> ----- >> >> > >> Best regards >> >> > >> -- >> >> > >> View this message in context: >> >> > >> >> >> > >> http://lucene.472066.n3.nabble.com/Nested-document-query-with-wrong-numFound-value-tp4244851.html >> >> > >> Sent from the Solr - User mailing list archive at Nabble.com. >> >> > >> >> >> > > -- >> >> > > Sincerely yours >> >> > > Mikhail Khludnev >> >> > > Principal Engineer, >> >> > > Grid Dynamics >> >> > > <http://www.griddynamics.com> >> >> > > <mkhlud...@griddynamics.com> >> >> >> >> >> >> -- >> >> Sincerely yours >> >> Mikhail Khludnev >> >> Principal Engineer, >> >> Grid Dynamics >> >> >> <http://www.griddynamics.com> >> >> <mkhlud...@griddynamics.com> >> >> >> >> >> Ok. I got it. SolrCloud relies on uniqueKey (id) for merging shard results, >> >> but in your examples it doesn't work, because nested documents disables >> >> this. And you have duplicates, which make merge heap mad: >> >> >> false} >> >> < >> http://node-01:8983/solr/ecommerce-15_shard1_replica2/,rid=node-01-ecommerce-15_shard1_replica2-1449842438070-0,rows=10,version=2,q=id:3181426982318142698228*,requestPurpose=GET_TOP_IDS,NOW=1449842438070,isShard=true,wt=javabin,debugQuery=false%7D >> >},response={numFound=11,start=0,maxScore=1.0,docs=[SolrDocument{id=31814269823181426982280, >> >> score=1.0}, SolrDocument{id=31814269823181426982280, score=1.0}, >> >> SolrDocument{id=31814269823181426982280, score=1.0}, >> >> SolrDocument{id=31814269823181426982280, score=1.0}, >> >> SolrDocument{id=31814269823181426982280, score=1.0}, >> >> SolrDocument{id=31814269823181426982281, score=1.0}, >> >> SolrDocument{id=31814269823181426982281, score=1.0}, >> >> SolrDocument{id=31814269823181426982281, score=1.0}, >> >> SolrDocument{id=31814269823181426982281, score=1.0}, >> >> >> Yago, you encounter a quite curious fact. Congratulation! >> >> You can only retrieve parent document with SolrCloud, hence use {!parent >> >> ..}.. of fq=type:parent. >> >> >> ccing Devs: >> >> Shouldn't it prosecute ID dupes explicitly? Is it a known feature? >> >> >> >> On Fri, Dec 11, 2015 at 5:08 PM, Yago Riveiro <yago.rive...@gmail.com> >> >> wrote: >> >> >> > This: >> >> > >> >> > >> >> > >> >> > >> >> > >> >> > { >> >> > >> >> > >> >> > responseHeader: { >> >> > >> >> > >> >> > status: 0, >> >> > >> >> > >> >> > QTime: 10, >> >> > >> >> > >> >> > params: { >> >> > >> >> > >> >> > q: "id:3181426982318142698228*", >> >> > >> >> > >> >> > debugQuery: "true" >> >> > >> >> > >> >> > } >> >> > >> >> > >> >> > }, >> >> > >> >> > >> >> > response: { >> >> > >> >> > >> >> > numFound: 3, >> >> > >> >> > >> >> > start: 0, >> >> > >> >> > >> >> > maxScore: 1, >> >> > >> >> > >> >> > docs: [{ >> >> > >> >> > >> >> > id: "31814269823181426982280", >> >> > >> >> > >> >> > child_type: "ecommerce_product", >> >> > >> >> > >> >> > qty: 1, >> >> > >> >> > >> >> > product_price: 49.99 >> >> > >> >> > >> >> > }, { >> >> > >> >> > >> >> > id: "31814269823181426982281", >> >> > >> >> > >> >> > child_type: "ecommerce_product", >> >> > >> >> > >> >> > qty: 1, >> >> > >> >> > >> >> > product_price: 139.9 >> >> > >> >> > >> >> > }] >> >> > >> >> > >> >> > }, >> >> > >> >> > >> >> > debug: { >> >> > >> >> > >> >> > track: { >> >> > >> >> > >> >> > rid: >> >> > "node-01-ecommerce-15_shard1_replica2-1449842438070-0", >> >> > >> >> > >> >> > EXECUTE_QUERY: { >> >> > >> >> > >> >> > http: >> >> > //node-17:8983/solr/ecommerce-15_shard2_replica1/: { >> >> > >> >> > >> >> > QTime: "0", >> >> > >> >> > >> >> > ElapsedTime: "2", >> >> > >> >> > >> >> > RequestPurpose: "GET_TOP_IDS", >> >> > >> >> > >> >> > NumFound: "0", >> >> > >> >> > >> >> > Response: >> >> > >> "{responseHeader={status=0,QTime=0,params={df=_text_,distrib=false,debug=[false, >> >> > timing, track],qt=/query,fl=[id, >> >> > score],shards.purpose=4,start=0,fsv=true,shard.url= >> >> > >> http://node-17:8983/solr/ecommerce-15_shard2_replica1/,rid=node-01-ecommerce-15_shard1_replica2-1449842438070-0,rows=10,version=2,q=id:3181426982318142698228*,requestPurpose=GET_TOP_IDS,NOW=1449842438070,isShard=true,wt=javabin,debugQuery=false >> } >> >> > >> },response={numFound=0,start=0,maxScore=0.0,docs=[]},sort_values={},debug={timing={time=0.0,prepare={time=0.0,query={time=0.0},facet={time=0.0},facet_module={time=0.0},mlt={time=0.0},highlight={time=0.0},stats={time=0.0},expand={time=0.0},debug={time=0.0}},process={time=0.0,query={time=0.0},facet={time=0.0},facet_module={time=0.0},mlt={time=0.0},highlight={time=0.0},stats={time=0.0},expand={time=0.0},debug={time=0.0}}}}}" >> >> > >> >> > >> >> > }, >> >> > >> >> > >> >> > http: >> >> > //node-01:8983/solr/ecommerce-15_shard1_replica2/: { >> >> > >> >> > >> >> > QTime: "0", >> >> > >> >> > >> >> > ElapsedTime: "2", >> >> > >> >> > >> >> > RequestPurpose: "GET_TOP_IDS", >> >> > >> >> > >> >> > NumFound: "11", >> >> > >> >> > >> >> > Response: >> >> > >> "{responseHeader={status=0,QTime=0,params={df=_text_,distrib=false,debug=[false, >> >> > timing, track],qt=/query,fl=[id, >> >> > score],shards.purpose=4,start=0,fsv=true,shard.url= >> >> > >> http://node-01:8983/solr/ecommerce-15_shard1_replica2/,rid=node-01-ecommerce-15_shard1_replica2-1449842438070-0,rows=10,version=2,q=id:3181426982318142698228*,requestPurpose=GET_TOP_IDS,NOW=1449842438070,isShard=true,wt=javabin,debugQuery=false} >> },response={numFound=11,start=0,maxScore=1.0,docs=[SolrDocument{id=31814269823181426982280, >> >> > score=1.0}, SolrDocument{id=31814269823181426982280, score=1.0}, >> >> > SolrDocument{id=31814269823181426982280, score=1.0}, >> >> > SolrDocument{id=31814269823181426982280, score=1.0}, >> >> > SolrDocument{id=31814269823181426982280, score=1.0}, >> >> > SolrDocument{id=31814269823181426982281, score=1.0}, >> >> > SolrDocument{id=31814269823181426982281, score=1.0}, >> >> > SolrDocument{id=31814269823181426982281, score=1.0}, >> >> > SolrDocument{id=31814269823181426982281, score=1.0}, >> >> > SolrDocument{id=31814269823181426982281, >> >> > >> score=1.0}]},sort_values={},debug={timing={time=0.0,prepare={time=0.0,query={time=0.0},facet={time=0.0},facet_module={time=0.0},mlt={time=0.0},highlight={time=0.0},stats={time=0.0},expand={time=0.0},debug={time=0.0}},process={time=0.0,query={time=0.0},facet={time=0.0},facet_module={time=0.0},mlt={time=0.0},highlight={time=0.0},stats={time=0.0},expand={time=0.0},debug={time=0.0}}}}}" >> >> > >> >> > >> >> > }, >> >> > >> >> > >> >> > http: //node-14:8983/solr/ecommerce-15_shard4_replica1/: >> { >> >> > >> >> > >> >> > QTime: "0", >> >> > >> >> > >> >> > ElapsedTime: "2", >> >> > >> >> > >> >> > RequestPurpose: "GET_TOP_IDS", >> >> > >> >> > >> >> > NumFound: "0", >> >> > >> >> > >> >> > Response: >> >> > >> "{responseHeader={status=0,QTime=0,params={df=_text_,distrib=false,debug=[false, >> >> > timing, track],qt=/query,fl=[id, >> >> > score],shards.purpose=4,start=0,fsv=true,shard.url= >> >> > >> http://node-14:8983/solr/ecommerce-15_shard4_replica1/,rid=node-01-ecommerce-15_shard1_replica2-1449842438070-0,rows=10,version=2,q=id:3181426982318142698228*,requestPurpose=GET_TOP_IDS,NOW=1449842438070,isShard=true,wt=javabin,debugQuery=false >> } >> >> > >> },response={numFound=0,start=0,maxScore=0.0,docs=[]},sort_values={},debug={timing={time=0.0,prepare={time=0.0,query={time=0.0},facet={time=0.0},facet_module={time=0.0},mlt={time=0.0},highlight={time=0.0},stats={time=0.0},expand={time=0.0},debug={time=0.0}},process={time=0.0,query={time=0.0},facet={time=0.0},facet_module={time=0.0},mlt={time=0.0},highlight={time=0.0},stats={time=0.0},expand={time=0.0},debug={time=0.0}}}}}" >> >> > >> >> > >> >> > }, >> >> > >> >> > >> >> > http: //node-06:8983/solr/ecommerce-15_shard5_replica1/: { >> >> > >> >> > >> >> > QTime: "0", >> >> > >> >> > >> >> > ElapsedTime: "2", >> >> > >> >> > >> >> > RequestPurpose: "GET_TOP_IDS", >> >> > >> >> > >> >> > NumFound: "0", >> >> > >> >> > >> >> > Response: >> >> > >> "{responseHeader={status=0,QTime=0,params={df=_text_,distrib=false,debug=[false, >> >> > timing, track],qt=/query,fl=[id, >> >> > score],shards.purpose=4,start=0,fsv=true,shard.url= >> >> > >> http://node-06:8983/solr/ecommerce-15_shard5_replica1/,rid=node-01-ecommerce-15_shard1_replica2-1449842438070-0,rows=10,version=2,q=id:3181426982318142698228*,requestPurpose=GET_TOP_IDS,NOW=1449842438070,isShard=true,wt=javabin,debugQuery=false >> } >> >> > >> },response={numFound=0,start=0,maxScore=0.0,docs=[]},sort_values={},debug={timing={time=0.0,prepare={time=0.0,query={time=0.0},facet={time=0.0},facet_module={time=0.0},mlt={time=0.0},highlight={time=0.0},stats={time=0.0},expand={time=0.0},debug={time=0.0}},process={time=0.0,query={time=0.0},facet={time=0.0},facet_module={time=0.0},mlt={time=0.0},highlight={time=0.0},stats={time=0.0},expand={time=0.0},debug={time=0.0}}}}}" >> >> > >> >> > }, >> >> > >> >> > http: //node-13:8983/solr/ecommerce-15_shard3_replica1/: { >> >> > >> >> > >> >> > QTime: "0", >> >> > >> >> > >> >> > ElapsedTime: "2", >> >> > >> >> > >> >> > RequestPurpose: "GET_TOP_IDS", >> >> > >> >> > >> >> > NumFound: "0", >> >> > >> >> > >> >> > Response: >> >> > >> "{responseHeader={status=0,QTime=0,params={df=_text_,distrib=false,debug=[false, >> >> > timing, track],qt=/query,fl=[id, >> >> > score],shards.purpose=4,start=0,fsv=true,shard.url= >> >> > >> http://node-13:8983/solr/ecommerce-15_shard3_replica1/,rid=node-01-ecommerce-15_shard1_replica2-1449842438070-0,rows=10,version=2,q=id:3181426982318142698228*,requestPurpose=GET_TOP_IDS,NOW=1449842438070,isShard=true,wt=javabin,debugQuery=false >> } >> >> > >> },response={numFound=0,start=0,maxScore=0.0,docs=[]},sort_values={},debug={timing={time=0.0,prepare={time=0.0,query={time=0.0},facet={time=0.0},facet_module={time=0.0},mlt={time=0.0},highlight={time=0.0},stats={time=0.0},expand={time=0.0},debug={time=0.0}},process={time=0.0,query={time=0.0},facet={time=0.0},facet_module={time=0.0},mlt={time=0.0},highlight={time=0.0},stats={time=0.0},expand={time=0.0},debug={time=0.0}}}}}" >> >> > >> >> > }, >> >> > >> >> > http: //node-05:8983/solr/ecommerce-15_shard6_replica1/: { >> >> > >> >> > >> >> > QTime: "0", >> >> > >> >> > >> >> > ElapsedTime: "2", >> >> > >> >> > >> >> > RequestPurpose: "GET_TOP_IDS", >> >> > >> >> > >> >> > NumFound: "0", >> >> > >> >> > >> >> > Response: >> >> > >> "{responseHeader={status=0,QTime=0,params={df=_text_,distrib=false,debug=[false, >> >> > timing, track],qt=/query,fl=[id, >> >> > score],shards.purpose=4,start=0,fsv=true,shard.url= >> >> > >> http://node-05:8983/solr/ecommerce-15_shard6_replica1/,rid=node-01-ecommerce-15_shard1_replica2-1449842438070-0,rows=10,version=2,q=id:3181426982318142698228*,requestPurpose=GET_TOP_IDS,NOW=1449842438070,isShard=true,wt=javabin,debugQuery=false >> } >> >> > >> },response={numFound=0,start=0,maxScore=0.0,docs=[]},sort_values={},debug={timing={time=0.0,prepare={time=0.0,query={time=0.0},facet={time=0.0},facet_module={time=0.0},mlt={time=0.0},highlight={time=0.0},stats={time=0.0},expand={time=0.0},debug={time=0.0}},process={time=0.0,query={time=0.0},facet={time=0.0},facet_module={time=0.0},mlt={time=0.0},highlight={time=0.0},stats={time=0.0},expand={time=0.0},debug={time=0.0}}}}}" >> >> > >> >> > }, >> >> > >> >> > http: //node-04:8983/solr/ecommerce-15_shard7_replica2/: { >> >> > >> >> > >> >> > QTime: "0", >> >> > >> >> > >> >> > ElapsedTime: "2", >> >> > >> >> > >> >> > RequestPurpose: "GET_TOP_IDS", >> >> > >> >> > >> >> > NumFound: "0", >> >> > >> >> > >> >> > Response: >> >> > >> "{responseHeader={status=0,QTime=0,params={df=_text_,distrib=false,debug=[false, >> >> > timing, track],qt=/query,fl=[id, >> >> > score],shards.purpose=4,start=0,fsv=true,shard.url= >> >> > >> http://node-04:8983/solr/ecommerce-15_shard7_replica2/,rid=node-01-ecommerce-15_shard1_replica2-1449842438070-0,rows=10,version=2,q=id:3181426982318142698228*,requestPurpose=GET_TOP_IDS,NOW=1449842438070,isShard=true,wt=javabin,debugQuery=false >> } >> >> > >> },response={numFound=0,start=0,maxScore=0.0,docs=[]},sort_values={},debug={timing={time=0.0,prepare={time=0.0,query={time=0.0},facet={time=0.0},facet_module={time=0.0},mlt={time=0.0},highlight={time=0.0},stats={time=0.0},expand={time=0.0},debug={time=0.0}},process={time=0.0,query={time=0.0},facet={time=0.0},facet_module={time=0.0},mlt={time=0.0},highlight={time=0.0},stats={time=0.0},expand={time=0.0},debug={time=0.0}}}}}" >> >> > >> >> > }, >> >> > >> >> > http: //node-15:8983/solr/ecommerce-15_shard10_replica1/: { >> >> > >> >> > >> >> > QTime: "0", >> >> > >> >> > >> >> > ElapsedTime: "2", >> >> > >> >> > >> >> > RequestPurpose: "GET_TOP_IDS", >> >> > >> >> > >> >> > NumFound: "0", >> >> > >> >> > >> >> > Response: >> >> > >> "{responseHeader={status=0,QTime=0,params={df=_text_,distrib=false,debug=[false, >> >> > timing, track],qt=/query,fl=[id, >> >> > score],shards.purpose=4,start=0,fsv=true,shard.url= >> >> > >> http://node-15:8983/solr/ecommerce-15_shard10_replica1/,rid=node-01-ecommerce-15_shard1_replica2-1449842438070-0,rows=10,version=2,q=id:3181426982318142698228*,requestPurpose=GET_TOP_IDS,NOW=1449842438070,isShard=true,wt=javabin,debugQuery=false >> } >> >> > >> },response={numFound=0,start=0,maxScore=0.0,docs=[]},sort_values={},debug={timing={time=0.0,prepare={time=0.0,query={time=0.0},facet={time=0.0},facet_module={time=0.0},mlt={time=0.0},highlight={time=0.0},stats={time=0.0},expand={time=0.0},debug={time=0.0}},process={time=0.0,query={time=0.0},facet={time=0.0},facet_module={time=0.0},mlt={time=0.0},highlight={time=0.0},stats={time=0.0},expand={time=0.0},debug={time=0.0}}}}}" >> >> > >> >> > }, >> >> > >> >> > http: //node-18:8983/solr/ecommerce-15_shard11_replica1/: { >> >> > >> >> > >> >> > QTime: "0", >> >> > >> >> > >> >> > ElapsedTime: "2", >> >> > >> >> > >> >> > RequestPurpose: "GET_TOP_IDS", >> >> > >> >> > >> >> > NumFound: "0", >> >> > >> >> > >> >> > Response: >> >> > >> "{responseHeader={status=0,QTime=0,params={df=_text_,distrib=false,debug=[false, >> >> > timing, track],qt=/query,fl=[id, >> >> > score],shards.purpose=4,start=0,fsv=true,shard.url= >> >> > >> http://node-18:8983/solr/ecommerce-15_shard11_replica1/,rid=node-01-ecommerce-15_shard1_replica2-1449842438070-0,rows=10,version=2,q=id:3181426982318142698228*,requestPurpose=GET_TOP_IDS,NOW=1449842438070,isShard=true,wt=javabin,debugQuery=false >> } >> >> > >> },response={numFound=0,start=0,maxScore=0.0,docs=[]},sort_values={},debug={timing={time=0.0,prepare={time=0.0,query={time=0.0},facet={time=0.0},facet_module={time=0.0},mlt={time=0.0},highlight={time=0.0},stats={time=0.0},expand={time=0.0},debug={time=0.0}},process={time=0.0,query={time=0.0},facet={time=0.0},facet_module={time=0.0},mlt={time=0.0},highlight={time=0.0},stats={time=0.0},expand={time=0.0},debug={time=0.0}}}}}" >> >> > >> >> > }, >> >> > >> >> > http: //node-03:8983/solr/ecommerce-15_shard9_replica1/: { >> >> > >> >> > >> >> > QTime: "0", >> >> > >> >> > >> >> > ElapsedTime: "2", >> >> > >> >> > >> >> > RequestPurpose: "GET_TOP_IDS", >> >> > >> >> > >> >> > NumFound: "0", >> >> > >> >> > >> >> > Response: >> >> > >> "{responseHeader={status=0,QTime=0,params={df=_text_,distrib=false,debug=[false, >> >> > timing, track],qt=/query,fl=[id, >> >> > score],shards.purpose=4,start=0,fsv=true,shard.url= >> >> > >> http://node-03:8983/solr/ecommerce-15_shard9_replica1/,rid=node-01-ecommerce-15_shard1_replica2-1449842438070-0,rows=10,version=2,q=id:3181426982318142698228*,requestPurpose=GET_TOP_IDS,NOW=1449842438070,isShard=true,wt=javabin,debugQuery=false >> } >> >> > >> },response={numFound=0,start=0,maxScore=0.0,docs=[]},sort_values={},debug={timing={time=0.0,prepare={time=0.0,query={time=0.0},facet={time=0.0},facet_module={time=0.0},mlt={time=0.0},highlight={time=0.0},stats={time=0.0},expand={time=0.0},debug={time=0.0}},process={time=0.0,query={time=0.0},facet={time=0.0},facet_module={time=0.0},mlt={time=0.0},highlight={time=0.0},stats={time=0.0},expand={time=0.0},debug={time=0.0}}}}}" >> >> > >> >> > }, >> >> > >> >> > http: //node-02:8983/solr/ecommerce-15_shard8_replica1/: { >> >> > >> >> > >> >> > QTime: "0", >> >> > >> >> > >> >> > ElapsedTime: "2", >> >> > >> >> > >> >> > RequestPurpose: "GET_TOP_IDS", >> >> > >> >> > >> >> > NumFound: "0", >> >> > >> >> > >> >> > Response: >> >> > >> "{responseHeader={status=0,QTime=0,params={df=_text_,distrib=false,debug=[false, >> >> > timing, track],qt=/query,fl=[id, >> >> > score],shards.purpose=4,start=0,fsv=true,shard.url= >> >> > >> http://node-02:8983/solr/ecommerce-15_shard8_replica1/,rid=node-01-ecommerce-15_shard1_replica2-1449842438070-0,rows=10,version=2,q=id:3181426982318142698228*,requestPurpose=GET_TOP_IDS,NOW=1449842438070,isShard=true,wt=javabin,debugQuery=false >> } >> >> > >> },response={numFound=0,start=0,maxScore=0.0,docs=[]},sort_values={},debug={timing={time=0.0,prepare={time=0.0,query={time=0.0},facet={time=0.0},facet_module={time=0.0},mlt={time=0.0},highlight={time=0.0},stats={time=0.0},expand={time=0.0},debug={time=0.0}},process={time=0.0,query={time=0.0},facet={time=0.0},facet_module={time=0.0},mlt={time=0.0},highlight={time=0.0},stats={time=0.0},expand={time=0.0},debug={time=0.0}}}}}" >> >> > >> >> > }, >> >> > >> >> > http: //node-16:8983/solr/ecommerce-15_shard12_replica1/: { >> >> > >> >> > >> >> > QTime: "0", >> >> > >> >> > >> >> > ElapsedTime: "2", >> >> > >> >> > >> >> > RequestPurpose: "GET_TOP_IDS", >> >> > >> >> > >> >> > NumFound: "0", >> >> > >> >> > >> >> > Response: >> >> > >> "{responseHeader={status=0,QTime=0,params={df=_text_,distrib=false,debug=[false, >> >> > timing, track],qt=/query,fl=[id, >> >> > score],shards.purpose=4,start=0,fsv=true,shard.url= >> >> > >> http://node-16:8983/solr/ecommerce-15_shard12_replica1/,rid=node-01-ecommerce-15_shard1_replica2-1449842438070-0,rows=10,version=2,q=id:3181426982318142698228*,requestPurpose=GET_TOP_IDS,NOW=1449842438070,isShard=true,wt=javabin,debugQuery=false >> } >> >> > >> },response={numFound=0,start=0,maxScore=0.0,docs=[]},sort_values={},debug={timing={time=0.0,prepare={time=0.0,query={time=0.0},facet={time=0.0},facet_module={time=0.0},mlt={time=0.0},highlight={time=0.0},stats={time=0.0},expand={time=0.0},debug={time=0.0}},process={time=0.0,query={time=0.0},facet={time=0.0},facet_module={time=0.0},mlt={time=0.0},highlight={time=0.0},stats={time=0.0},expand={time=0.0},debug={time=0.0}}}}}" >> >> > >> >> > } >> >> > >> >> > }, >> >> > >> >> > GET_FIELDS: { >> >> > >> >> > >> >> > http: //node-01:8983/solr/ecommerce-15_shard1_replica2/: { >> >> > >> >> > >> >> > QTime: "3", >> >> > >> >> > >> >> > ElapsedTime: "4", >> >> > >> >> > >> >> > RequestPurpose: "GET_FIELDS,GET_DEBUG", >> >> > >> >> > >> >> > NumFound: "2", >> >> > >> >> > >> >> > Response: >> >> > >> "{responseHeader={status=0,QTime=3,params={df=_text_,distrib=false,debug=[timing, >> >> > track],qt=/query,shards.purpose=320,shard.url= >> >> > >> http://node-01:8983/solr/ecommerce-15_shard1_replica2/,rid=node-01-ecommerce-15_shard1_replica2-1449842438070-0,version=2,q=id:3181426982318142698228*,requestPurpose=GET_FIELDS,GET_DEBUG,NOW=1449842438070,ids=31814269823181426982281,31814269823181426982280,isShard=true,wt=javabin,debugQuery=true} >> },response={numFound=2,start=0,docs=[SolrDocument{id=31814269823181426982281, >> >> > child_type=ecommerce_product, ref=5545562, name=smartphone vodafone >> samsung >> >> > galaxy core prime branco, name_raw=Smartphone VODAFONE SAMSUNG Galaxy >> Core >> >> > Prime Branco, cat=vodafone, cat_raw=Vodafone, qty=1, >> product_price=139.9}, >> >> > SolrDocument{id=31814269823181426982280, child_type=ecommerce_product, >> >> > ref=5439705, name=liquidificadora moulinex faciclic glass lm310e1, >> >> > name_raw=Liquidificadora MOULINEX Faciclic Glass LM310E1, >> >> > cat=liquidificadores, cat_raw=Liquidificadores, qty=1, >> >> > >> product_price=49.99}]},debug={rawquerystring=id:3181426982318142698228*,querystring=id:3181426982318142698228*,parsedquery=id:3181426982318142698228*,parsedquery_toString=id:3181426982318142698228*,explain={31814269823181426982281= >> >> > 1.0 = id:3181426982318142698228*, product of: 1.0 = boost 1.0 = queryNorm >> >> > ,31814269823181426982280= 1.0 = id:3181426982318142698228*, product of: >> 1.0 >> >> > = boost 1.0 = queryNorm >> >> > >> },QParser=LuceneQParser,timing={time=3.0,prepare={time=0.0,query={time=0.0},facet={time=0.0},facet_module={time=0.0},mlt={time=0.0},highlight={time=0.0},stats={time=0.0},expand={time=0.0},debug={time=0.0}},process={time=3.0,query={time=0.0},facet={time=0.0},facet_module={time=0.0},mlt={time=0.0},highlight={time=0.0},stats={time=0.0},expand={time=0.0},debug={time=3.0}}}}}" >> >> > >> >> > } >> >> > >> >> > } >> >> > >> >> > }, >> >> > >> >> > timing: { >> >> > >> >> > >> >> > time: 3, >> >> > >> >> > >> >> > prepare: { >> >> > >> >> > >> >> > time: 0, >> >> > >> >> > >> >> > query: { >> >> > >> >> > >> >> > time: 0 >> >> > >> >> > >> >> > }, >> >> > >> >> > >> >> > facet: { >> >> > >> >> > >> >> > time: 0 >> >> > >> >> > >> >> > }, >> >> > >> >> > >> >> > facet_module: { >> >> > >> >> > >> >> > time: 0 >> >> > >> >> > >> >> > }, >> >> > >> >> > >> >> > mlt: { >> >> > >> >> > >> >> > time: 0 >> >> > >> >> > >> >> > }, >> >> > >> >> > >> >> > highlight: { >> >> > >> >> > >> >> > time: 0 >> >> > >> >> > >> >> > }, >> >> > >> >> > >> >> > stats: { >> >> > >> >> > >> >> > time: 0 >> >> > >> >> > >> >> > }, >> >> > >> >> > >> >> > expand: { >> >> > >> >> > >> >> > time: 0 >> >> > >> >> > >> >> > }, >> >> > >> >> > >> >> > debug: { >> >> > >> >> > >> >> > time: 0 >> >> > >> >> > >> >> > } >> >> > >> >> > >> >> > }, >> >> > >> >> > >> >> > process: { >> >> > >> >> > >> >> > time: 3, >> >> > >> >> > >> >> > query: { >> >> > >> >> > >> >> > time: 0 >> >> > >> >> > >> >> > }, >> >> > >> >> > >> >> > facet: { >> >> > >> >> > >> >> > time: 0 >> >> > >> >> > >> >> > }, >> >> > >> >> > >> >> > facet_module: { >> >> > >> >> > >> >> > time: 0 >> >> > >> >> > >> >> > }, >> >> > >> >> > >> >> > mlt: { >> >> > >> >> > >> >> > time: 0 >> >> > >> >> > >> >> > }, >> >> > >> >> > >> >> > highlight: { >> >> > >> >> > >> >> > time: 0 >> >> > >> >> > >> >> > }, >> >> > >> >> > >> >> > stats: { >> >> > >> >> > >> >> > time: 0 >> >> > >> >> > >> >> > }, >> >> > >> >> > >> >> > expand: { >> >> > >> >> > >> >> > time: 0 >> >> > >> >> > >> >> > }, >> >> > >> >> > >> >> > debug: { >> >> > >> >> > >> >> > time: 3 >> >> > >> >> > >> >> > } >> >> > >> >> > >> >> > } >> >> > >> >> > >> >> > }, >> >> > >> >> > >> >> > rawquerystring: "id:3181426982318142698228*", >> >> > >> >> > >> >> > querystring: "id:3181426982318142698228*", >> >> > >> >> > >> >> > parsedquery: "id:3181426982318142698228*", >> >> > >> >> > >> >> > parsedquery_toString: "id:3181426982318142698228*", >> >> > >> >> > >> >> > QParser: "LuceneQParser", >> >> > >> >> > >> >> > explain: { >> >> > >> >> > >> >> > 31814269823181426982280: " 1.0 = >> >> > id:3181426982318142698228*, product of: 1.0 = boost 1.0 = queryNorm ", >> >> > >> >> > >> >> > 31814269823181426982281: " 1.0 = >> >> > id:3181426982318142698228*, product of: 1.0 = boost 1.0 = queryNorm " >> >> > >> >> > >> >> > } >> >> > >> >> > } >> >> > >> >> > } >> >> > >> >> > >> >> > >> >> > >> >> > —/Yago Riveiro >> >> > >> >> > On Fri, Dec 11, 2015 at 12:53 PM, Mikhail Khludnev >> >> > <mkhlud...@griddynamics.com> wrote: >> >> > >> >> > > what do you see with debugQuery=true ? >> >> > > On Fri, Dec 11, 2015 at 2:02 PM, Yago Riveiro <yago.rive...@gmail.com> >> >> > > wrote: >> >> > >> Hi, >> >> > >> >> >> > >> I'm playing with the nested documents feature and after run this >> query: >> >> > >> >> >> > >> >> >> > >> http://localhost:8983/solr/ecommerce-15/query?q=id:3181426982318142698228* >> >> > >> >> >> > >> The documents has the IDs: >> >> > >> >> >> > >> - Parent : 3181426982318142698228 >> >> > >> - Child_1 : 31814269823181426982280 >> >> > >> - Child_2 : 31814269823181426982281 >> >> > >> >> >> > >> >> >> > >> I have this return: >> >> > >> >> >> > >> { >> >> > >> responseHeader: { >> >> > >> status: 0, >> >> > >> QTime: 3, >> >> > >> params: { >> >> > >> q: "id:3181426982318142698228*" >> >> > >> } >> >> > >> }, >> >> > >> response: { >> >> > >> numFound: 3, >> >> > >> start: 0, >> >> > >> maxScore: 1, >> >> > >> docs: [{ >> >> > >> id: "31814269823181426982280", >> >> > >> child_type: "ecommerce_product", >> >> > >> qty: 1, >> >> > >> product_price: 49.99 >> >> > >> }, { >> >> > >> id: "31814269823181426982281", >> >> > >> child_type: "ecommerce_product", >> >> > >> qty: 1, >> >> > >> product_price: 139.9 >> >> > >> }] >> >> > >> } >> >> > >> } >> >> > >> >> >> > >> As you can see the numFound is 3, and I have only 2 child documents, >> >> > it's >> >> > >> not supposed to ignore the parent document? >> >> > >> >> >> > >> >> >> > >> >> >> > >> ----- >> >> > >> Best regards >> >> > >> -- >> >> > >> View this message in context: >> >> > >> >> >> > >> http://lucene.472066.n3.nabble.com/Nested-document-query-with-wrong-numFound-value-tp4244851.html >> >> > >> Sent from the Solr - User mailing list archive at Nabble.com. >> >> > >> >> >> > > -- >> >> > > Sincerely yours >> >> > > Mikhail Khludnev >> >> > > Principal Engineer, >> >> > > Grid Dynamics >> >> > > <http://www.griddynamics.com> >> >> > > <mkhlud...@griddynamics.com> >> >> >> >> >> >> -- >> >> Sincerely yours >> >> Mikhail Khludnev >> >> Principal Engineer, >> >> Grid Dynamics >> >> >> <http://www.griddynamics.com> >> >> <mkhlud...@griddynamics.com> > -- > Sincerely yours > Mikhail Khludnev > Principal Engineer, > Grid Dynamics > <http://www.griddynamics.com> > <mkhlud...@griddynamics.com>