Hi Joel,
It's a simple use case, i have two collections products and related
products, product_id_l is a unique key in products collection and reference
field in related products collection, please find sample documents below.
product:
{
"id":"12345",
"id_l":12345,
"product_name":"product1",
"related_product_count_l":2
}
related products:
{
"id":"56789",
"id_l":56789,
"main_product_id_l":12345,
"product_name":"product10"
"relation_type_code_i":4
},
{
"id":"98765",
"id_l":98765,
"main_product_id_l":12345,
"product_name":"product11"
"relation_type_code_i":2
}
gatherNodes(relatedproduct, search(product,q="related_product_count_l:[1 TO
*]", fl="id_l", qt="/export", sort="id_l desc"), walk=id_l->
main_product_id_l, gather="related_product_id_l",
fq="relation_type_code_i:4",scatter="leaves, branches")
I am trying to fetch all products which are having more than one related
products then joining with related products collection to get all related
products then filtering relation type 4 ones.
Please let me know if you need any other details.
Thanks in advance !!
Best Regards,
Deepu
On Tue, Mar 30, 2021 at 1:54 PM Joel Bernstein <joels...@gmail.com> wrote:
> You're going to have to provide more detail here. I'll have to be able to
> reproduce the error to fix it.
>
>
> Joel Bernstein
> http://joelsolr.blogspot.com/
>
>
> On Tue, Mar 30, 2021 at 2:08 PM Deepu <kpkumar1...@gmail.com> wrote:
>
> > Hi All,
> >
> > Any update on this issue in streaming expressions, which is blocking our
> > solr migration ?
> >
> > Thanks in advance !!
> >
> > Regards,
> > Deepu
> >
> >
> >
> > On Mon, Mar 29, 2021 at 2:12 PM Deepu <kpkumar1...@gmail.com> wrote:
> >
> > > Hi All,
> > >
> > > We are using solr streaming expressions to join to collections, we have
> > > product and similar product indexes, joining these two collections
> based
> > on
> > > product id like below.
> > >
> > > gatherNodes(relatedproduct,
> search(product,q="related_product_count_l:[1
> > > TO *]", fl="id_l", qt="/export", sort="id_l desc"), walk=id_l->
> > > main_product_id_l, gather="related_product_id_l",
> > > fq="relation_type_code_i:4",scatter="leaves, branches")
> > >
> > > Observed always one record is missing from outter gatherNodes function.
> > >
> > > Solr version : 8.4.1
> > >
> > > Please let me know if I am missing anything or is it a known issue.
> > >
> > > Best Regards,
> > > Deepu
> > >
> >
>
