pc.org/tpch/ .This implementation is tested with the DB2 data format. THe PACT program implements a modified version of the query 3 of the TPC-H benchmark including one join, some filtering and an aggregation. SELECT l_orderkey, o_shippriority, sum(l_extendedprice) as revenue FROM orders, lineitem WHERE l_orderkey=o_orderkey AND o_orderstatus="X" AND YEAR(o_orderdate) > Y AND o_orderpriority LIKE "Z%" GROUP BY l_orderkey, o_shippriority;
All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.