hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Lefty Leverenz <leftylever...@gmail.com>
Subject Re: Indexes vs Partitions in hive
Date Wed, 10 Sep 2014 04:06:22 GMT
Thanks very much Nick, it's yours for the taking.

-- Lefty

On Tue, Sep 9, 2014 at 2:37 PM, Martin, Nick <NiMartin@pssd.com> wrote:

>  Lefty, that’s the single best description of indexes/partitions I’ve yet
> encountered. Stealing it.
>
>
>
> Nice J
>
>
>
> *From:* Lefty Leverenz [mailto:leftyleverenz@gmail.com]
> *Sent:* Tuesday, September 09, 2014 2:28 PM
> *To:* user@hive.apache.org
> *Subject:* Re: Indexes vs Partitions in hive
>
>
>
> Others can give technical explanations, but I'll give you a simple
> analogy:  a book might have an index as well as chapters.  Both help you
> find information more quickly.  The index directs you to particular
> information, and chapters partition the book into smaller pieces that are
> organized around a common theme.
>
>
>
> To stretch the analogy, a book can only have one set of chapters but it
> can have multiple indexes (topic index, scientific name index, poem title
> index, poem author index, and so on).
>
>
>
>
>   -- Lefty
>
>
>
> On Mon, Sep 8, 2014 at 6:26 AM, Chhaya Vishwakarma <
> Chhaya.Vishwakarma@lntinfotech.com> wrote:
>
> Hi All,
>
> How indexes in hive are different than partitions? both improves query
> performance as per my knowledge then in what way they differ?
>
> What are the situations I'll be using indexing or partitioning? Can i use
> them together?
>
> Kindly suggest
>
>
>
>
>
> Regards,
>
> Chhaya Vishwakarma
>
>
>
>
>  ------------------------------
>
> The contents of this e-mail and any attachment(s) may contain confidential
> or privileged information for the intended recipient(s). Unintended
> recipients are prohibited from taking action on the basis of information in
> this e-mail and using or disseminating the information, and must notify the
> sender and delete it from their system. L&T Infotech will not accept
> responsibility or liability for the accuracy or completeness of, or the
> presence of any virus or disabling code in this e-mail"
>
>
>

Mime
View raw message