Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Plain View
Hive >> mail # user >> doubt with LEFT OUTER JOIN


+
kumar mr 2013-03-01, 20:13
+
Dean Wampler 2013-03-01, 20:23
+
kumar mr 2013-03-05, 00:35
+
kumar mr 2013-03-05, 00:38
Copy link to this message
-
Re: doubt with LEFT OUTER JOIN
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 <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]>
> To: user <[EMAIL PROTECTED]>
> 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 <[EMAIL PROTECTED]> 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