Join issue

samsuf2002 · Post by **samsuf2002** » Wed Oct 28, 2009 2:21 pm

Hi All,

I am trying to join 2 files based on key1(int) and key2(varchar), its not finding a match when I use both as keys although I can manually see the file and finds a match. if I remove key2 its working on Key1 but key2 is required. I tried trimming both keys in both files but still no match. Both files are generated from oracle table and I have $apt_oracle_preserve_blanks as false. I tried both lookup and join with sort, still not working.

Can any one help me on this..

Thanks in advance

abc123 · Post by **abc123** » Wed Oct 28, 2009 8:53 pm

Have you tried testing with a very small number of rows like 1 or 2 on each side and see if they match?

ArndW · Post by **ArndW** » Thu Oct 29, 2009 1:09 am

Also try a test running just a 1-node configuration, as joins are commonly erroneous when incorrect partitioning is used.

bart12872 · Post by **bart12872** » Thu Oct 29, 2009 4:19 am

1- check that your column have the same format in your 2 inputs
integer must join and integer and a varchar join a varchar

2-check your partitionning and your sorts.
you're are right if the partitionning and the sort are the same of the join key and in the same order

3- Insert copy before your inputs and output data with peek to see what is the real data and transform them if necesary

Martin.