All its quantities quantity and the largest quantity

Table Number .............................................

Question 1 (10 marks)

public static class FilterMapper
extends Mapper<Object, Text, Text, IntWritable>{

private final static IntWritable counter = new IntWritable(0); private Text word = new Text();
private Integer total;
private Integer limit;
public void map(Object key, Text value, Context context
) throws IOException, InterruptedException { StringTokenizer itr = new StringTokenizer(value.toString());

SELECT key, value
FROM Sequence-of-key-value-pairs
WHERE value IN (given-value-1, ... , given value-n);

You do not need to re-write entire application. However, if Java code is more convenient for you than written English then you are free to write Java code.

A vehicle repair company would like to create a data warehouse to keep information about its past and present activities. The company employs a number of mechanics, junior mechanics and administration people. The company owns a number of vehicle repair facilities in the different cities all over a country. The mechanics and junior mechanics employed in the facilities perform the services and repairs of vehicles owned by the customers.

The company would like to organize a data warehouse such that following information can be retrieved/computed from the warehouse later on.

(5) Find the total number of parts used for services or repairs per day, per month, per year.

(6) Find the average time spent on repairs or services per day, per month, per year, per facility.

A vehicle is described by a registration number (unique) fuel consumption, and capacity.

Employees are described be employee number (unique), first name, and last name. Mechanics are described by licence number (unique), junior mechanics are described the titles of courses completed.

Page 3 of 7

Page 4 of 7

(3 marks)

(2) Write the commands of HBase shell command language that insert into HBase table created in the previous step information about at least 2 orders submitted by the same customer and including two different products.

Page 5 of 7

Assume that the data files customer.txt, product.txt, and order.txt has been uploaded into HDFS.

Write a sequence of Pig-Latin commands that find the total quantities of products grouped by product name.

The files customer.tbl, order_details.tbl, order.tbl, product.tbl, salesperson.tbl contain data

(2) Lists all order details where discount is less than 0.5.

(3) Find the total number of customers located in Germany.