I am getting a following error in my job.
Lookup_53,0: Failed a keylookup for record.
Lookup_53,0: The runLocally() of the operator failed.
Everything in job looks ok to me but its not working. I am reading two sequential files doing a lookup between them using Lookup stage using a common column between both the files. The job gets aborted with the error mentioned above. Can anyone help me with this.
Lookup Stage Error
Moderators: chulett, rschirm, roy
Lookup Stage Error
Regards
Kashif Khan
Kashif Khan
-
- Charter Member
- Posts: 822
- Joined: Sat Sep 17, 2005 5:25 pm
- Location: USA
The first warning suggests that the key value in the lookup data has duplicates. Either remove duplicate or handle the duplicate with the option avaialbe in Lookup. And for the second error, "Lookup failure" options aviable in lookup stage.
I haven't failed, I've found 10,000 ways that don't work.
Thomas Alva Edison(1847-1931)
Thomas Alva Edison(1847-1931)
-
- Charter Member
- Posts: 822
- Joined: Sat Sep 17, 2005 5:25 pm
- Location: USA
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
This error (abort) has occurred because your "Lookup Failed" rule is set to "Fail". Reference rows are not consumed by a Lookup stage so there is no way, using this stage, to determine which keys were touched. Use a Merge stage instead if you need this functionality.
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.