hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From MiaoMiao <liy...@gmail.com>
Subject Re: Improving query performance on hive and hdfs
Date Wed, 05 Sep 2012 06:28:16 GMT
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
<funnlearnforkids@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

Mime
View raw message