org.apache.hadoop.mapred.lib.db
Class DBConfiguration

java.lang.Object
  extended by org.apache.hadoop.mapred.lib.db.DBConfiguration

public class DBConfiguration
extends Object

A container for configuration property names for jobs with DB input/output.
The job can be configured using the static methods in this class, DBInputFormat, and DBOutputFormat.

Alternatively, the properties can be set in the configuration with proper values.

See Also:
configureDB(JobConf, String, String, String, String), DBInputFormat.setInput(JobConf, Class, String, String), DBInputFormat.setInput(JobConf, Class, String, String, String, String...), DBOutputFormat.setOutput(JobConf, String, String...)

Field Summary
static String DRIVER_CLASS_PROPERTY
          The JDBC Driver class name
static String INPUT_CLASS_PROPERTY
          Class name implementing DBWritable which will hold input tuples
static String INPUT_CONDITIONS_PROPERTY
          WHERE clause in the input SELECT statement
static String INPUT_COUNT_QUERY
          Input query to get the count of records
static String INPUT_FIELD_NAMES_PROPERTY
          Field names in the Input table
static String INPUT_ORDER_BY_PROPERTY
          ORDER BY clause in the input SELECT statement
static String INPUT_QUERY
          Whole input query, exluding LIMIT...OFFSET
static String INPUT_TABLE_NAME_PROPERTY
          Input table name
static String OUTPUT_FIELD_NAMES_PROPERTY
          Field names in the Output table
static String OUTPUT_TABLE_NAME_PROPERTY
          Output table name
static String PASSWORD_PROPERTY
          Password to access the database
static String URL_PROPERTY
          JDBC Database access URL
static String USERNAME_PROPERTY
          User name to access the database
 
Method Summary
static void configureDB(JobConf job, String driverClass, String dbUrl)
          Sets the DB access related fields in the JobConf.
static void configureDB(JobConf job, String driverClass, String dbUrl, String userName, String passwd)
          Sets the DB access related fields in the JobConf.
 
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
 

Field Detail

DRIVER_CLASS_PROPERTY

public static final String DRIVER_CLASS_PROPERTY
The JDBC Driver class name

See Also:
Constant Field Values

URL_PROPERTY

public static final String URL_PROPERTY
JDBC Database access URL

See Also:
Constant Field Values

USERNAME_PROPERTY

public static final String USERNAME_PROPERTY
User name to access the database

See Also:
Constant Field Values

PASSWORD_PROPERTY

public static final String PASSWORD_PROPERTY
Password to access the database

See Also:
Constant Field Values

INPUT_TABLE_NAME_PROPERTY

public static final String INPUT_TABLE_NAME_PROPERTY
Input table name

See Also:
Constant Field Values

INPUT_FIELD_NAMES_PROPERTY

public static final String INPUT_FIELD_NAMES_PROPERTY
Field names in the Input table

See Also:
Constant Field Values

INPUT_CONDITIONS_PROPERTY

public static final String INPUT_CONDITIONS_PROPERTY
WHERE clause in the input SELECT statement

See Also:
Constant Field Values

INPUT_ORDER_BY_PROPERTY

public static final String INPUT_ORDER_BY_PROPERTY
ORDER BY clause in the input SELECT statement

See Also:
Constant Field Values

INPUT_QUERY

public static final String INPUT_QUERY
Whole input query, exluding LIMIT...OFFSET

See Also:
Constant Field Values

INPUT_COUNT_QUERY

public static final String INPUT_COUNT_QUERY
Input query to get the count of records

See Also:
Constant Field Values

INPUT_CLASS_PROPERTY

public static final String INPUT_CLASS_PROPERTY
Class name implementing DBWritable which will hold input tuples

See Also:
Constant Field Values

OUTPUT_TABLE_NAME_PROPERTY

public static final String OUTPUT_TABLE_NAME_PROPERTY
Output table name

See Also:
Constant Field Values

OUTPUT_FIELD_NAMES_PROPERTY

public static final String OUTPUT_FIELD_NAMES_PROPERTY
Field names in the Output table

See Also:
Constant Field Values
Method Detail

configureDB

public static void configureDB(JobConf job,
                               String driverClass,
                               String dbUrl,
                               String userName,
                               String passwd)
Sets the DB access related fields in the JobConf.

Parameters:
job - the job
driverClass - JDBC Driver class name
dbUrl - JDBC DB access URL.
userName - DB access username
passwd - DB access passwd

configureDB

public static void configureDB(JobConf job,
                               String driverClass,
                               String dbUrl)
Sets the DB access related fields in the JobConf.

Parameters:
job - the job
driverClass - JDBC Driver class name
dbUrl - JDBC DB access URL.


Copyright © 2009 The Apache Software Foundation