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
