hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Alan Gates (JIRA)" <>
Subject [jira] Commented: (HIVE-396) Hive performance benchmarks
Date Thu, 06 Aug 2009 00:19:14 GMT


Alan Gates commented on HIVE-396:

I ran the uservisits_aggre query on one of our clusters and got the following results:

MR Time:  108
Hive:          206
Pig Time:  182

These are wall clock times from beginning to end of the job.  The MR job I used is code I
wrote, not the code included in the benchmark since it was obviously sub-optimal.  

The cluster I used was fairly beefy:  10 boxes (1 as NN and JT, 9 as slaves), 4 disk (each
800G), 16G memory, 2 proc quad core 2.5GHz Xeon processors.  I set io.sort.mb to 1024M, dfs.block.size
to 536870912 (512M), and java heap size to 2G.

I did not make any configuration changes to hive to take advantage of the larger boxes.  Any
thoughts on how I ought to tune hive for this cluster?

> Hive performance benchmarks
> ---------------------------
>                 Key: HIVE-396
>                 URL:
>             Project: Hadoop Hive
>          Issue Type: New Feature
>            Reporter: Zheng Shao
>            Assignee: Yuntao Jia
>         Attachments: hive_benchmark_2009-06-18.pdf, hive_benchmark_2009-06-18.tar.gz,
hive_benchmark_2009-07-12.pdf, hive_benchmark_2009-07-21.tar.gz
> We need some performance benchmark to measure and track the performance improvements
of Hive.
> Some references:
> PIG performance benchmarks PIG-200
> PigMix:

This message is automatically generated by JIRA.
You can reply to this email to add a comment to the issue online.

View raw message