Your store 90 million records in DB? What kind? Sure there are some optimizations to speed up hive query, but I don't see a universal one, except adding more servers.
On Wed, Sep 5, 2012 at 2:19 PM, iwannaplay games <funnlearnfork...@gmail.com> wrote: > Hi all, > > I ran a query on hive on top of 90 million records that took 12 minutes to > execute and same query on sql server took 8 minutes.My question is how can i > make hadoop's performance better.What all configurations will improve the > latency? > > Thanks & Regards > Prabhjot