You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@pig.apache.org by "Amir Youssefi (JIRA)" <ji...@apache.org> on 2008/04/10 03:14:04 UTC

[jira] Created: (PIG-200) Pig Performance Benchmarks

Pig Performance Benchmarks
--------------------------

                 Key: PIG-200
                 URL: https://issues.apache.org/jira/browse/PIG-200
             Project: Pig
          Issue Type: New Feature
            Reporter: Amir Youssefi
            Assignee: Amir Youssefi


To benchmark Pig performance, we need to have a TPC-H like Large Data Set plus Script Collection. This is used in comparison of different Pig releases, Pig vs. with other systems.

Here is Wiki for small tests: http://wiki.apache.org/pig/PigPerformance

I am currently running long-running Pig scripts over data-sets in the order of tens of TBs. Next step is hundreds of TBs.

We need to have an open large-data set (open source scripts which generate data-set) and detailed scripts for important operations such as ORDER.

We can call those the Pig Workouts: Cardio (short but intense processing), Marathon (long running queries) and Triathlon (Mix). 

I will update this JIRA with more details of current activities soon.



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


[jira] Commented: (PIG-200) Pig Performance Benchmarks

Posted by "Arun C Murthy (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/PIG-200?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12587674#action_12587674 ] 

Arun C Murthy commented on PIG-200:
-----------------------------------

bq. I have a perl script that I use to generate data for pig testing. [...]

I managed to use the same script via a Pig-Streaming job to generate large amounts of data in a parallel manner, the only change I needed was to edit it to switch off the sql generation...

> Pig Performance Benchmarks
> --------------------------
>
>                 Key: PIG-200
>                 URL: https://issues.apache.org/jira/browse/PIG-200
>             Project: Pig
>          Issue Type: Task
>            Reporter: Amir Youssefi
>            Assignee: Amir Youssefi
>
> To benchmark Pig performance, we need to have a TPC-H like Large Data Set plus Script Collection. This is used in comparison of different Pig releases, Pig vs. other systems (e.g. Pig + Hadoop vs. Hadoop Only).
> Here is Wiki for small tests: http://wiki.apache.org/pig/PigPerformance
> I am currently running long-running Pig scripts over data-sets in the order of tens of TBs. Next step is hundreds of TBs.
> We need to have an open large-data set (open source scripts which generate data-set) and detailed scripts for important operations such as ORDER, AGGREGATION etc.
> We can call those the Pig Workouts: Cardio (short processing), Marathon (long running scripts) and Triathlon (Mix). 
> I will update this JIRA with more details of current activities soon.

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


[jira] Assigned: (PIG-200) Pig Performance Benchmarks

Posted by "Amir Youssefi (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/PIG-200?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Amir Youssefi reassigned PIG-200:
---------------------------------

    Assignee:     (was: Amir Youssefi)

> Pig Performance Benchmarks
> --------------------------
>
>                 Key: PIG-200
>                 URL: https://issues.apache.org/jira/browse/PIG-200
>             Project: Pig
>          Issue Type: Task
>            Reporter: Amir Youssefi
>         Attachments: generate_data.pl
>
>
> To benchmark Pig performance, we need to have a TPC-H like Large Data Set plus Script Collection. This is used in comparison of different Pig releases, Pig vs. other systems (e.g. Pig + Hadoop vs. Hadoop Only).
> Here is Wiki for small tests: http://wiki.apache.org/pig/PigPerformance
> I am currently running long-running Pig scripts over data-sets in the order of tens of TBs. Next step is hundreds of TBs.
> We need to have an open large-data set (open source scripts which generate data-set) and detailed scripts for important operations such as ORDER, AGGREGATION etc.
> We can call those the Pig Workouts: Cardio (short processing), Marathon (long running scripts) and Triathlon (Mix). 
> I will update this JIRA with more details of current activities soon.

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


[jira] Commented: (PIG-200) Pig Performance Benchmarks

Posted by "Alan Gates (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/PIG-200?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12587661#action_12587661 ] 

Alan Gates commented on PIG-200:
--------------------------------

Amir,

I have a perl script that I use to generate data for pig testing.  It can generate different types of data and different sizes.  For a given type and size, it always produces the same set.  However, for data of the same type and different sizes, the smaller is not a subset of the larger.  This allows it to produce good data for testing joins.  If you're interested in using this for your benchmarking, let me know.

> Pig Performance Benchmarks
> --------------------------
>
>                 Key: PIG-200
>                 URL: https://issues.apache.org/jira/browse/PIG-200
>             Project: Pig
>          Issue Type: Task
>            Reporter: Amir Youssefi
>            Assignee: Amir Youssefi
>
> To benchmark Pig performance, we need to have a TPC-H like Large Data Set plus Script Collection. This is used in comparison of different Pig releases, Pig vs. other systems (e.g. Pig + Hadoop vs. Hadoop Only).
> Here is Wiki for small tests: http://wiki.apache.org/pig/PigPerformance
> I am currently running long-running Pig scripts over data-sets in the order of tens of TBs. Next step is hundreds of TBs.
> We need to have an open large-data set (open source scripts which generate data-set) and detailed scripts for important operations such as ORDER, AGGREGATION etc.
> We can call those the Pig Workouts: Cardio (short processing), Marathon (long running scripts) and Triathlon (Mix). 
> I will update this JIRA with more details of current activities soon.

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


[jira] Commented: (PIG-200) Pig Performance Benchmarks

Posted by "Pi Song (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/PIG-200?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12602627#action_12602627 ] 

Pi Song commented on PIG-200:
-----------------------------

To move this forward, I propose that we should have:-
 
1) Small dataset test. Just a set of simple benchmarks for running on development box. For a common machine, it shouldn't take longer than 30 minutes in total.
2) Large dataset test. For real benchmarking.

I think the test cases in http://wiki.apache.org/pig/PigPerformance should already provide good coverage. We will have to do another review once query optimizer is in place.

Alan,  could you please attach the perl script so that I can see what it does?
 

> Pig Performance Benchmarks
> --------------------------
>
>                 Key: PIG-200
>                 URL: https://issues.apache.org/jira/browse/PIG-200
>             Project: Pig
>          Issue Type: Task
>            Reporter: Amir Youssefi
>            Assignee: Amir Youssefi
>
> To benchmark Pig performance, we need to have a TPC-H like Large Data Set plus Script Collection. This is used in comparison of different Pig releases, Pig vs. other systems (e.g. Pig + Hadoop vs. Hadoop Only).
> Here is Wiki for small tests: http://wiki.apache.org/pig/PigPerformance
> I am currently running long-running Pig scripts over data-sets in the order of tens of TBs. Next step is hundreds of TBs.
> We need to have an open large-data set (open source scripts which generate data-set) and detailed scripts for important operations such as ORDER, AGGREGATION etc.
> We can call those the Pig Workouts: Cardio (short processing), Marathon (long running scripts) and Triathlon (Mix). 
> I will update this JIRA with more details of current activities soon.

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


[jira] Updated: (PIG-200) Pig Performance Benchmarks

Posted by "Amir Youssefi (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/PIG-200?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Amir Youssefi updated PIG-200:
------------------------------

    Description: 
To benchmark Pig performance, we need to have a TPC-H like Large Data Set plus Script Collection. This is used in comparison of different Pig releases, Pig vs. other systems (e.g. Pig + Hadoop vs. Hadoop Only).

Here is Wiki for small tests: http://wiki.apache.org/pig/PigPerformance

I am currently running long-running Pig scripts over data-sets in the order of tens of TBs. Next step is hundreds of TBs.

We need to have an open large-data set (open source scripts which generate data-set) and detailed scripts for important operations such as ORDER, AGGREGATION etc.

We can call those the Pig Workouts: Cardio (short processing), Marathon (long running scripts) and Triathlon (Mix). 

I will update this JIRA with more details of current activities soon.



  was:
To benchmark Pig performance, we need to have a TPC-H like Large Data Set plus Script Collection. This is used in comparison of different Pig releases, Pig vs. with other systems.

Here is Wiki for small tests: http://wiki.apache.org/pig/PigPerformance

I am currently running long-running Pig scripts over data-sets in the order of tens of TBs. Next step is hundreds of TBs.

We need to have an open large-data set (open source scripts which generate data-set) and detailed scripts for important operations such as ORDER.

We can call those the Pig Workouts: Cardio (short but intense processing), Marathon (long running queries) and Triathlon (Mix). 

I will update this JIRA with more details of current activities soon.




> Pig Performance Benchmarks
> --------------------------
>
>                 Key: PIG-200
>                 URL: https://issues.apache.org/jira/browse/PIG-200
>             Project: Pig
>          Issue Type: New Feature
>            Reporter: Amir Youssefi
>            Assignee: Amir Youssefi
>
> To benchmark Pig performance, we need to have a TPC-H like Large Data Set plus Script Collection. This is used in comparison of different Pig releases, Pig vs. other systems (e.g. Pig + Hadoop vs. Hadoop Only).
> Here is Wiki for small tests: http://wiki.apache.org/pig/PigPerformance
> I am currently running long-running Pig scripts over data-sets in the order of tens of TBs. Next step is hundreds of TBs.
> We need to have an open large-data set (open source scripts which generate data-set) and detailed scripts for important operations such as ORDER, AGGREGATION etc.
> We can call those the Pig Workouts: Cardio (short processing), Marathon (long running scripts) and Triathlon (Mix). 
> I will update this JIRA with more details of current activities soon.

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


[jira] Updated: (PIG-200) Pig Performance Benchmarks

Posted by "Alan Gates (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/PIG-200?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Alan Gates updated PIG-200:
---------------------------

    Attachment: generate_data.pl

Pi, here's the perl script I use to generate data for end-to-end testing, large and small.

> Pig Performance Benchmarks
> --------------------------
>
>                 Key: PIG-200
>                 URL: https://issues.apache.org/jira/browse/PIG-200
>             Project: Pig
>          Issue Type: Task
>            Reporter: Amir Youssefi
>            Assignee: Amir Youssefi
>         Attachments: generate_data.pl
>
>
> To benchmark Pig performance, we need to have a TPC-H like Large Data Set plus Script Collection. This is used in comparison of different Pig releases, Pig vs. other systems (e.g. Pig + Hadoop vs. Hadoop Only).
> Here is Wiki for small tests: http://wiki.apache.org/pig/PigPerformance
> I am currently running long-running Pig scripts over data-sets in the order of tens of TBs. Next step is hundreds of TBs.
> We need to have an open large-data set (open source scripts which generate data-set) and detailed scripts for important operations such as ORDER, AGGREGATION etc.
> We can call those the Pig Workouts: Cardio (short processing), Marathon (long running scripts) and Triathlon (Mix). 
> I will update this JIRA with more details of current activities soon.

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


[jira] Updated: (PIG-200) Pig Performance Benchmarks

Posted by "Amir Youssefi (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/PIG-200?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Amir Youssefi updated PIG-200:
------------------------------

    Issue Type: Task  (was: New Feature)

> Pig Performance Benchmarks
> --------------------------
>
>                 Key: PIG-200
>                 URL: https://issues.apache.org/jira/browse/PIG-200
>             Project: Pig
>          Issue Type: Task
>            Reporter: Amir Youssefi
>            Assignee: Amir Youssefi
>
> To benchmark Pig performance, we need to have a TPC-H like Large Data Set plus Script Collection. This is used in comparison of different Pig releases, Pig vs. other systems (e.g. Pig + Hadoop vs. Hadoop Only).
> Here is Wiki for small tests: http://wiki.apache.org/pig/PigPerformance
> I am currently running long-running Pig scripts over data-sets in the order of tens of TBs. Next step is hundreds of TBs.
> We need to have an open large-data set (open source scripts which generate data-set) and detailed scripts for important operations such as ORDER, AGGREGATION etc.
> We can call those the Pig Workouts: Cardio (short processing), Marathon (long running scripts) and Triathlon (Mix). 
> I will update this JIRA with more details of current activities soon.

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