Thanks very much Nick, it's yours for the taking. -- Lefty
On Tue, Sep 9, 2014 at 2:37 PM, Martin, Nick <nimar...@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:leftylever...@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.vishwaka...@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" > > >
