src/contrib/vertica/src/java/org/apache/hadoop/vertica/VerticaStreamingOutput.java

/**
 * 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.vertica;

import java.io.IOException;
import java.sql.Connection;

import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;
import org.apache.hadoop.conf.Configuration;
import org.apache.hadoop.io.Text;
import org.apache.hadoop.mapreduce.JobContext;
import org.apache.hadoop.mapreduce.OutputCommitter;
import org.apache.hadoop.mapreduce.OutputFormat;
import org.apache.hadoop.mapreduce.RecordWriter;
import org.apache.hadoop.mapreduce.TaskAttemptContext;
import org.apache.hadoop.mapreduce.lib.output.FileOutputCommitter;
import org.apache.hadoop.mapreduce.lib.output.FileOutputFormat;

public class VerticaStreamingOutput extends OutputFormat<Text, Text> {
  private static final Log LOG = LogFactory
      .getLog(VerticaStreamingOutput.class);

  String delimiter = VerticaConfiguration.DELIMITER;
  String terminator = VerticaConfiguration.RECORD_TERMINATER;

  public void checkOutputSpecs(JobContext context) throws IOException {
    Configuration conf = context.getConfiguration();
    VerticaUtil.checkOutputSpecs(conf);
    VerticaConfiguration vtconfig = new VerticaConfiguration(conf);
    delimiter = vtconfig.getOutputDelimiter();
    terminator = vtconfig.getOutputRecordTerminator();
    LOG.debug("Vertica output using delimiter '" + delimiter
        + "' and terminator '" + terminator + "'");
  }

  public RecordWriter<Text, Text> getRecordWriter(TaskAttemptContext context)
      throws IOException {
    Configuration conf = context.getConfiguration();
    VerticaConfiguration vtconfig = new VerticaConfiguration(conf);

    String name = context.getJobName();
    delimiter = vtconfig.getOutputDelimiter();
    terminator = vtconfig.getOutputRecordTerminator();

    // TODO: use explicit date formats
    String table = vtconfig.getOutputTableName();
    String copyStmt = "COPY " + table + " FROM STDIN" + " DELIMITER '"
        + delimiter + "' RECORD TERMINATOR '" + terminator + "' STREAM NAME '"
        + name + "' DIRECT";

    try {
      Connection conn = vtconfig.getConnection(true);
      return new VerticaStreamingRecordWriter(conn, copyStmt, table);
    } catch (Exception e) {
      throw new IOException(e);
    }
  }

  public OutputCommitter getOutputCommitter(TaskAttemptContext context)
      throws IOException, InterruptedException {
    return new FileOutputCommitter(FileOutputFormat.getOutputPath(context),
        context);
  }
}