Hi,
There is a bug in HIVE 0.11 and my earlier email clearly explains how the
issue can be replicated.
I am grateful to have received a pertinent response here
http://hortonworks.com/community/forums/topic/hive-group-by-issue/#post-27613
Setting the number of reducers to 1 does resolve the issue
Your table has five "F1 = 9887" rows and joining will make 25 rows
with the same F1 value.
I cannot imagine what you're intended to do.
2013/6/12 Gourav Sengupta :
> Hi,
>
> I had initially forwarded this request to the user group but am yet to
> receive any response.
>
> I will be grateful if so