When you work with relational algebra operations you'll need to specify the /export handler in the search expressions so that all of the tuples are operated on by the join.
search(ParentDocuments, q=DocId:1042, fl="Id,DocId,SubDocId", sort="Id asc", q="/export") Joel Bernstein http://joelsolr.blogspot.com/ On Sun, Jan 22, 2017 at 10:17 PM, Sadheera Vithanage <sadhee...@gmail.com> wrote: > Hello, > > When I issue a OuterHashJoin (stream expression) as below it doesn't return > any results from the right stream. > > outerHashJoin( > search(ChildDocuments, q=*:* , fl="ContentId", sort="ContentId asc"), > hashed= > search(ParentDocuments, q=*:*, fl="Id,DocId,SubDocId", sort="Id asc"), > on="ContentId=Id" > ) > > However, When I filter the Right stream as below, it gives me the results > from both streams. > > > outerHashJoin( > search(ChildDocuments, q=*:* , fl="ContentId", sort="ContentId asc"), > hashed= > search(ParentDocuments, q=DocId:1042, fl="Id,DocId,SubDocId", sort="Id > asc"), > on="ContentId=Id" > ) > > > What am I doing wrong here. > > Thank you. > > -- > Regards > > Sadheera Vithanage >