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 <kumar...@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 <dean.wamp...@thinkbiganalytics.com> > To: user <user@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 <kumar...@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