Hi Joel,
Yes, I got this error:
{"result-set":{"docs":[{"EXCEPTION":"Invalid JoinStream - all incoming
stream comparators (sort) must be a superset of this stream's
equalitor.","EOF":true}]}}
Ok, will try out the work around first.
Regards,
Edwin
On 15 June 2017 at 20:16, Joel Bernstein <[email protected]> wrote:
> It looks like you are running into this bug:
> https://issues.apache.org/jira/browse/SOLR-10512. This not been resolved
> yet, but I believe there is a work around which is described in the ticket.
>
> Joel Bernstein
> http://joelsolr.blogspot.com/
>
> On Wed, Jun 14, 2017 at 10:09 PM, Zheng Lin Edwin Yeo <
> [email protected]>
> wrote:
>
> > I have found that this is possible, but currently I have problems if the
> > field name to join in all the 3 collections are different.
> >
> > For example, if in "people" collection, it is called personId, and in
> > "pets" collection, it is called petsId. But in "collectionId", it is
> called
> > collectionName, but it won't work when I place it this way below. Any
> > suggestions on how I can handle this?
> >
> > innerJoin(innerJoin(
> > search(people, q=*:*, fl="personId,name", sort="personId asc"),
> > search(pets, q=type:cat, fl="pertsId,petName", sort="personId asc"),
> > on="personId=petsId"
> > ),
> > search(collection1, q=*:*, fl="collectionId,collectionName",
> > sort="personId asc"),
> > )on="personId=collectionId"
> >
> >
> > Regards,
> > Edwin
> >
> > On 14 June 2017 at 23:13, Zheng Lin Edwin Yeo <[email protected]>
> > wrote:
> >
> > > Hi,
> > >
> > > I'm using Solr 6.5.1.
> > >
> > > Is it possible to have multiple hashJoin or innerJoin in the query?
> > >
> > > An example will be something like this for innerJoin:
> > >
> > > innerJoin(innerJoin(
> > > search(people, q=*:*, fl="personId,name", sort="personId asc"),
> > > search(pets, q=type:cat, fl="personId,petName", sort="personId asc"),
> > > on="personId"
> > > ),
> > > search(collection1, q=*:*, fl="personId,personName", sort="personId
> > > asc"),
> > > )
> > >
> > > Regards,
> > > Edwin
> > >
> >
>
