[jira] Commented: (HIVE-396) Hive performance benchmarks

["Alan Gates (JIRA)" <ji...@apache.org>]

    [ 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.