Mailing-List: contact dev-help@hive.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@hive.apache.org
Received-SPF: pass (nike.apache.org: domain of thejas@hortonworks.com
 designates 209.85.214.170 as permitted sender)
MIME-Version: 1.0
In-Reply-To: 
 <CADgokzGo5=6vaVp9YohdTk57Zw_LU-15=N93Xy+m7YWiNZjQhw@mail.gmail.com>
References: 
 <CADgokzGo5=6vaVp9YohdTk57Zw_LU-15=N93Xy+m7YWiNZjQhw@mail.gmail.com>
Date: Fri, 2 May 2014 11:37:34 -0700
Message-ID: 
 <CABgNGzegjo4FvmyLuSFU+jKV3hpyMzW8X4DC-V8n+yxuyF8Qxw@mail.gmail.com>
Subject: Re: SMB join bug
From: Thejas Nair <thejas@hortonworks.com>
To: "dev@hive.apache.org" <dev@hive.apache.org>
Cc: "<hive-dev@hadoop.apache.org>" <hive-dev@hadoop.apache.org>
Content-Type: text/plain; charset=UTF-8

It is possible that you hit this issue  -
https://issues.apache.org/jira/browse/HIVE-5973
It is fixed in apache hive 0.13 release.


On Thu, May 1, 2014 at 7:10 PM, Sukhendu Chakraborty
<sukhendu.chakraborty@gmail.com> wrote:
> I am seeing very different number of rows in this query output depending on
> whether I enable SMB join:
>
> select count(*)
> from dss.hist_hshld_profl_mc  a
>           join
>           dss.hshld_summary_mc     b
>        on a.hh_key = b.hh_key
>  where ('2012-02-27' between a.hshld_profl_eff_dt and a.hshld_profl_exp_dt)
>       and a.hshld_exp_dt='9999-12-31'
>    and trim(a.cntry_id) = 'USA'
>
> The SMB join returns 60 rows (wrong value) while the regular join returns
> 30million plus rows (correct value).
>
> Is there a known issue/jira for this? We are using CDH5.0/hive-0.12.
>
> -Sukhendu

-- 
CONFIDENTIALITY NOTICE
NOTICE: This message is intended for the use of the individual or entity to 
which it is addressed and may contain information that is confidential, 
privileged and exempt from disclosure under applicable law. If the reader 
of this message is not the intended recipient, you are hereby notified that 
any printing, copying, dissemination, distribution, disclosure or 
forwarding of this communication is strictly prohibited. If you have 
received this communication in error, please contact the sender immediately 
and delete it from your system. Thank You.