Return-Path: 
 <user-return-6594-apmail-hive-user-archive=hive.apache.org@hive.apache.org>
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 1547C7861
	for <apmail-hive-user-archive@www.apache.org>;
 Fri, 30 Sep 2011 18:50:58 +0000 (UTC)
Received: (qmail 27098 invoked by uid 500); 30 Sep 2011 18:50:57 -0000
Delivered-To: apmail-hive-user-archive@hive.apache.org
Received: (qmail 27065 invoked by uid 500); 30 Sep 2011 18:50:57 -0000
Mailing-List: contact user-help@hive.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:user-help@hive.apache.org>
List-Unsubscribe: <mailto:user-unsubscribe@hive.apache.org>
List-Post: <mailto:user@hive.apache.org>
List-Id: <user.hive.apache.org>
Reply-To: user@hive.apache.org
Delivered-To: mailing list user@hive.apache.org
Received: (qmail 27057 invoked by uid 99); 30 Sep 2011 18:50:57 -0000
Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136)
    by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 30 Sep 2011 18:50:57 +0000
X-ASF-Spam-Status: No, hits=1.5 required=5.0
	tests=FREEMAIL_FROM,HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_PASS,T_TO_NO_BRKTS_FREEMAIL
X-Spam-Check-By: apache.org
Received-SPF: pass (athena.apache.org: domain of the1plummie@gmail.com
 designates 209.85.220.176 as permitted sender)
Received: from [209.85.220.176] (HELO mail-vx0-f176.google.com)
 (209.85.220.176)
    by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 30 Sep 2011 18:50:51 +0000
Received: by vcbfl13 with SMTP id fl13so2393362vcb.35
        for <user@hive.apache.org>; Fri, 30 Sep 2011 11:50:30 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=gamma;
        h=mime-version:date:message-id:subject:from:to:content-type;
        bh=fubj88wP6z5bUNuUd3piZ78tkjbN4ZDB8CBYeMWObeA=;
        b=Tr3ezqTiw3/pEI7VR8lZ1NsxgHhVrlAszVgnHr3gLlNoPo7N6nfNs6ZoKRnVcred4l
         aqv0QbzEVGyrqf7w+RvuRbGtD5ZOR43piTXepCeB4O05SU+ArrZeKY0NMkJXOYZ+IF9Z
         vfgf+xw1brq36L5pIZXSsPrEgzpsHg/YPpNno=
MIME-Version: 1.0
Received: by 10.52.107.102 with SMTP id hb6mr11758177vdb.419.1317408630302;
 Fri, 30 Sep 2011 11:50:30 -0700 (PDT)
Received: by 10.52.162.135 with HTTP; Fri, 30 Sep 2011 11:50:30 -0700 (PDT)
Date: Fri, 30 Sep 2011 11:50:30 -0700
Message-ID: 
 <CANbn9ukSBQwi5zHbzhU9vi=ZkNRux1qET9F5Ahortshok3QgcA@mail.gmail.com>
Subject: hive indexing
From: Shouguo Li <the1plummie@gmail.com>
To: user@hive.apache.org
Content-Type: multipart/alternative; boundary=bcaec54865d06ee6e304ae2d1939

--bcaec54865d06ee6e304ae2d1939
Content-Type: text/plain; charset=ISO-8859-1

hi, i'm looking at adding indexes to our hive tables, am wondering if anyone
can share some thoughts on it. is there a performance/space trade off
comparison or metrics? obviously it would be costly to index all columns in
your tables, so what types of columns are worth indexing?

thx!

--bcaec54865d06ee6e304ae2d1939
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

hi, i&#39;m looking at adding indexes to our hive tables, am wondering if a=
nyone can share some thoughts on it. is there a performance/space trade off=
 comparison or metrics? obviously it would be costly to index all columns i=
n your tables, so what types of columns are worth indexing?<br>
<br>thx!<br>

--bcaec54865d06ee6e304ae2d1939--