ExportToDB.java

/**
 * 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.hiho.mapreduce.lib.db.apache.DBConfiguration;
import co.nubetech.hiho.mapreduce.lib.db.apache.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);
	}

}