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

Introduction

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

Source

/**
 * Copyright 2011 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 org.apache.hadoop.conf.Configuration;
import org.apache.hadoop.conf.Configured;
import org.apache.hadoop.fs.Path;
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.DBConfiguration;
import co.nubetech.apache.hadoop.MRJobConfig;
import co.nubetech.hiho.common.HIHOConf;
import co.nubetech.hiho.common.HIHOException;
import co.nubetech.hiho.mapreduce.GenericDBLoadDataMapper;
import co.nubetech.hiho.mapreduce.lib.db.GenericDBOutputFormat;

public class ExportToDB extends Configured implements Tool {

    private String inputPath = null;
    private String tableName = null;
    private String columnNames = null;

    public void populateConfiguration(String[] args, Configuration conf) {
        for (int i = 0; i < args.length - 1; i++) {
            if ("-jdbcDriver".equals(args[i])) {
                conf.set(DBConfiguration.DRIVER_CLASS_PROPERTY, args[++i]);
            } else if ("-jdbcUrl".equals(args[i])) {
                conf.set(DBConfiguration.URL_PROPERTY, args[++i]);
            } else if ("-jdbcUsername".equals(args[i])) {
                conf.set(DBConfiguration.USERNAME_PROPERTY, args[++i]);
            } else if ("-jdbcPassword".equals(args[i])) {
                conf.set(DBConfiguration.PASSWORD_PROPERTY, args[++i]);
            } else if ("-delimiter".equals(args[i])) {
                conf.set(HIHOConf.INPUT_OUTPUT_DELIMITER, args[++i]);
            } else if ("-numberOfMappers".equals(args[i])) {
                conf.set(HIHOConf.NUMBER_MAPPERS, args[++i]);
            } else if ("-tableName".equals(args[i])) {
                tableName = args[++i];
            } else if ("-columnNames".equals(args[i])) {
                columnNames = args[++i];
            } else if ("-inputPath".equals(args[i])) {
                inputPath = args[++i];
            }
        }
    }

    public void checkMandatoryConfs(Configuration conf) throws HIHOException {
        if (conf.get(DBConfiguration.DRIVER_CLASS_PROPERTY) == null) {
            throw new HIHOException("JDBC driver configuration is not specified,please specify JDBC driver class.");
        }
        if (conf.get(DBConfiguration.URL_PROPERTY) == null) {
            throw new HIHOException("JDBC url path configuration is empty,please specify JDBC url path.");
        }
        if (!conf.get(DBConfiguration.DRIVER_CLASS_PROPERTY).contains("hsqldb")) {
            if (conf.get(DBConfiguration.USERNAME_PROPERTY) == null) {
                throw new HIHOException("JDBC user name configuration is empty,please specify JDBC user name.");
            }
            if (conf.get(DBConfiguration.PASSWORD_PROPERTY) == null) {
                throw new HIHOException("JDBC password configuration is empty,please specify JDBC password.");
            }
        }
        if (conf.get(HIHOConf.INPUT_OUTPUT_DELIMITER) == null) {
            throw new HIHOException("The provided delimiter is empty, please specify delimiter.");
        }
        if (conf.get(HIHOConf.NUMBER_MAPPERS) == null) {
            throw new HIHOException("The provided number of mappers is empty, please specify number of mappers.");
        }
        if (inputPath == null) {
            throw new HIHOException("The provided input path is empty, please specify inputPath.");
        }
        if (tableName == null) {
            throw new HIHOException("The provided table name is empty, please specify tableName.");
        }
        if (columnNames == null) {
            throw new HIHOException("The provided column name is empty, please specify columnName.");
        }
    }

    public int run(String[] args) throws Exception {
        Configuration conf = getConf();
        populateConfiguration(args, conf);
        try {
            checkMandatoryConfs(conf);
        } catch (HIHOException e1) {
            e1.printStackTrace();
            throw new Exception(e1);
        }
        Job job = new Job(conf);
        job.getConfiguration().setInt(MRJobConfig.NUM_MAPS, conf.getInt(HIHOConf.NUMBER_MAPPERS, 1));
        job.setJobName("HihoDBExport");

        job.setMapperClass(GenericDBLoadDataMapper.class);
        job.setJarByClass(ExportToDB.class);
        job.setNumReduceTasks(0);
        job.setInputFormatClass(TextInputFormat.class);
        TextInputFormat.addInputPath(job, new Path(inputPath));
        GenericDBOutputFormat.setOutput(job, tableName, columnNames);

        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 ExportToDB(), args);
        System.exit(res);
    }

}