[
https://issues.apache.org/jira/browse/HIVE-396?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12739834#action_12739834
]
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: https://issues.apache.org/jira/browse/HIVE-396
> 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: http://wiki.apache.org/pig/PigMix
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
