Hash partion is not working

A forum for discussing DataStage<sup>®</sup> basics. If you're not sure where your question goes, start here.

Moderators: chulett, rschirm, roy

Post Reply
rajeshkadiri
Participant
Posts: 10
Joined: Thu Sep 27, 2007 5:15 am
Location: hyd

Hash partion is not working

Post by rajeshkadiri »

working. if i set 4 nodes, only 3 nodes take data and 1 node doesn't take data.
if i want to see the data in nodes error is coming
balajisr
Charter Member
Charter Member
Posts: 785
Joined: Thu Jul 28, 2005 8:58 am

Post by balajisr »

Can you explain your design a bit more.
Do you have any node constraints?
Hash partitioning method does not result in equal size partitions.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

It is possible (with small probability and depending on your data) that any partitioning algorithm except round robin will have a sufficiently skewed distribution of rows over nodes that a node gets no rows.

Also check that the stage in question is not constrained to executed in a node pool (a subset of nodes).
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