Examples of TPCHQuery3

eu.stratosphere.test.recordJobs.relational.TPCHQuery3

pc.org/tpch/ .This implementation is tested with the DB2 data format. This 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;

org.apache.flink.test.recordJobs.relational.TPCHQuery3

  private void testQueryGeneric(long orderSize, long lineItemSize, 
      float ordersFilterFactor, float joinFilterFactor,
      boolean broadcastOkay, boolean partitionedOkay,
      boolean hashJoinFirstOkay, boolean hashJoinSecondOkay, boolean mergeJoinOkay)
  {
    TPCHQuery3 query = new TPCHQuery3();
    Plan p = query.getPlan(DEFAULT_PARALLELISM_STRING, IN_FILE, IN_FILE, OUT_FILE);
    testQueryGeneric(p, orderSize, lineItemSize, ordersFilterFactor, joinFilterFactor, broadcastOkay, partitionedOkay, hashJoinFirstOkay, hashJoinSecondOkay, mergeJoinOkay);
  }

Examples of org.apache.flink.test.recordJobs.relational.TPCHQuery3

  }


  @Override
  protected Plan getTestJob() {


    TPCHQuery3 tpch3 = new TPCHQuery3();
    return tpch3.getPlan(
        String.valueOf(config.getInteger("dop", 1)), 
        ordersPath,
        lineitemsPath,
        resultPath);
  }

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.