Topic
No replies
SystemAdmin
SystemAdmin
160 Posts
ACCEPTED ANSWER

Pinned topic Join stage output quantity mismatch query

‏2007-02-08T13:46:11Z |
I have a job wherein I am joining two datasets using a join stage and join type as left outer.
I have sorted and partitioned both datasets on the join key.
However, still I am not getting the desired output.

I have around 6670 rows as input to the join stage, but as output, I get only 2099. I thought that 6670 remains the minimum possible when performing left-outer join.

Any suggestions on what I should do?