Example usage for org.apache.hadoop.mapreduce.lib.db DBConfiguration setInputCountQuery

Introduction

In this page you can find the example usage for org.apache.hadoop.mapreduce.lib.db DBConfiguration setInputCountQuery.

Prototype

public void setInputCountQuery(String query) 

Source Link

Usage

From source file:com.cloudera.sqoop.mapreduce.db.DBInputFormat.java

License:Apache License

/**
 * Initializes the map-part of the job with the appropriate input settings.
 *
 * @param job The map-reduce job/*from  w w w . j a  v  a2  s.c o  m*/
 * @param inputClass the class object implementing DBWritable, which is the
 * Java object holding tuple fields.
 * @param inputQuery the input query to select fields. Example :
 * "SELECT f1, f2, f3 FROM Mytable ORDER BY f1"
 * @param inputCountQuery the input query that returns
 * the number of records in the table.
 * Example : "SELECT COUNT(f1) FROM Mytable"
 * @see #setInput(Job, Class, String, String, String, String...)
 */
public static void setInput(Job job, Class<? extends DBWritable> inputClass, String inputQuery,
        String inputCountQuery) {
    job.setInputFormatClass(DBInputFormat.class);
    DBConfiguration dbConf = new DBConfiguration(job.getConfiguration());
    dbConf.setInputClass(inputClass);
    dbConf.setInputQuery(inputQuery);
    dbConf.setInputCountQuery(inputCountQuery);
}

---