co.nubetech.hiho.job.ExportDelimitedToDB.java Source code

Java tutorial

Introduction

Here is the source code for co.nubetech.hiho.job.ExportDelimitedToDB.java

Source

/**
 * Copyright 2010 Nube Technologies
 * 
 * Licensed 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 co.nubetech.hiho.job;

import java.io.IOException;

import org.apache.hadoop.conf.Configuration;
import org.apache.hadoop.conf.Configured;
import org.apache.hadoop.fs.Path;
import org.apache.hadoop.io.NullWritable;
import org.apache.hadoop.mapreduce.Job;
import org.apache.hadoop.mapreduce.lib.input.TextInputFormat;
import org.apache.hadoop.util.Tool;
import org.apache.hadoop.util.ToolRunner;

import co.nubetech.apache.hadoop.DBOutputFormat;
import co.nubetech.hiho.mapreduce.DelimitedLoadMapper;

public class ExportDelimitedToDB extends Configured implements Tool {

    public int run(String[] args) throws IOException {
        Configuration conf = getConf();
        Job job = new Job(conf);
        job.setJobName("MySQLBulkLoading");
        job.setMapperClass(DelimitedLoadMapper.class);
        job.setJarByClass(DelimitedLoadMapper.class);
        job.setNumReduceTasks(0);

        job.setInputFormatClass(TextInputFormat.class);
        TextInputFormat.addInputPath(job, new Path(args[0]));

        job.setMapOutputKeyClass(NullWritable.class);
        job.setMapOutputValueClass(NullWritable.class);

        job.setOutputFormatClass(DBOutputFormat.class);
        int ret = 0;

        try {
            ret = job.waitForCompletion(true) ? 0 : 1;
        } catch (Exception e) {
            e.printStackTrace();
        }
        return ret;

    }

    public static void main(String[] args) throws Exception {

        int res = ToolRunner.run(new Configuration(), new ExportDelimitedToDB(), args);
        System.exit(res);
    }

}