hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Lefty Leverenz <>
Subject Re: Indexes vs Partitions in hive
Date Tue, 09 Sep 2014 18:28:24 GMT
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 <> 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"

View raw message