Lookup Stage Error

kashif007 · Post by **kashif007** » Thu Mar 15, 2007 9:50 am

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.

rajngt · Post by **rajngt** » Thu Mar 15, 2007 10:52 am

Check for the lookup failure condition in the Lookup stage properties.. It must be Failed... Based on your requirement choose a option from it....

us1aslam1us · Post by **us1aslam1us** » Thu Mar 15, 2007 10:53 am

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.

kashif007 · Post by **kashif007** » Thu Mar 15, 2007 11:23 am

Yeh that work, another question that I have is if i am doing a lookup and something does not match then can I do a Reject using Lookstage in the constraint. Will the reject fetch all the columns alligned as the same other output is.

us1aslam1us · Post by **us1aslam1us** » Thu Mar 15, 2007 3:04 pm

If think it uses the column definition of the Primary Input Link and you won't be able to change them.

ray.wurlod · Post by **ray.wurlod** » Thu Mar 15, 2007 9:27 pm

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.