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
