Thanks Joel. That fixed the problem. Regards, Rajeswari
On Fri, Oct 18, 2019 at 12:50 PM Joel Bernstein <joels...@gmail.com> wrote: > The query that is created to me looks looked good but it returns no > results. Let's just do a basic query using the select handler: > > product_s:product1 > > If this brings back zero results then we know we have a problem with the > data. > > Joel Bernstein > http://joelsolr.blogspot.com/ > > > On Fri, Oct 18, 2019 at 1:41 PM Rajeswari Natarajan <rajis...@gmail.com> > wrote: > > > Hi Joel, > > > > Do you see anything wrong in the config or data . I am using 7.6. > > > > Thanks, > > Rajeswari > > > > On Thu, Oct 17, 2019 at 8:36 AM Rajeswari Natarajan <rajis...@gmail.com> > > wrote: > > > > > My config is from > > > > > > > > > > > > https://github.com/apache/lucene-solr/tree/branch_7_6/solr/solrj/src/test-files/solrj/solr/configsets/streaming/conf > > > > > > > > > <dynamicField name="*_s" type="string" indexed="true" stored="true" > /> > > > > > > <fieldtype name="string" class="solr.StrField" sortMissingLast="true" > > > docValues="true"/> > > > > > > > > > > > > <dynamicField name="*_f" type="float" indexed="true" stored="true"/> > > > > > > <fieldType name="float" docValues="true" class="solr.FloatPointField" > > omitNorms="true" > > > positionIncrementGap="0"/> > > > > > > > > > > > > Thanks, > > > > > > Rajeswari > > > > > > On Thu, Oct 17, 2019 at 8:16 AM Rajeswari Natarajan < > rajis...@gmail.com> > > > wrote: > > > > > >> I tried below query and it returns o results > > >> > > >> > > >> > > > http://localhost:8983/solr/knr/export?{!terms+f%3Dproduct_s}product1&distrib=false&fl=basket_s,product_s&sort=basket_s+asc,product_s+asc&wt=json&version=2.2 > <http://localhost:8983/solr/knr/export?%7B!terms+f%3Dproduct_s%7Dproduct1&distrib=false&fl=basket_s,product_s&sort=basket_s+asc,product_s+asc&wt=json&version=2.2> > > < > http://localhost:8983/solr/knr/export?%7B!terms+f%3Dproduct_s%7Dproduct1&distrib=false&fl=basket_s,product_s&sort=basket_s+asc,product_s+asc&wt=json&version=2.2 > > > > >> < > > > http://localhost:8983/solr/knr/export?%7B!terms+f%3Dproduct_s%7Dproduct1&distrib=false&fl=basket_s,product_s&sort=basket_s+asc,product_s+asc&wt=json&version=2.2 > > > > > >> > > >> > > >> { > > >> "responseHeader":{"status":0}, > > >> "response":{ > > >> "numFound":0, > > >> "docs":[]}} > > >> > > >> Regards, > > >> Rajeswari > > >> On Thu, Oct 17, 2019 at 8:05 AM Rajeswari Natarajan < > rajis...@gmail.com > > > > > >> wrote: > > >> > > >>> Thanks Joel. > > >>> > > >>> Here is the logs for below request > > >>> > > >>> curl --data-urlencode > > >>> 'expr=gatherNodes(knr,walk="product1->product_s",gather="basket_s")' > > >>> http://localhost:8983/solr/knr/stream > > >>> > > >>> 2019-10-17 15:02:06.969 INFO (qtp952486988-280) [c:knr s:shard1 > > >>> r:core_node2 x:knr_shard1_replica_n1] o.a.s.c.S.Request > > >>> [knr_shard1_replica_n1] webapp=/solr path=/stream > > >>> > > > params={expr=gatherNodes(knr,walk%3D"product1->product_s",gather%3D"basket_s")} > > >>> status=0 QTime=0 > > >>> > > >>> 2019-10-17 15:02:06.975 INFO (qtp952486988-192) [c:knr s:shard1 > > >>> r:core_node2 x:knr_shard1_replica_n1] o.a.s.c.S.Request > > >>> [knr_shard1_replica_n1] webapp=/solr path=/export > > >>> > > > params={q={!terms+f%3Dproduct_s}product1&distrib=false&indent=off&fl=basket_s,product_s&sort=basket_s+asc,product_s+asc&wt=json&version=2.2} > > >>> hits=0 status=0 QTime=1 > > >>> > > >>> > > >>> > > >>> Here is the logs for > > >>> > > >>> > > >>> > > >>> curl --data-urlencode > > >>> > > > 'expr=gatherNodes(knr,walk="product1->product_s",gather="basket_s",scatter="branches, > > >>> leaves")' http://localhost:8983/solr/knr/stream > > >>> > > >>> > > >>> 2019-10-17 15:03:57.068 INFO (qtp952486988-356) [c:knr s:shard1 > > >>> r:core_node2 x:knr_shard1_replica_n1] o.a.s.c.S.Request > > >>> [knr_shard1_replica_n1] webapp=/solr path=/stream > > >>> > > > params={expr=gatherNodes(knr,walk%3D"product1->product_s",gather%3D"basket_s",scatter%3D"branches,+leaves")} > > >>> status=0 QTime=0 > > >>> > > >>> 2019-10-17 15:03:57.071 INFO (qtp952486988-400) [c:knr s:shard1 > > >>> r:core_node2 x:knr_shard1_replica_n1] o.a.s.c.S.Request > > >>> [knr_shard1_replica_n1] webapp=/solr path=/export > > >>> > > > params={q={!terms+f%3Dproduct_s}product1&distrib=false&indent=off&fl=basket_s,product_s&sort=basket_s+asc,product_s+asc&wt=json&version=2.2} > > >>> hits=0 status=0 QTime=0 > > >>> > > >>> > > >>> > > >>> > > >>> Thank you, > > >>> > > >>> Rajeswari > > >>> > > >>> On Thu, Oct 17, 2019 at 5:23 AM Joel Bernstein <joels...@gmail.com> > > >>> wrote: > > >>> > > >>>> Can you show the logs from this request. There will be a Solr query > > that > > >>>> gets sent with product1 searched against the product_s field. Let's > > see > > >>>> how > > >>>> many documents that query returns. > > >>>> > > >>>> > > >>>> Joel Bernstein > > >>>> http://joelsolr.blogspot.com/ > > >>>> > > >>>> > > >>>> On Thu, Oct 17, 2019 at 1:41 AM Rajeswari Natarajan < > > rajis...@gmail.com > > >>>> > > > >>>> wrote: > > >>>> > > >>>> > Hi, > > >>>> > > > >>>> > Since the stream graph query for my use case , didn't work as i > > took > > >>>> the > > >>>> > data from solr source code test and also copied the schema and > > >>>> > solrconfig.xml from solr 7.6 source code. Had to substitute few > > >>>> variables. > > >>>> > > > >>>> > Posted below data > > >>>> > > > >>>> > curl -X POST http://localhost:8983/solr/knr/update -H > > >>>> > 'Content-type:text/csv' -d ' > > >>>> > id, basket_s, product_s, prics_f > > >>>> > 90,basket1,product1,20 > > >>>> > 91,basket1,product3,30 > > >>>> > 92,basket1,product5,1 > > >>>> > 93,basket2,product1,2 > > >>>> > 94,basket2,product6,5 > > >>>> > 95,basket2,product7,10 > > >>>> > 96,basket3,product4,20 > > >>>> > 97,basket3,product3,10 > > >>>> > 98,basket3,product1,10 > > >>>> > 99,basket4,product4,40 > > >>>> > 110,basket4,product3,10 > > >>>> > 111,basket4,product1,10' > > >>>> > After this I committed and made sure the data got published. to > solr > > >>>> > > > >>>> > curl --data-urlencode > > >>>> > > 'expr=gatherNodes(knr,walk="product1->product_s",gather="basket_s")' > > >>>> > http://localhost:8983/solr/knr/stream > > >>>> > > > >>>> > { > > >>>> > > > >>>> > "result-set":{ > > >>>> > > > >>>> > "docs":[{ > > >>>> > > > >>>> > "EOF":true, > > >>>> > > > >>>> > "RESPONSE_TIME":4}]}} > > >>>> > > > >>>> > > > >>>> > and if I add *scatter="branches, leaves" , there is one doc.* > > >>>> > > > >>>> > > > >>>> > > > >>>> > curl --data-urlencode > > >>>> > > > >>>> > > > >>>> > > > 'expr=gatherNodes(knr,walk="product1->product_s",gather="basket_s",scatter="branches, > > >>>> > leaves")' http://localhost:8983/solr/knr/stream > > >>>> > > > >>>> > { > > >>>> > > > >>>> > "result-set":{ > > >>>> > > > >>>> > "docs":[{ > > >>>> > > > >>>> > "node":"product1", > > >>>> > > > >>>> > "collection":"knr", > > >>>> > > > >>>> > "field":"node", > > >>>> > > > >>>> > "level":0} > > >>>> > > > >>>> > ,{ > > >>>> > > > >>>> > "EOF":true, > > >>>> > > > >>>> > "RESPONSE_TIME":4}]}} > > >>>> > > > >>>> > > > >>>> > > > >>>> > > > >>>> > Below is the data I got from > > >>>> > > > >>>> > > > >>>> > > > https://github.com/apache/lucene-solr/blob/branch_7_6/solr/solrj/src/test/org/apache/solr/client/solrj/io/graph/GraphExpressionTest.java#L271 > > >>>> > > > >>>> > > > >>>> > > > >>>> > According to this test 4 docs are expected. > > >>>> > > > >>>> > > > >>>> > I am not sure what I am missing. Any pointers, please > > >>>> > > > >>>> > > > >>>> > Thanks you, > > >>>> > > > >>>> > Rajeswari > > >>>> > > > >>>> > > >>> > > >