Re: Indexes vs Partitions in hive

2014-09-09 Thread Lefty Leverenz
enz [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 i

RE: Indexes vs Partitions in hive

2014-09-09 Thread Martin, Nick
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

Re: Indexes vs Partitions in hive

2014-09-09 Thread Lefty Leverenz
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