You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@hive.apache.org by Jeff Hammerbacher <ha...@cloudera.com> on 2010/02/18 22:20:14 UTC

Hive join strategy documentation?

Hey,

I am unable to locate any information on the Hive wiki about the various
join strategies and optimizations available in Hive (similar to Pig's
http://wiki.apache.org/pig/JoinFramework). Would one of the more
knowledgeable parties in the Hive community be interested in taking a stab
at such a page?

Thanks,
Jeff

Re: Hive join strategy documentation?

Posted by Gang Luo <lg...@yahoo.com.cn>.

I am also interested in join approaches and optimization in Hive. It will be very helpful if somebody can contribute to such a wiki page. 

-Gang





________________________________
发件人： Jeff Hammerbacher <ha...@cloudera.com>
收件人： hive-user@hadoop.apache.org
发送日期： 2010/2/18 (周四) 4:20:14 下午
主   题： Hive join strategy documentation?

Hey,

I am unable to locate any information on the Hive wiki about the various join strategies and optimizations available in Hive (similar to Pig's http://wiki.apache.org/pig/JoinFramework). Would one of the more knowledgeable parties in the Hive community be interested in taking a stab at such a page?

Thanks,
Jeff



      ___________________________________________________________ 
  好玩贺卡等你发，邮箱贺卡全新上线！ 
http://card.mail.cn.yahoo.com/

Re: Hive join strategy documentation?

Posted by bharath v <bh...@gmail.com>.

Is this wiki updated? If yes can anyone post the link??

Thanks

On Fri, Feb 26, 2010 at 9:25 AM, Amr Awadallah <aa...@cloudera.com> wrote:
> thanks Yongqiang, please also include the hints (MAPJOIN, STREAMBASE).
>
> -- amr
>
> On 2/25/2010 7:53 PM, Yongqiang He wrote:
>
> Hi,
> Thanks. Good suggestion.  Had a short discussion this afternoon.
> I will update the wiki once the sort merge bucket map join and another skew
> join done.
> And will send out an update in this mail-list.
>
> Thanks
> Yongqiang
> On 2/18/10 1:20 PM, "Jeff Hammerbacher" <ha...@cloudera.com> wrote:
>
> Hey,
>
> I am unable to locate any information on the Hive wiki about the various
> join strategies and optimizations available in Hive (similar to Pig's
> http://wiki.apache.org/pig/JoinFramework). Would one of the more
> knowledgeable parties in the Hive community be interested in taking a stab
> at such a page?
>
> Thanks,
> Jeff
>
>

Re: Hive join strategy documentation?

Posted by Amr Awadallah <aa...@cloudera.com>.

thanks Yongqiang, please also include the hints (MAPJOIN, STREAMBASE).

-- amr

On 2/25/2010 7:53 PM, Yongqiang He wrote:
> Hi,
> Thanks. Good suggestion.  Had a short discussion this afternoon.
> I will update the wiki once the sort merge bucket map join and another 
> skew join done.
> And will send out an update in this mail-list.
>
> Thanks
> Yongqiang
> On 2/18/10 1:20 PM, "Jeff Hammerbacher" <ha...@cloudera.com> wrote:
>
>     Hey,
>
>     I am unable to locate any information on the Hive wiki about the
>     various join strategies and optimizations available in Hive
>     (similar to Pig's http://wiki.apache.org/pig/JoinFramework). Would
>     one of the more knowledgeable parties in the Hive community be
>     interested in taking a stab at such a page?
>
>     Thanks,
>     Jeff
>

Re: Hive join strategy documentation?

Posted by Yongqiang He <he...@software.ict.ac.cn>.

Hi,
Thanks. Good suggestion.  Had a short discussion this afternoon.
I will update the wiki once the sort merge bucket map join and another skew
join done.
And will send out an update in this mail-list.

Thanks
Yongqiang
On 2/18/10 1:20 PM, "Jeff Hammerbacher" <ha...@cloudera.com> wrote:

> Hey,
> 
> I am unable to locate any information on the Hive wiki about the various join
> strategies and optimizations available in Hive (similar to Pig's
> http://wiki.apache.org/pig/JoinFramework). Would one of the more knowledgeable
> parties in the Hive community be interested in taking a stab at such a page?
> 
> Thanks,
> Jeff
>