An explanation of LEFT OUTER JOIN and NULL values

2013-01-24 Thread David Morel
Hi! After hitting the curse of the last reducer many times on LEFT OUTER JOIN queries, and trying to think about it, I came to the conclusion there's something I am missing regarding how keys are handled in mapred jobs. The problem shows when I have table A containing billions of rows with

Re: An explanation of LEFT OUTER JOIN and NULL values

2013-01-24 Thread bejoy_ks
: Thu, 24 Jan 2013 18:03:40 To: user@hive.apache.orguser@hive.apache.org Reply-To: user@hive.apache.org Subject: An explanation of LEFT OUTER JOIN and NULL values Hi! After hitting the curse of the last reducer many times on LEFT OUTER JOIN queries, and trying to think about it, I came

Re: An explanation of LEFT OUTER JOIN and NULL values

2013-01-24 Thread David Morel
- From: David Morel dmore...@gmail.com Date: Thu, 24 Jan 2013 18:03:40 To: user@hive.apache.orguser@hive.apache.org Reply-To: user@hive.apache.org Subject: An explanation of LEFT OUTER JOIN and NULL values Hi! After hitting the curse of the last reducer many times on LEFT OUTER JOIN queries

Re: An explanation of LEFT OUTER JOIN and NULL values

2013-01-24 Thread bejoy_ks
-Original Message- From: David Morel dmore...@gmail.com Date: Thu, 24 Jan 2013 18:39:56 To: user@hive.apache.org; bejoy...@yahoo.com Reply-To: user@hive.apache.org Subject: Re: An explanation of LEFT OUTER JOIN and NULL values On 24 Jan 2013, at 18:16, bejoy...@yahoo.com wrote: Hi David

Re: An explanation of LEFT OUTER JOIN and NULL values

2013-01-24 Thread David Morel
To: user@hive.apache.org; bejoy...@yahoo.com Reply-To: user@hive.apache.org Subject: Re: An explanation of LEFT OUTER JOIN and NULL values On 24 Jan 2013, at 18:16, bejoy...@yahoo.com wrote: Hi David An explain extended would give you the exact pointer. From my understanding, this is how