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 <[email protected]> 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 > >
