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:
> Does LEFT OUTER JOIN returns zero rows when RIGHT SIDE table doesn't
> have at least one record that matches JOIN condition in Hive?
*Dean Wampler, Ph.D.*