hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Dean Wampler <dean.wamp...@thinkbiganalytics.com>
Subject Re: doubt with LEFT OUTER JOIN
Date Fri, 01 Mar 2013 20:23:02 GMT
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.mr@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

Mime
View raw message