I am facing a problem with Join stage doing a 'Left outer' join shown below :
Seq File (L) ---|
|----Join ---->
DB2 API (R) ---|
Both the inputs are explicitly Hash partitioned and (stable) sorted. Say, I am joining on a key field 'XYZ' (trimmed).In Join output, I am selecting a field 'MNP' from right link DB2 API.
The problem is I get some of the 'Null' values on 'MNP' field in Join output (meaning some of the keys were not matched, however which should not be the case, all keys present in Left link should also be present in right link).
However, I get all Not-Null values of 'MNP' if I run the Join stage sequential.
Please advise me, what should I need to do if I run Join in parallel mode yet not getting those Null values.
Join stage giving Null's
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Good. Now verify (using Link Execution Order) that the left and right inputs are as you believe them to be.
Your belief that "a left outer join should return all rows from the left input with either matched columns from the right input or nulls for these columns" is correct. If there happen to be null values on the left input, these will fail to join, but will still be transmitted to the output - you really should avoid nulls on join keys.
Your belief that "a left outer join should return all rows from the left input with either matched columns from the right input or nulls for these columns" is correct. If there happen to be null values on the left input, these will fail to join, but will still be transmitted to the output - you really should avoid nulls on join keys.
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.
-
- Participant
- Posts: 1
- Joined: Wed Aug 20, 2008 9:06 pm