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

Switch to Threaded View
Hive, mail # user - doubt with LEFT OUTER JOIN


Copy link to this message
-
Re: doubt with LEFT OUTER JOIN
kumar mr 2013-03-05, 00:38

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