Re: Join issue

2011-04-08 Thread Marko Musnjak
As I suspected, the problem was between keyboard and chair :) Thanks, Marko On Fri, Apr 8, 2011 at 00:43, Daniel Dai wrote: > null column from different relation does not redeemed as equal in join. > This is consistent with SQL. > > Daniel > > > On 04/07/2011 11:19 AM, Marko Musnjak wrote: > >>

Re: Join issue

2011-04-07 Thread Daniel Dai
null column from different relation does not redeemed as equal in join. This is consistent with SQL. Daniel On 04/07/2011 11:19 AM, Marko Musnjak wrote: Hi, I'm trying to do a left outer join of two files, on eight keys, but it always seems that the keys don't match. I'm able to reproduce thi

Join issue

2011-04-07 Thread Marko Musnjak
Hi, I'm trying to do a left outer join of two files, on eight keys, but it always seems that the keys don't match. I'm able to reproduce this with the code and files below. I expect to see lines like these: 2011;3;31;2;AAA;;2213;;...;10;31;;;0;3 2011;3;31;2;AAA;