Is it mandatory to sort,partition for JOIN

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
ds_is_fun
Premium Member
Premium Member
Posts: 194
Joined: Fri Jan 07, 2005 12:00 pm

Is it mandatory to sort,partition for JOIN

Post by ds_is_fun »

I did not use sort, hash partition by key columns on the join. Rather left to default auto and ran. There were some data columns that came in with a blank values on the left join. I then changed it to sort,partition and data columns came in right without any blank values. I checked my data for testing this and there was no way blanks should have come in the first step.
Is it mandatory to sort, partition for a join stage?
Thanks
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Yes. Several stage types, Join among them, are documented as requiring that their inputs be sorted.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply