Return-Path: X-Original-To: apmail-hive-user-archive@www.apache.org Delivered-To: apmail-hive-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id DE0F0FDA6 for ; Tue, 19 Mar 2013 18:23:00 +0000 (UTC) Received: (qmail 24194 invoked by uid 500); 19 Mar 2013 18:22:59 -0000 Delivered-To: apmail-hive-user-archive@hive.apache.org Received: (qmail 24151 invoked by uid 500); 19 Mar 2013 18:22:59 -0000 Mailing-List: contact user-help@hive.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@hive.apache.org Delivered-To: mailing list user@hive.apache.org Received: (qmail 24142 invoked by uid 99); 19 Mar 2013 18:22:59 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 19 Mar 2013 18:22:59 +0000 X-ASF-Spam-Status: No, hits=1.7 required=5.0 tests=FREEMAIL_ENVFROM_END_DIGIT,HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of nitinpawar432@gmail.com designates 209.85.215.54 as permitted sender) Received: from [209.85.215.54] (HELO mail-la0-f54.google.com) (209.85.215.54) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 19 Mar 2013 18:22:54 +0000 Received: by mail-la0-f54.google.com with SMTP id gw10so1546725lab.13 for ; Tue, 19 Mar 2013 11:22:32 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:x-received:in-reply-to:references:date:message-id :subject:from:to:content-type; bh=jx/x0uYIJSDuggDtOhYaJ4hw5joOYeLetegvxKRwdtc=; b=wbb8OqGROvYeyw33j1xJH5BQoKllT0L05AiZ9KfTiE3z5Ctdyp0xaJFhEEKP8afgae F3howyvGFJW72gXj0wKKDPb5+aVFOpknb+fIfhzmUXAtEdpr9IvlBM6S51681Y0MyQ6T kJftDMfKSZ0zL/FgPdAvM1jpTTlk/9MkhVBEZL0Dj+LhZNSPoyLOAEHeTrFlSWjaJoW+ Ce34mZB45eah1y0lKA+nRZQkShPWIcYc1d3tyxgHLdnjuu477PonPC0DayPrB3kRNhOh lkMWTI0SkImfkdAPzBzMifEpacvqlopb/3CzlDlTTvyTz/QphZMpoDL5vRXIM6PkSigC coRQ== MIME-Version: 1.0 X-Received: by 10.112.25.202 with SMTP id e10mr8473413lbg.98.1363717352605; Tue, 19 Mar 2013 11:22:32 -0700 (PDT) Received: by 10.114.15.8 with HTTP; Tue, 19 Mar 2013 11:22:32 -0700 (PDT) In-Reply-To: References: Date: Tue, 19 Mar 2013 23:52:32 +0530 Message-ID: Subject: Re: Has anybody used index on hive tables? how was the performance gain? and best way to do index? From: Nitin Pawar To: user@hive.apache.org Content-Type: multipart/alternative; boundary=bcaec554d43460553704d84b3042 X-Virus-Checked: Checked by ClamAV on apache.org --bcaec554d43460553704d84b3042 Content-Type: text/plain; charset=ISO-8859-1 indexes are definitely a help if you have aggregation function in your queries or group by's sometimes if you have crossjoins it will be helpful as well On Tue, Mar 19, 2013 at 11:44 PM, Echo Li wrote: > Good day, > > I wonder how much hive index helps, I had a test before seems it take long > time to build index, hope to learn something from folks here that have good > experience on it. > > thanks! > echo > -- Nitin Pawar --bcaec554d43460553704d84b3042 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable

indexes are definitely a help if you have aggregation func= tion in your queries or group by's=A0

sometime= s if you have crossjoins it will be helpful as well=A0

On Tue, Mar 19, 2013 at 11:44 PM, Echo L= i <echolql@gmail.com> wrote:

Good day,

I wonder how much hive index helps, I had a test before se= ems it take long time to build index, hope to learn something from folks he= re that have good experience on it.

thanks!
echo

-- Nitin Pawar

--bcaec554d43460553704d84b3042--