You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@hive.apache.org by kumar mr <ku...@aol.com> on 2013/03/01 21:13:46 UTC
doubt with LEFT OUTER JOIN
Hi,
Does LEFT OUTER JOIN returns zero rows when RIGHT SIDE table doesn't have at least one record that matches JOIN condition in Hive?
Regards,
Kumar
Re: doubt with LEFT OUTER JOIN
Posted by Dean Wampler <de...@thinkbiganalytics.com>.
None that I know of, but I haven't tried too many cases. Of course, there
shouldn't be ;)
On Mon, Mar 4, 2013 at 6:38 PM, kumar mr <ku...@aol.com> wrote:
>
>
> Hi dean,
>
> Are there any known issues if we do LEFT OUTER JOIN between different
> table formats like Text and RCfile? Here the tables are of different format
> types.
>
> Regards,
> Kumar
>
>
>
> -----Original Message-----
> From: Dean Wampler <de...@thinkbiganalytics.com>
> To: user <us...@hive.apache.org>
> Sent: Fri, Mar 1, 2013 12:23 pm
> Subject: Re: doubt with LEFT OUTER JOIN
>
> I just tried an experiment where the right-hand table was empty. It
> worked fine. Could you post more details, like the query, create table
> statements, etc? What version of Hive?
>
>
> On Fri, Mar 1, 2013 at 2:13 PM, kumar mr <ku...@aol.com> wrote:
>
>> Hi,
>>
>> Does LEFT OUTER JOIN returns zero rows when RIGHT SIDE table doesn't
>> have at least one record that matches JOIN condition in Hive?
>>
>> Regards,
>> Kumar
>>
>>
>
>
> --
> *Dean Wampler, Ph.D.*
> thinkbiganalytics.com
> +1-312-339-1330
>
>
--
*Dean Wampler, Ph.D.*
thinkbiganalytics.com
+1-312-339-1330
Re: doubt with LEFT OUTER JOIN
Posted by kumar mr <ku...@aol.com>.
Hi dean,
Are there any known issues if we do LEFT OUTER JOIN between different table formats like Text and RCfile? Here the tables are of different format types.
Regards,
Kumar
-----Original Message-----
From: Dean Wampler <de...@thinkbiganalytics.com>
To: user <us...@hive.apache.org>
Sent: Fri, Mar 1, 2013 12:23 pm
Subject: Re: doubt with LEFT OUTER JOIN
I just tried an experiment where the right-hand table was empty. It worked fine. Could you post more details, like the query, create table statements, etc? What version of Hive?
On Fri, Mar 1, 2013 at 2:13 PM, kumar mr <ku...@aol.com> wrote:
Hi,
Does LEFT OUTER JOIN returns zero rows when RIGHT SIDE table doesn't have at least one record that matches JOIN condition in Hive?
Regards,
Kumar
--
Dean Wampler, Ph.D.
thinkbiganalytics.com
+1-312-339-1330
Re: doubt with LEFT OUTER JOIN
Posted by kumar mr <ku...@aol.com>.
Regards,
Kumar
-----Original Message-----
From: Dean Wampler <de...@thinkbiganalytics.com>
To: user <us...@hive.apache.org>
Sent: Fri, Mar 1, 2013 12:23 pm
Subject: Re: doubt with LEFT OUTER JOIN
I just tried an experiment where the right-hand table was empty. It worked fine. Could you post more details, like the query, create table statements, etc? What version of Hive?
On Fri, Mar 1, 2013 at 2:13 PM, kumar mr <ku...@aol.com> wrote:
Hi,
Does LEFT OUTER JOIN returns zero rows when RIGHT SIDE table doesn't have at least one record that matches JOIN condition in Hive?
Regards,
Kumar
--
Dean Wampler, Ph.D.
thinkbiganalytics.com
+1-312-339-1330
Re: doubt with LEFT OUTER JOIN
Posted by Dean Wampler <de...@thinkbiganalytics.com>.
I just tried an experiment where the right-hand table was empty. It worked
fine. Could you post more details, like the query, create table statements,
etc? What version of Hive?
On Fri, Mar 1, 2013 at 2:13 PM, kumar mr <ku...@aol.com> wrote:
> Hi,
>
> Does LEFT OUTER JOIN returns zero rows when RIGHT SIDE table doesn't
> have at least one record that matches JOIN condition in Hive?
>
> Regards,
> Kumar
>
>
--
*Dean Wampler, Ph.D.*
thinkbiganalytics.com
+1-312-339-1330