Examples of eu.stratosphere.example.java.relational.TPCHQuery3$Customer

Package eu.stratosphere.example.java.relational

Examples of eu.stratosphere.example.java.relational.TPCHQuery3$Customer

webserg.refactoring.ch1.Customer
pc.org/tpch/spec/tpch2.16.0.pdf">http://www.tpc.org/tpch/spec/tpch2.16.0.pdf (page 29).
This program implements the following SQL equivalent:
```
 SELECT  l_orderkey,  SUM(l_extendedprice*(1-l_discount)) AS revenue, o_orderdate,  o_shippriority  FROM customer,  orders,  lineitem  WHERE c_mktsegment = '[SEGMENT]'  AND c_custkey = o_custkey AND l_orderkey = o_orderkey AND o_orderdate < date '[DATE]' AND l_shipdate > date '[DATE]' GROUP BY l_orderkey,  o_orderdate,  o_shippriority; 
```
Compared to the original TPC-H query this version does not sort the result by revenue and orderdate.
Input files are plain text CSV files using the pipe character ('|') as field separator as generated by the TPC-H data generator which is available at http://www.tpc.org/tpch/.
Usage: TPCHQuery3 <lineitem-csv path> <customer-csv path> <orders-csv path> <result path>

This example shows how to use:
- custom data type derived from tuple data types
- inline-defined functions
- build-in aggregation functions


    private ConcurrentHashMap<String, Customer> customers = 
        new ConcurrentHashMap<String, Customer>();


    public List<Customer> getCustomersByName(String name) throws NoSuchCustomerException {
        Customer customer = getCustomerByName(name);


        List<Customer> customers = new ArrayList<Customer>();
        customers.add(customer);


        return customers;

View Full Code Here

        customers.put(newCustomer.getName(), newCustomer);
        return newCustomer;
    }


    public Customer getCustomerByName(String name) throws NoSuchCustomerException {
        Customer customer = customers.get(name);
        if (customer == null) {
            NoSuchCustomer noSuchCustomer = new NoSuchCustomer();
            noSuchCustomer.setCustomerName(name);
            throw new NoSuchCustomerException("Did not find any matching customer for name=" + name,
                                              noSuchCustomer);

View Full Code Here


    private ConcurrentHashMap<String, Customer> customers = 
        new ConcurrentHashMap<String, Customer>();


    public List<Customer> getCustomersByName(String name) throws NoSuchCustomerException {
        Customer customer = getCustomerByName(name);


        List<Customer> customers = new ArrayList<Customer>();
        customers.add(customer);


        return customers;

View Full Code Here

        return newCustomer;
    }


    public Customer getCustomerByName(String name) throws NoSuchCustomerException {


        Customer customer = customers.get(name);
        if (customer == null) {
            NoSuchCustomer noSuchCustomer = new NoSuchCustomer();
            noSuchCustomer.setCustomerName(name);
            throw new NoSuchCustomerException("Did not find any matching customer for name=" + name,
                                              noSuchCustomer);

View Full Code Here

  protected void tearDown() throws Exception {
    super.tearDown();
  }


  public void testCustomer() {
    Customer c = new Customer("David");
    assertNotNull(c);  
  }

View Full Code Here

    Customer c = new Customer("David");
    assertNotNull(c);  
  }


  public void testAddRental() {
    Customer customer2 = new Customer("Sallie");
    Movie movie1 = new Movie("Gone with the Wind", Movie.REGULAR);
    Rental rental1 = new Rental(movie1, 3); // 3 day rental
    customer2.addRental(rental1);
  }

View Full Code Here

    Rental rental1 = new Rental(movie1, 3); // 3 day rental
    customer2.addRental(rental1);
  }


  public void testGetName() {
    Customer c = new Customer("David");
    assertEquals("David", c.getName());
  }

View Full Code Here

    Customer c = new Customer("David");
    assertEquals("David", c.getName());
  }


  public void testStatementForRegularMovie() {
    Customer customer2 = new Customer("Sallie");
    Movie movie1 = new Movie("Gone with the Wind", Movie.REGULAR);
    Rental rental1 = new Rental(movie1, 3); // 3 day rental
    customer2.addRental(rental1);
    String expected = "Rental Record for Sallie\n" +
              "\tGone with the Wind\t3.5\n" +
              "Amount owed is 3.5\n" +
              "You earned 1 frequent renter points";
    String statement = customer2.statement();
    assertEquals(expected, statement);
  }

View Full Code Here

    String statement = customer2.statement();
    assertEquals(expected, statement);
  }
  
  public void testStatementForNewReleaseMovie() {
    Customer customer2 = new Customer("Sallie");
    Movie movie1 = new Movie("Star Wars", Movie.NEW_RELEASE);
    Rental rental1 = new Rental(movie1, 3); // 3 day rental
    customer2.addRental(rental1);
    String expected = "Rental Record for Sallie\n" +
              "\tStar Wars\t9.0\n" +
              "Amount owed is 9.0\n" +
              "You earned 2 frequent renter points";
    String statement = customer2.statement();
    assertEquals(expected, statement);
  }

View Full Code Here

    String statement = customer2.statement();
    assertEquals(expected, statement);
  }
  
  public void testStatementForChildrensMovie() {
    Customer customer2 = new Customer("Sallie");
    Movie movie1 = new Movie("Madagascar", Movie.CHILDRENS);
    Rental rental1 = new Rental(movie1, 3); // 3 day rental
    customer2.addRental(rental1);
    String expected = "Rental Record for Sallie\n" +
              "\tMadagascar\t1.5\n" +
              "Amount owed is 1.5\n" +
              "You earned 1 frequent renter points";
    String statement = customer2.statement();
    assertEquals(expected, statement);
  }

View Full Code Here

0 1

TOP

Related Classes of eu.stratosphere.example.java.relational.TPCHQuery3$Customer

eu.stratosphere.api.java.ExecutionEnvironment

server.CustomerServiceImpl

server.NewCustomerServiceImpl

webserg.refactoring.ch1.test.CustomerTest

java.text.SimpleDateFormat

java.util.Calendar

java.util.Date

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.