Hi,
I have a query on JOIN stage with Hash partitioning.
Is there any scenario when Sorting should not be done while joining two streams with Hash partitioning? Or should I blindly check the Sort option whenever partition type is set to Hash.
Thanks!
Sorting with Hash parition
Moderators: chulett, rschirm, roy
Sorting with Hash parition
Nitin Jain | India
If everything seems to be going well, you have obviously overlooked something.
If everything seems to be going well, you have obviously overlooked something.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Read the chapter in the Parallel Job Developer's Guide on the Join stage. It its inputs to be sorted (on join key columns). The partitioning algorithm is irrelevant to this requirement.
The only time you would elect not to use Sort on the input link is where you are totally confident that the data on the input links are already correctly sorted.
Code: Select all
requires
The only time you would elect not to use Sort on the input link is where you are totally confident that the data on the input links are already correctly 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.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.