Lefty, that’s the single best description of indexes/partitions I’ve yet encountered. Stealing it.
Nice ☺ 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<mailto: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"
