Hash file not matching
Posted: Tue Feb 19, 2008 4:16 am
I have one input file of only one coulmn say "single_column" around 30000 length.It has around 1000 rows each identified by a unique key.
I'm using a hash lookup file as a reference which contains the keys, it has around 400 rows.My job ran successfully but there are no rows coming from the hash file.So, my output file has zero rows.
I checked the data also, it's present in hash files but still it's not matching.
The key expression have given for lookup as
Hash.Key----->SeqFile.single_column[1285,10]
And i'm writing a constraint as Not(Hash.NOTFOUND) then pass the rows otherwise...
Please help me out..
I'm using a hash lookup file as a reference which contains the keys, it has around 400 rows.My job ran successfully but there are no rows coming from the hash file.So, my output file has zero rows.
I checked the data also, it's present in hash files but still it's not matching.
The key expression have given for lookup as
Hash.Key----->SeqFile.single_column[1285,10]
And i'm writing a constraint as Not(Hash.NOTFOUND) then pass the rows otherwise...
Please help me out..