Re: TPC-H benchmark

2009-11-23 Thread Alan Gates
I don't know of any.  Officially Pig cannot publish a TPC-H number  
because it is not a transaction based store.  But I still think it  
would be very interesting to see the results if someone took the time  
to translate the queries.


Alan.

On Nov 22, 2009, at 6:20 PM, RichardGUO Fei wrote:



Hi,



Apart from Pig Performance and Pig Mix, do you know any TPC-H  
benchmark rewritten for Pig?




Thanks,

Richard

_
MSN十周年庆典,查看MSN注册时间,赢取神秘大奖
http://10.msn.com.cn




Re: TPC-H benchmark

2009-11-23 Thread Jeff Hammerbacher
Hey,

It's not Pig, but if you're looking for TPC-H on Hadoop, the Hive team has
run the TPC-H benchmarks: http://issues.apache.org/jira/browse/HIVE-600.

Regards,
Jeff

2009/11/23 Alan Gates ga...@yahoo-inc.com

 I don't know of any.  Officially Pig cannot publish a TPC-H number because
 it is not a transaction based store.  But I still think it would be very
 interesting to see the results if someone took the time to translate the
 queries.

 Alan.


 On Nov 22, 2009, at 6:20 PM, RichardGUO Fei wrote:


 Hi,



 Apart from Pig Performance and Pig Mix, do you know any TPC-H benchmark
 rewritten for Pig?



 Thanks,

 Richard

 _
 MSN十周年庆典,查看MSN注册时间,赢取神秘大奖
 http://10.msn.com.cn





Re: TPC-H benchmark

2009-11-22 Thread Ashutosh Chauhan
Hi Richard,

AFAIK there is no such effort to write TPC-H queries in Pig. IMO it
will be quite useful to do so and to benchmark Pig against those
queries.

Thanks,
Ashutosh

2009/11/22 RichardGUO Fei gladiato...@hotmail.com:

 Hi,



 Apart from Pig Performance and Pig Mix, do you know any TPC-H benchmark 
 rewritten for Pig?



 Thanks,

 Richard

 _
 MSN十周年庆典,查看MSN注册时间,赢取神秘大奖
 http://10.msn.com.cn