Re: doubt with LEFT OUTER JOIN

2013-03-04 Thread Dean Wampler
file? Here the tables are of different format > types. > > Regards, > Kumar > > > > -Original Message- > From: Dean Wampler > To: user > Sent: Fri, Mar 1, 2013 12:23 pm > Subject: Re: doubt with LEFT OUTER JOIN > > I just tried an experiment where

Re: doubt with LEFT OUTER JOIN

2013-03-04 Thread kumar mr
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 wrote: Hi, Does LEFT OUTER JOIN returns zero

Re: doubt with LEFT OUTER JOIN

2013-03-04 Thread kumar mr
Regards, Kumar -Original Message- From: Dean Wampler To: user 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

Re: doubt with LEFT OUTER JOIN

2013-03-01 Thread Dean Wampler
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 wrote: > Hi, > > Does LEFT OUTER JOIN returns zero rows when RIGHT SIDE tab

doubt with LEFT OUTER JOIN

2013-03-01 Thread kumar mr
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