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

Indexes vs Partitions in hive

2014-09-08 Thread Chhaya Vishwakarma
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 _