Return-Path: Delivered-To: apmail-hadoop-hive-user-archive@minotaur.apache.org Received: (qmail 1515 invoked from network); 26 Feb 2010 03:56:05 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3) by minotaur.apache.org with SMTP; 26 Feb 2010 03:56:05 -0000 Received: (qmail 97476 invoked by uid 500); 26 Feb 2010 03:56:05 -0000 Delivered-To: apmail-hadoop-hive-user-archive@hadoop.apache.org Received: (qmail 97449 invoked by uid 500); 26 Feb 2010 03:56:05 -0000 Mailing-List: contact hive-user-help@hadoop.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: hive-user@hadoop.apache.org Delivered-To: mailing list hive-user@hadoop.apache.org Received: (qmail 97441 invoked by uid 99); 26 Feb 2010 03:56:05 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 26 Feb 2010 03:56:05 +0000 X-ASF-Spam-Status: No, hits=3.4 required=10.0 tests=HTML_MESSAGE,SPF_NEUTRAL X-Spam-Check-By: apache.org Received-SPF: neutral (nike.apache.org: local policy) Received: from [209.85.221.202] (HELO mail-qy0-f202.google.com) (209.85.221.202) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 26 Feb 2010 03:55:55 +0000 Received: by qyk40 with SMTP id 40so1525524qyk.23 for ; Thu, 25 Feb 2010 19:55:34 -0800 (PST) Received: by 10.224.79.200 with SMTP id q8mr108373qak.341.1267156534278; Thu, 25 Feb 2010 19:55:34 -0800 (PST) Received: from ?192.168.42.151? (75-101-123-136.dsl.static.sonic.net [75.101.123.136]) by mx.google.com with ESMTPS id 22sm1607192qyk.2.2010.02.25.19.55.32 (version=SSLv3 cipher=RC4-MD5); Thu, 25 Feb 2010 19:55:33 -0800 (PST) Message-ID: <4B87462F.2000103@cloudera.com> Date: Thu, 25 Feb 2010 19:55:27 -0800 From: Amr Awadallah User-Agent: Mozilla/5.0 (Windows; U; Windows NT 6.1; en-US; rv:1.9.1.8) Gecko/20100216 Thunderbird/3.0.2 MIME-Version: 1.0 To: hive-user@hadoop.apache.org CC: Yongqiang He Subject: Re: Hive join strategy documentation? References: In-Reply-To: Content-Type: multipart/alternative; boundary="------------060708070004020601060802" X-Virus-Checked: Checked by ClamAV on apache.org This is a multi-part message in MIME format. --------------060708070004020601060802 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit 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" 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 > --------------060708070004020601060802 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit thanks Yongqiang, please also include the hints (MAPJOIN, STREAMBASE).

-- amr

On 2/25/2010 7:53 PM, Yongqiang He wrote:
Re: Hive join strategy documentation? 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" <hammer@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

--------------060708070004020601060802--