/**
* Licensed to the Apache Software Foundation (ASF) under one
* or more contributor license agreements. See the NOTICE file
* distributed with this work for additional information
* regarding copyright ownership. The ASF licenses this file
* to you under the Apache License, Version 2.0 (the
* "License"); you may not use this file except in compliance
* with the License. You may obtain a copy of the License at
*
* http://www.apache.org/licenses/LICENSE-2.0
*
* Unless required by applicable law or agreed to in writing, software
* distributed under the License is distributed on an "AS IS" BASIS,
* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
* See the License for the specific language governing permissions and
* limitations under the License.
*/
package org.apache.hadoop.zebra.mapreduce;
import java.io.BufferedWriter;
import java.io.ByteArrayOutputStream;
import java.io.File;
import java.io.FileWriter;
import java.io.IOException;
import java.io.PrintWriter;
import java.util.Iterator;
import java.util.StringTokenizer;
import junit.framework.Assert;
import org.apache.hadoop.conf.Configuration;
import org.apache.hadoop.fs.FSDataOutputStream;
import org.apache.hadoop.fs.Path;
import org.apache.hadoop.io.BytesWritable;
import org.apache.hadoop.io.LongWritable;
import org.apache.hadoop.io.Text;
import org.apache.hadoop.mapreduce.Job;
import org.apache.hadoop.mapreduce.Mapper;
import org.apache.hadoop.mapreduce.Reducer;
import org.apache.hadoop.mapreduce.lib.input.FileInputFormat;
import org.apache.hadoop.mapreduce.lib.input.TextInputFormat;
import org.apache.hadoop.util.Tool;
import org.apache.hadoop.util.ToolRunner;
import org.apache.hadoop.zebra.mapreduce.BasicTableOutputFormat;
import org.apache.hadoop.zebra.mapreduce.ZebraOutputPartition;
import org.apache.hadoop.zebra.parser.ParseException;
import org.apache.hadoop.zebra.schema.Schema;
import org.apache.hadoop.zebra.types.TypesUtils;
import org.apache.hadoop.zebra.types.ZebraTuple;
import org.apache.pig.ExecType;
import org.apache.pig.backend.executionengine.ExecException;
import org.apache.pig.data.Tuple;
import org.junit.BeforeClass;
import org.junit.Test;
import org.apache.hadoop.zebra.BaseTestCase;
/**
* This is a sample a complete MR sample code for Table. It doens't contain
* 'read' part. But, it should be similar and easier to write. Refer to test
* cases in the same directory.
*
* Assume the input files contain rows of word and count, separated by a space:
*
* <pre>
* us 2
* japan 2
* india 4
* us 2
* japan 1
* india 3
* nouse 5
* nowhere 4
*
*
*/
public class TestMultipleOutputs4 extends BaseTestCase implements Tool{
static String inputPath;
static String inputFileName = "multi-input.txt";
public static String sortKey = null;
private static String strTable1 = null;
private static String strTable2 = null;
@BeforeClass
public static void setUpOnce() throws Exception {
init();
inputPath = getTableFullPath(inputFileName).toString();
writeToFile(inputPath);
}
public String getCurrentMethodName() {
ByteArrayOutputStream baos = new ByteArrayOutputStream();
PrintWriter pw = new PrintWriter(baos);
(new Throwable()).printStackTrace(pw);
pw.flush();
String stackTrace = baos.toString();
pw.close();
StringTokenizer tok = new StringTokenizer(stackTrace, "\n");
tok.nextToken(); // 'java.lang.Throwable'
tok.nextToken(); // 'at ...getCurrentMethodName'
String l = tok.nextToken(); // 'at ...<caller to getCurrentRoutine>'
// Parse line 3
tok = new StringTokenizer(l.trim(), " <(");
String t = tok.nextToken(); // 'at'
t = tok.nextToken(); // '...<caller to getCurrentRoutine>'
StringTokenizer st = new StringTokenizer(t, ".");
String methodName = null;
while (st.hasMoreTokens()) {
methodName = st.nextToken();
}
return methodName;
}
public static void writeToFile (String inputFile) throws IOException{
if (mode == TestMode.local) {
FileWriter fstream = new FileWriter(inputFile);
BufferedWriter out = new BufferedWriter(fstream);
out.write("us 2\n");
out.write("japan 2\n");
out.write("india 4\n");
out.write("us 2\n");
out.write("japan 1\n");
out.write("india 3\n");
out.write("nouse 5\n");
out.write("nowhere 4\n");
out.close();
}
if (mode == TestMode.cluster) {
FSDataOutputStream fout = fs.create(new Path (inputFile));
fout.writeBytes("us 2\n");
fout.writeBytes("japan 2\n");
fout.writeBytes("india 4\n");
fout.writeBytes("us 2\n");
fout.writeBytes("japan 1\n");
fout.writeBytes("india 3\n");
fout.writeBytes("nouse 5\n");
fout.writeBytes("nowhere 4\n");
fout.close();
}
}
public static void getTablePaths(String myMultiLocs) {
StringTokenizer st = new StringTokenizer(myMultiLocs, ",");
// get how many tokens inside st object
System.out.println("tokens count: " + st.countTokens());
int count = 0;
// iterate st object to get more tokens from it
while (st.hasMoreElements()) {
count++;
String token = st.nextElement().toString();
if (mode == TestMode.local) {
System.out.println("in mini, token: "+token);
//in mini, token: file:/homes/<uid>/grid/multipleoutput/pig-table/contrib/zebra/ustest3
if (count == 1)
strTable1 = token;
if (count == 2)
strTable2 = token;
}
if (mode == TestMode.cluster) {
System.out.println("in real, token: "+token);
//in real, token: /user/hadoopqa/ustest3
//note: no prefix file: in real cluster
if (count == 1)
strTable1 = token;
if (count == 2)
strTable2 = token;
}
}
}
public static void checkTableExists(boolean expected, String strDir) throws IOException{
File theDir = null;
boolean actual = false;
theDir = new File(strDir);
actual = fs.exists(new Path (theDir.toString()));
System.out.println("the dir : "+ theDir.toString());
if (actual != expected){
Assert.fail("dir exists or not is different from what expected.");
}
}
public static void checkTable(String myMultiLocs) throws IOException {
System.out.println("myMultiLocs:" + myMultiLocs);
System.out.println("sorgetTablePathst key:" + sortKey);
getTablePaths(myMultiLocs);
String query1 = null;
String query2 = null;
if (strTable1 != null) {
query1 = "records1 = LOAD '" + strTable1
+ "' USING org.apache.hadoop.zebra.pig.TableLoader();";
}
if (strTable2 != null) {
query2 = "records2 = LOAD '" + strTable2
+ "' USING org.apache.hadoop.zebra.pig.TableLoader();";
}
int count1 = 0;
int count2 = 0;
if (query1 != null) {
System.out.println(query1);
pigServer.registerQuery(query1);
Iterator<Tuple> it = pigServer.openIterator("records1");
while (it.hasNext()) {
count1++;
Tuple RowValue = it.next();
System.out.println(RowValue);
// test 1 us table
if (query1.contains("test1") || query1.contains("test2")|| query1.contains("test3")) {
if (count1 == 1) {
Assert.assertEquals("us", RowValue.get(0));
Assert.assertEquals(2, RowValue.get(1));
}
if (count1 == 2) {
Assert.assertEquals("us", RowValue.get(0));
Assert.assertEquals(2, RowValue.get(1));
}
} // test1, test2
}// while
if (query1.contains("test1") || query1.contains("test2")
|| query1.contains("test3")) {
Assert.assertEquals(2, count1);
}
}// if query1 != null
if (query2 != null) {
pigServer.registerQuery(query2);
Iterator<Tuple> it = pigServer.openIterator("records2");
while (it.hasNext()) {
count2++;
Tuple RowValue = it.next();
System.out.println(RowValue);
// if test1 other table
if (query2.contains("test1")) {
if (count2 == 1) {
Assert.assertEquals("india", RowValue.get(0));
Assert.assertEquals(3, RowValue.get(1));
}
if (count2 == 2) {
Assert.assertEquals("india", RowValue.get(0));
Assert.assertEquals(4, RowValue.get(1));
}
if (count2 == 3) {
Assert.assertEquals("japan", RowValue.get(0));
Assert.assertEquals(1, RowValue.get(1));
}
if (count2 == 4) {
Assert.assertEquals("japan", RowValue.get(0));
Assert.assertEquals(2, RowValue.get(1));
}
if (count1 == 5) {
Assert.assertEquals("nouse", RowValue.get(0));
Assert.assertEquals(5, RowValue.get(1));
}
if (count1 == 6) {
Assert.assertEquals("nowhere", RowValue.get(0));
Assert.assertEquals(4, RowValue.get(1));
}
}// if test1
// if test2 other table
if (query2.contains("test2")) {
if (count2 == 1) {
Assert.assertEquals("india", RowValue.get(0));
Assert.assertEquals(4, RowValue.get(1));
}
if (count2 == 2) {
Assert.assertEquals("india", RowValue.get(0));
Assert.assertEquals(3, RowValue.get(1));
}
if (count2 == 3) {
Assert.assertEquals("japan", RowValue.get(0));
Assert.assertEquals(2, RowValue.get(1));
}
if (count2 == 4) {
Assert.assertEquals("japan", RowValue.get(0));
Assert.assertEquals(1, RowValue.get(1));
}
if (count1 == 5) {
Assert.assertEquals("nouse", RowValue.get(0));
Assert.assertEquals(5, RowValue.get(1));
}
if (count1 == 6) {
Assert.assertEquals("nowhere", RowValue.get(0));
Assert.assertEquals(4, RowValue.get(1));
}
}// if test2
// if test3 other table
if (query2.contains("test3")) {
if (count2 == 1) {
Assert.assertEquals("japan", RowValue.get(0));
Assert.assertEquals(1, RowValue.get(1));
}
if (count2 == 2) {
Assert.assertEquals("japan", RowValue.get(0));
Assert.assertEquals(2, RowValue.get(1));
}
if (count2 == 3) {
Assert.assertEquals("india", RowValue.get(0));
Assert.assertEquals(3, RowValue.get(1));
}
if (count2 == 4) {
Assert.assertEquals("india", RowValue.get(0));
Assert.assertEquals(4, RowValue.get(1));
}
if (count1 == 5) {
Assert.assertEquals("nowhere", RowValue.get(0));
Assert.assertEquals(4, RowValue.get(1));
}
if (count1 == 6) {
Assert.assertEquals("nouse", RowValue.get(0));
Assert.assertEquals(5, RowValue.get(1));
}
}// if test3
}// while
if (query2.contains("test1") || query2.contains("test2")
|| query2.contains("test3")) {
Assert.assertEquals(6, count2);
}
}// if query2 != null
}
@Test
public void test1() throws ParseException, IOException,
org.apache.hadoop.zebra.parser.ParseException, Exception {
/*
* test combine sort keys
*/
System.out.println("******Start testcase: " + getCurrentMethodName());
sortKey = "word,count";
System.out.println("hello sort on word and count");
String myMultiLocs = null;
myMultiLocs = getTableFullPath("a").toString();
getTablePaths(myMultiLocs);
removeDir(new Path(strTable1));
runMR(myMultiLocs, sortKey);
checkTableExists(true, strTable1);
System.out.println("DONE test " + getCurrentMethodName());
}
static class MapClass extends
Mapper<LongWritable, Text, BytesWritable, Tuple> {
private BytesWritable bytesKey;
private Tuple tupleRow;
private Object javaObj;
@Override
public void map(LongWritable key, Text value, Context context)
throws IOException, InterruptedException {
// value should contain "word count"
String[] wdct = value.toString().split(" ");
if (wdct.length != 2) {
// LOG the error
return;
}
byte[] word = wdct[0].getBytes();
bytesKey.set(word, 0, word.length);
System.out.println("word: " + new String(word));
tupleRow.set(0, new String(word));
tupleRow.set(1, Integer.parseInt(wdct[1]));
System.out.println("count: " + Integer.parseInt(wdct[1]));
// This key has to be created by user
/*
* Tuple userKey = new DefaultTuple(); userKey.append(new String(word));
* userKey.append(Integer.parseInt(wdct[1]));
*/
System.out.println("in map, sortkey: " + sortKey);
Tuple userKey = new ZebraTuple();
if (sortKey.equalsIgnoreCase("word,count")) {
userKey.append(new String(word));
userKey.append(Integer.parseInt(wdct[1]));
}
if (sortKey.equalsIgnoreCase("count")) {
userKey.append(Integer.parseInt(wdct[1]));
}
if (sortKey.equalsIgnoreCase("word")) {
userKey.append(new String(word));
}
try {
/* New M/R Interface */
/* Converts user key to zebra BytesWritable key */
/* using sort key expr tree */
/* Returns a java base object */
/* Done for each user key */
bytesKey = BasicTableOutputFormat.getSortKey(javaObj, userKey);
} catch (Exception e) {
}
context.write(bytesKey, tupleRow);
}
@Override
public void setup(Context context) {
bytesKey = new BytesWritable();
sortKey = context.getConfiguration().get("sortKey");
try {
Schema outSchema = BasicTableOutputFormat.getSchema(context);
tupleRow = TypesUtils.createTuple(outSchema);
javaObj = BasicTableOutputFormat.getSortKeyGenerator(context);
} catch (IOException e) {
throw new RuntimeException(e);
} catch (org.apache.hadoop.zebra.parser.ParseException e) {
throw new RuntimeException(e);
}
}
}
static class ReduceClass extends
Reducer<BytesWritable, Tuple, BytesWritable, Tuple> {
Tuple outRow;
public void reduce(BytesWritable key, Iterator<Tuple> values, Context context)
throws IOException, InterruptedException {
try {
for (; values.hasNext();) {
context.write(key, values.next());
}
} catch (ExecException e) {
e.printStackTrace();
}
}
}
static class OutputPartitionerClass extends ZebraOutputPartition {
@Override
public int getOutputPartition(BytesWritable key, Tuple value) throws ExecException {
return 0;
}
}
public void runMR(String myMultiLocs, String sortKey) throws ParseException,
IOException, Exception, org.apache.hadoop.zebra.parser.ParseException {
Job job = new Job(conf);
job.setJobName("TestMultipleOutputs4");
job.setJarByClass(TestMultipleOutputs4.class);
Configuration conf = job.getConfiguration();
conf.set("table.output.tfile.compression", "gz");
conf.set("sortKey", sortKey);
// input settings
job.setInputFormatClass(TextInputFormat.class);
job.setMapperClass(TestMultipleOutputs4.MapClass.class);
job.setMapOutputKeyClass(BytesWritable.class);
job.setMapOutputValueClass(ZebraTuple.class);
FileInputFormat.setInputPaths(job, inputPath);
// TODO: find a replacement
//job.setNumMapTasks(1);
// output settings
job.setOutputFormatClass(BasicTableOutputFormat.class);
BasicTableOutputFormat.setMultipleOutputs(job, myMultiLocs,
TestMultipleOutputs4.OutputPartitionerClass.class);
// set the logical schema with 2 columns
BasicTableOutputFormat.setSchema(job, "word:string, count:int");
// for demo purposes, create 2 physical column groups
BasicTableOutputFormat.setStorageHint(job, "[word];[count]");
BasicTableOutputFormat.setSortInfo(job, sortKey);
System.out.println("in runMR, sortkey: " + sortKey);
// set map-only job.
job.setNumReduceTasks(1);
job.submit();
job.waitForCompletion( true );
BasicTableOutputFormat.close( job );
}
public int run (String[] args) throws Exception {
TestMultipleOutputs4 test = new TestMultipleOutputs4();
TestMultipleOutputs4.setUpOnce();
test.test1();
return 0;
}
public static void main(String[] args) throws Exception {
conf = new Configuration();
int res = ToolRunner.run(conf, new TestMultipleOutputs4(), args);
System.out.println("PASS");
System.exit(res);
}
}