Re: Multiple hashJoin or innerJoin

2017-06-19 Thread Zheng Lin Edwin Yeo
gt; Regards, > > > >> Edwin > > > >> > > > >> > > > >> On 17 June 2017 at 11:53, Zheng Lin Edwin Yeo > > > > >> wrote: > > > >> > > > >> > Hi Joel, > > > >> > > > >

Re: Multiple hashJoin or innerJoin

2017-06-19 Thread Joel Bernstein
ION":"Invalid JoinStream - all > > incoming > > >> stream comparators (sort) must be a superset of this stream's > > >> equalitor.","EOF":true}]}} > > >> > > > >> > > > >> >

Re: Multiple hashJoin or innerJoin

2017-06-18 Thread Zheng Lin Edwin Yeo
1, q=*:*, fl="collectionId,collectionName", > >> > sort="collectionId asc"), > >> > )on="personId=collectionId" > >> > > >> > The query will get stuck, until I get this message. After which, the > >> whole > >>

Re: Multiple hashJoin or innerJoin

2017-06-18 Thread Joel Bernstein
plica1] o.a.s.c.c.ConnectionManager >> Our >> > previous ZooKeeper session was expired. Attempting to reconnect to >> recover >> > relationship with ZooKeeper... >> > >> > >> > Regards, >> > Edwin >> > >> > &g

Re: Multiple hashJoin or innerJoin

2017-06-18 Thread Joel Bernstein
Edwin > >> > >> > >> On 15 June 2017 at 20:16, Joel Bernstein 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 believ

Re: Multiple hashJoin or innerJoin

2017-06-16 Thread Zheng Lin Edwin Yeo
e, 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 >>> &

Re: Multiple hashJoin or innerJoin

2017-06-16 Thread Zheng Lin Edwin Yeo
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&qu

Re: Multiple hashJoin or innerJoin

2017-06-15 Thread Zheng Lin Edwin Yeo
quot;personId=petsId" > > ), > > search(collection1, q=*:*, fl="collectionId,collectionName", > > sort="personId asc"), > > )on="personId=collectionId" > > > > > > Regards, > > Edwin > > > > On 14 Jun

Re: Multiple hashJoin or innerJoin

2017-06-15 Thread Joel Bernstein
ch(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" > > &

Re: Multiple hashJoin or innerJoin

2017-06-14 Thread Zheng Lin Edwin Yeo
quot;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 wrote: > Hi, > > I&

Multiple hashJoin or innerJoin

2017-06-14 Thread Zheng Lin Edwin Yeo
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