Join stage giving Null's
Posted: Sun Aug 03, 2008 8:16 pm
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.
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.