You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@solr.apache.org by Sergio García Maroto <ma...@gmail.com> on 2025/08/20 10:14:28 UTC

hashJoin Stream Expression

Hi community.

I just noticed when running following streaming expression

hashJoin(
  search(people, q="*:*", fl="PersonIDDoc,name", qt="/export",
sort="PersonIDDoc asc"),
  hashed=search(pets, q="type:cat", fl="OwnerID,petName", qt="/export",
sort="OwnerID asc"),
  on="PersonIDDoc=OwnerID"
)

people has PersonIDs: 1,2,3
pets has OwnerIDs: 10,11,12

Results are all the ids from left search. 1,2,3

In case there are results which exist in both tuples then results are only
the matched ones.
FOr isntance

people has PersonIDs: 1,2,3
pets has OwnerIDs: 10,11,2

Results: PersonIDs   2

Is this epcted behaouviour. I understand by documentation if not mathes
between both tupes then yields empty results.
I am using  9.6.0

Thanks
Sergio

Re: hashJoin Stream Expression

Posted by Sergio García Maroto <ma...@gmail.com>.
Forget about this.

My bad . It's working as expected.

Sorry about it.

On Wed, 20 Aug 2025 at 12:14, Sergio García Maroto <ma...@gmail.com>
wrote:

> Hi community.
>
> I just noticed when running following streaming expression
>
> hashJoin(
>   search(people, q="*:*", fl="PersonIDDoc,name", qt="/export",
> sort="PersonIDDoc asc"),
>   hashed=search(pets, q="type:cat", fl="OwnerID,petName", qt="/export",
> sort="OwnerID asc"),
>   on="PersonIDDoc=OwnerID"
> )
>
> people has PersonIDs: 1,2,3
> pets has OwnerIDs: 10,11,12
>
> Results are all the ids from left search. 1,2,3
>
> In case there are results which exist in both tuples then results are only
> the matched ones.
> FOr isntance
>
> people has PersonIDs: 1,2,3
> pets has OwnerIDs: 10,11,2
>
> Results: PersonIDs   2
>
> Is this epcted behaouviour. I understand by documentation if not mathes
> between both tupes then yields empty results.
> I am using  9.6.0
>
> Thanks
> Sergio
>
>