1 | <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> |
---|
2 | <!--NewPage--> |
---|
3 | <HTML> |
---|
4 | <HEAD> |
---|
5 | <!-- Generated by javadoc (build 1.6.0_07) on Tue Sep 01 20:56:57 UTC 2009 --> |
---|
6 | <TITLE> |
---|
7 | DBConfiguration (Hadoop 0.20.1 API) |
---|
8 | </TITLE> |
---|
9 | |
---|
10 | <META NAME="date" CONTENT="2009-09-01"> |
---|
11 | |
---|
12 | <LINK REL ="stylesheet" TYPE="text/css" HREF="../../../../../../stylesheet.css" TITLE="Style"> |
---|
13 | |
---|
14 | <SCRIPT type="text/javascript"> |
---|
15 | function windowTitle() |
---|
16 | { |
---|
17 | if (location.href.indexOf('is-external=true') == -1) { |
---|
18 | parent.document.title="DBConfiguration (Hadoop 0.20.1 API)"; |
---|
19 | } |
---|
20 | } |
---|
21 | </SCRIPT> |
---|
22 | <NOSCRIPT> |
---|
23 | </NOSCRIPT> |
---|
24 | |
---|
25 | </HEAD> |
---|
26 | |
---|
27 | <BODY BGCOLOR="white" onload="windowTitle();"> |
---|
28 | <HR> |
---|
29 | |
---|
30 | |
---|
31 | <!-- ========= START OF TOP NAVBAR ======= --> |
---|
32 | <A NAME="navbar_top"><!-- --></A> |
---|
33 | <A HREF="#skip-navbar_top" title="Skip navigation links"></A> |
---|
34 | <TABLE BORDER="0" WIDTH="100%" CELLPADDING="1" CELLSPACING="0" SUMMARY=""> |
---|
35 | <TR> |
---|
36 | <TD COLSPAN=2 BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> |
---|
37 | <A NAME="navbar_top_firstrow"><!-- --></A> |
---|
38 | <TABLE BORDER="0" CELLPADDING="0" CELLSPACING="3" SUMMARY=""> |
---|
39 | <TR ALIGN="center" VALIGN="top"> |
---|
40 | <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="../../../../../../overview-summary.html"><FONT CLASS="NavBarFont1"><B>Overview</B></FONT></A> </TD> |
---|
41 | <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="package-summary.html"><FONT CLASS="NavBarFont1"><B>Package</B></FONT></A> </TD> |
---|
42 | <TD BGCOLOR="#FFFFFF" CLASS="NavBarCell1Rev"> <FONT CLASS="NavBarFont1Rev"><B>Class</B></FONT> </TD> |
---|
43 | <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="class-use/DBConfiguration.html"><FONT CLASS="NavBarFont1"><B>Use</B></FONT></A> </TD> |
---|
44 | <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="package-tree.html"><FONT CLASS="NavBarFont1"><B>Tree</B></FONT></A> </TD> |
---|
45 | <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="../../../../../../deprecated-list.html"><FONT CLASS="NavBarFont1"><B>Deprecated</B></FONT></A> </TD> |
---|
46 | <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="../../../../../../index-all.html"><FONT CLASS="NavBarFont1"><B>Index</B></FONT></A> </TD> |
---|
47 | <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="../../../../../../help-doc.html"><FONT CLASS="NavBarFont1"><B>Help</B></FONT></A> </TD> |
---|
48 | </TR> |
---|
49 | </TABLE> |
---|
50 | </TD> |
---|
51 | <TD ALIGN="right" VALIGN="top" ROWSPAN=3><EM> |
---|
52 | </EM> |
---|
53 | </TD> |
---|
54 | </TR> |
---|
55 | |
---|
56 | <TR> |
---|
57 | <TD BGCOLOR="white" CLASS="NavBarCell2"><FONT SIZE="-2"> |
---|
58 | PREV CLASS |
---|
59 | <A HREF="../../../../../../org/apache/hadoop/mapred/lib/db/DBInputFormat.html" title="class in org.apache.hadoop.mapred.lib.db"><B>NEXT CLASS</B></A></FONT></TD> |
---|
60 | <TD BGCOLOR="white" CLASS="NavBarCell2"><FONT SIZE="-2"> |
---|
61 | <A HREF="../../../../../../index.html?org/apache/hadoop/mapred/lib/db/DBConfiguration.html" target="_top"><B>FRAMES</B></A> |
---|
62 | <A HREF="DBConfiguration.html" target="_top"><B>NO FRAMES</B></A> |
---|
63 | <SCRIPT type="text/javascript"> |
---|
64 | <!-- |
---|
65 | if(window==top) { |
---|
66 | document.writeln('<A HREF="../../../../../../allclasses-noframe.html"><B>All Classes</B></A>'); |
---|
67 | } |
---|
68 | //--> |
---|
69 | </SCRIPT> |
---|
70 | <NOSCRIPT> |
---|
71 | <A HREF="../../../../../../allclasses-noframe.html"><B>All Classes</B></A> |
---|
72 | </NOSCRIPT> |
---|
73 | |
---|
74 | |
---|
75 | </FONT></TD> |
---|
76 | </TR> |
---|
77 | <TR> |
---|
78 | <TD VALIGN="top" CLASS="NavBarCell3"><FONT SIZE="-2"> |
---|
79 | SUMMARY: NESTED | <A HREF="#field_summary">FIELD</A> | CONSTR | <A HREF="#method_summary">METHOD</A></FONT></TD> |
---|
80 | <TD VALIGN="top" CLASS="NavBarCell3"><FONT SIZE="-2"> |
---|
81 | DETAIL: <A HREF="#field_detail">FIELD</A> | CONSTR | <A HREF="#method_detail">METHOD</A></FONT></TD> |
---|
82 | </TR> |
---|
83 | </TABLE> |
---|
84 | <A NAME="skip-navbar_top"></A> |
---|
85 | <!-- ========= END OF TOP NAVBAR ========= --> |
---|
86 | |
---|
87 | <HR> |
---|
88 | <!-- ======== START OF CLASS DATA ======== --> |
---|
89 | <H2> |
---|
90 | <FONT SIZE="-1"> |
---|
91 | org.apache.hadoop.mapred.lib.db</FONT> |
---|
92 | <BR> |
---|
93 | Class DBConfiguration</H2> |
---|
94 | <PRE> |
---|
95 | <A HREF="http://java.sun.com/javase/6/docs/api/java/lang/Object.html?is-external=true" title="class or interface in java.lang">java.lang.Object</A> |
---|
96 | <IMG SRC="../../../../../../resources/inherit.gif" ALT="extended by "><B>org.apache.hadoop.mapred.lib.db.DBConfiguration</B> |
---|
97 | </PRE> |
---|
98 | <HR> |
---|
99 | <DL> |
---|
100 | <DT><PRE>public class <B>DBConfiguration</B><DT>extends <A HREF="http://java.sun.com/javase/6/docs/api/java/lang/Object.html?is-external=true" title="class or interface in java.lang">Object</A></DL> |
---|
101 | </PRE> |
---|
102 | |
---|
103 | <P> |
---|
104 | A container for configuration property names for jobs with DB input/output. |
---|
105 | <br> |
---|
106 | The job can be configured using the static methods in this class, |
---|
107 | <A HREF="../../../../../../org/apache/hadoop/mapred/lib/db/DBInputFormat.html" title="class in org.apache.hadoop.mapred.lib.db"><CODE>DBInputFormat</CODE></A>, and <A HREF="../../../../../../org/apache/hadoop/mapred/lib/db/DBOutputFormat.html" title="class in org.apache.hadoop.mapred.lib.db"><CODE>DBOutputFormat</CODE></A>. |
---|
108 | <p> |
---|
109 | Alternatively, the properties can be set in the configuration with proper |
---|
110 | values. |
---|
111 | <P> |
---|
112 | |
---|
113 | <P> |
---|
114 | <DL> |
---|
115 | <DT><B>See Also:</B><DD><A HREF="../../../../../../org/apache/hadoop/mapred/lib/db/DBConfiguration.html#configureDB(org.apache.hadoop.mapred.JobConf, java.lang.String, java.lang.String, java.lang.String, java.lang.String)"><CODE>configureDB(JobConf, String, String, String, String)</CODE></A>, |
---|
116 | <A HREF="../../../../../../org/apache/hadoop/mapred/lib/db/DBInputFormat.html#setInput(org.apache.hadoop.mapred.JobConf, java.lang.Class, java.lang.String, java.lang.String)"><CODE>DBInputFormat.setInput(JobConf, Class, String, String)</CODE></A>, |
---|
117 | <A HREF="../../../../../../org/apache/hadoop/mapred/lib/db/DBInputFormat.html#setInput(org.apache.hadoop.mapred.JobConf, java.lang.Class, java.lang.String, java.lang.String, java.lang.String, java.lang.String...)"><CODE>DBInputFormat.setInput(JobConf, Class, String, String, String, String...)</CODE></A>, |
---|
118 | <A HREF="../../../../../../org/apache/hadoop/mapred/lib/db/DBOutputFormat.html#setOutput(org.apache.hadoop.mapred.JobConf, java.lang.String, java.lang.String...)"><CODE>DBOutputFormat.setOutput(JobConf, String, String...)</CODE></A></DL> |
---|
119 | <HR> |
---|
120 | |
---|
121 | <P> |
---|
122 | <!-- =========== FIELD SUMMARY =========== --> |
---|
123 | |
---|
124 | <A NAME="field_summary"><!-- --></A> |
---|
125 | <TABLE BORDER="1" WIDTH="100%" CELLPADDING="3" CELLSPACING="0" SUMMARY=""> |
---|
126 | <TR BGCOLOR="#CCCCFF" CLASS="TableHeadingColor"> |
---|
127 | <TH ALIGN="left" COLSPAN="2"><FONT SIZE="+2"> |
---|
128 | <B>Field Summary</B></FONT></TH> |
---|
129 | </TR> |
---|
130 | <TR BGCOLOR="white" CLASS="TableRowColor"> |
---|
131 | <TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"> |
---|
132 | <CODE>static <A HREF="http://java.sun.com/javase/6/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</A></CODE></FONT></TD> |
---|
133 | <TD><CODE><B><A HREF="../../../../../../org/apache/hadoop/mapred/lib/db/DBConfiguration.html#DRIVER_CLASS_PROPERTY">DRIVER_CLASS_PROPERTY</A></B></CODE> |
---|
134 | |
---|
135 | <BR> |
---|
136 | The JDBC Driver class name</TD> |
---|
137 | </TR> |
---|
138 | <TR BGCOLOR="white" CLASS="TableRowColor"> |
---|
139 | <TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"> |
---|
140 | <CODE>static <A HREF="http://java.sun.com/javase/6/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</A></CODE></FONT></TD> |
---|
141 | <TD><CODE><B><A HREF="../../../../../../org/apache/hadoop/mapred/lib/db/DBConfiguration.html#INPUT_CLASS_PROPERTY">INPUT_CLASS_PROPERTY</A></B></CODE> |
---|
142 | |
---|
143 | <BR> |
---|
144 | Class name implementing DBWritable which will hold input tuples</TD> |
---|
145 | </TR> |
---|
146 | <TR BGCOLOR="white" CLASS="TableRowColor"> |
---|
147 | <TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"> |
---|
148 | <CODE>static <A HREF="http://java.sun.com/javase/6/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</A></CODE></FONT></TD> |
---|
149 | <TD><CODE><B><A HREF="../../../../../../org/apache/hadoop/mapred/lib/db/DBConfiguration.html#INPUT_CONDITIONS_PROPERTY">INPUT_CONDITIONS_PROPERTY</A></B></CODE> |
---|
150 | |
---|
151 | <BR> |
---|
152 | WHERE clause in the input SELECT statement</TD> |
---|
153 | </TR> |
---|
154 | <TR BGCOLOR="white" CLASS="TableRowColor"> |
---|
155 | <TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"> |
---|
156 | <CODE>static <A HREF="http://java.sun.com/javase/6/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</A></CODE></FONT></TD> |
---|
157 | <TD><CODE><B><A HREF="../../../../../../org/apache/hadoop/mapred/lib/db/DBConfiguration.html#INPUT_COUNT_QUERY">INPUT_COUNT_QUERY</A></B></CODE> |
---|
158 | |
---|
159 | <BR> |
---|
160 | Input query to get the count of records</TD> |
---|
161 | </TR> |
---|
162 | <TR BGCOLOR="white" CLASS="TableRowColor"> |
---|
163 | <TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"> |
---|
164 | <CODE>static <A HREF="http://java.sun.com/javase/6/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</A></CODE></FONT></TD> |
---|
165 | <TD><CODE><B><A HREF="../../../../../../org/apache/hadoop/mapred/lib/db/DBConfiguration.html#INPUT_FIELD_NAMES_PROPERTY">INPUT_FIELD_NAMES_PROPERTY</A></B></CODE> |
---|
166 | |
---|
167 | <BR> |
---|
168 | Field names in the Input table</TD> |
---|
169 | </TR> |
---|
170 | <TR BGCOLOR="white" CLASS="TableRowColor"> |
---|
171 | <TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"> |
---|
172 | <CODE>static <A HREF="http://java.sun.com/javase/6/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</A></CODE></FONT></TD> |
---|
173 | <TD><CODE><B><A HREF="../../../../../../org/apache/hadoop/mapred/lib/db/DBConfiguration.html#INPUT_ORDER_BY_PROPERTY">INPUT_ORDER_BY_PROPERTY</A></B></CODE> |
---|
174 | |
---|
175 | <BR> |
---|
176 | ORDER BY clause in the input SELECT statement</TD> |
---|
177 | </TR> |
---|
178 | <TR BGCOLOR="white" CLASS="TableRowColor"> |
---|
179 | <TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"> |
---|
180 | <CODE>static <A HREF="http://java.sun.com/javase/6/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</A></CODE></FONT></TD> |
---|
181 | <TD><CODE><B><A HREF="../../../../../../org/apache/hadoop/mapred/lib/db/DBConfiguration.html#INPUT_QUERY">INPUT_QUERY</A></B></CODE> |
---|
182 | |
---|
183 | <BR> |
---|
184 | Whole input query, exluding LIMIT...OFFSET</TD> |
---|
185 | </TR> |
---|
186 | <TR BGCOLOR="white" CLASS="TableRowColor"> |
---|
187 | <TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"> |
---|
188 | <CODE>static <A HREF="http://java.sun.com/javase/6/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</A></CODE></FONT></TD> |
---|
189 | <TD><CODE><B><A HREF="../../../../../../org/apache/hadoop/mapred/lib/db/DBConfiguration.html#INPUT_TABLE_NAME_PROPERTY">INPUT_TABLE_NAME_PROPERTY</A></B></CODE> |
---|
190 | |
---|
191 | <BR> |
---|
192 | Input table name</TD> |
---|
193 | </TR> |
---|
194 | <TR BGCOLOR="white" CLASS="TableRowColor"> |
---|
195 | <TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"> |
---|
196 | <CODE>static <A HREF="http://java.sun.com/javase/6/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</A></CODE></FONT></TD> |
---|
197 | <TD><CODE><B><A HREF="../../../../../../org/apache/hadoop/mapred/lib/db/DBConfiguration.html#OUTPUT_FIELD_NAMES_PROPERTY">OUTPUT_FIELD_NAMES_PROPERTY</A></B></CODE> |
---|
198 | |
---|
199 | <BR> |
---|
200 | Field names in the Output table</TD> |
---|
201 | </TR> |
---|
202 | <TR BGCOLOR="white" CLASS="TableRowColor"> |
---|
203 | <TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"> |
---|
204 | <CODE>static <A HREF="http://java.sun.com/javase/6/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</A></CODE></FONT></TD> |
---|
205 | <TD><CODE><B><A HREF="../../../../../../org/apache/hadoop/mapred/lib/db/DBConfiguration.html#OUTPUT_TABLE_NAME_PROPERTY">OUTPUT_TABLE_NAME_PROPERTY</A></B></CODE> |
---|
206 | |
---|
207 | <BR> |
---|
208 | Output table name</TD> |
---|
209 | </TR> |
---|
210 | <TR BGCOLOR="white" CLASS="TableRowColor"> |
---|
211 | <TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"> |
---|
212 | <CODE>static <A HREF="http://java.sun.com/javase/6/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</A></CODE></FONT></TD> |
---|
213 | <TD><CODE><B><A HREF="../../../../../../org/apache/hadoop/mapred/lib/db/DBConfiguration.html#PASSWORD_PROPERTY">PASSWORD_PROPERTY</A></B></CODE> |
---|
214 | |
---|
215 | <BR> |
---|
216 | Password to access the database</TD> |
---|
217 | </TR> |
---|
218 | <TR BGCOLOR="white" CLASS="TableRowColor"> |
---|
219 | <TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"> |
---|
220 | <CODE>static <A HREF="http://java.sun.com/javase/6/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</A></CODE></FONT></TD> |
---|
221 | <TD><CODE><B><A HREF="../../../../../../org/apache/hadoop/mapred/lib/db/DBConfiguration.html#URL_PROPERTY">URL_PROPERTY</A></B></CODE> |
---|
222 | |
---|
223 | <BR> |
---|
224 | JDBC Database access URL</TD> |
---|
225 | </TR> |
---|
226 | <TR BGCOLOR="white" CLASS="TableRowColor"> |
---|
227 | <TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"> |
---|
228 | <CODE>static <A HREF="http://java.sun.com/javase/6/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</A></CODE></FONT></TD> |
---|
229 | <TD><CODE><B><A HREF="../../../../../../org/apache/hadoop/mapred/lib/db/DBConfiguration.html#USERNAME_PROPERTY">USERNAME_PROPERTY</A></B></CODE> |
---|
230 | |
---|
231 | <BR> |
---|
232 | User name to access the database</TD> |
---|
233 | </TR> |
---|
234 | </TABLE> |
---|
235 | |
---|
236 | <!-- ========== METHOD SUMMARY =========== --> |
---|
237 | |
---|
238 | <A NAME="method_summary"><!-- --></A> |
---|
239 | <TABLE BORDER="1" WIDTH="100%" CELLPADDING="3" CELLSPACING="0" SUMMARY=""> |
---|
240 | <TR BGCOLOR="#CCCCFF" CLASS="TableHeadingColor"> |
---|
241 | <TH ALIGN="left" COLSPAN="2"><FONT SIZE="+2"> |
---|
242 | <B>Method Summary</B></FONT></TH> |
---|
243 | </TR> |
---|
244 | <TR BGCOLOR="white" CLASS="TableRowColor"> |
---|
245 | <TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"> |
---|
246 | <CODE>static void</CODE></FONT></TD> |
---|
247 | <TD><CODE><B><A HREF="../../../../../../org/apache/hadoop/mapred/lib/db/DBConfiguration.html#configureDB(org.apache.hadoop.mapred.JobConf, java.lang.String, java.lang.String)">configureDB</A></B>(<A HREF="../../../../../../org/apache/hadoop/mapred/JobConf.html" title="class in org.apache.hadoop.mapred">JobConf</A> job, |
---|
248 | <A HREF="http://java.sun.com/javase/6/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</A> driverClass, |
---|
249 | <A HREF="http://java.sun.com/javase/6/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</A> dbUrl)</CODE> |
---|
250 | |
---|
251 | <BR> |
---|
252 | Sets the DB access related fields in the JobConf.</TD> |
---|
253 | </TR> |
---|
254 | <TR BGCOLOR="white" CLASS="TableRowColor"> |
---|
255 | <TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"> |
---|
256 | <CODE>static void</CODE></FONT></TD> |
---|
257 | <TD><CODE><B><A HREF="../../../../../../org/apache/hadoop/mapred/lib/db/DBConfiguration.html#configureDB(org.apache.hadoop.mapred.JobConf, java.lang.String, java.lang.String, java.lang.String, java.lang.String)">configureDB</A></B>(<A HREF="../../../../../../org/apache/hadoop/mapred/JobConf.html" title="class in org.apache.hadoop.mapred">JobConf</A> job, |
---|
258 | <A HREF="http://java.sun.com/javase/6/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</A> driverClass, |
---|
259 | <A HREF="http://java.sun.com/javase/6/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</A> dbUrl, |
---|
260 | <A HREF="http://java.sun.com/javase/6/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</A> userName, |
---|
261 | <A HREF="http://java.sun.com/javase/6/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</A> passwd)</CODE> |
---|
262 | |
---|
263 | <BR> |
---|
264 | Sets the DB access related fields in the JobConf.</TD> |
---|
265 | </TR> |
---|
266 | </TABLE> |
---|
267 | <A NAME="methods_inherited_from_class_java.lang.Object"><!-- --></A> |
---|
268 | <TABLE BORDER="1" WIDTH="100%" CELLPADDING="3" CELLSPACING="0" SUMMARY=""> |
---|
269 | <TR BGCOLOR="#EEEEFF" CLASS="TableSubHeadingColor"> |
---|
270 | <TH ALIGN="left"><B>Methods inherited from class java.lang.<A HREF="http://java.sun.com/javase/6/docs/api/java/lang/Object.html?is-external=true" title="class or interface in java.lang">Object</A></B></TH> |
---|
271 | </TR> |
---|
272 | <TR BGCOLOR="white" CLASS="TableRowColor"> |
---|
273 | <TD><CODE><A HREF="http://java.sun.com/javase/6/docs/api/java/lang/Object.html?is-external=true#clone()" title="class or interface in java.lang">clone</A>, <A HREF="http://java.sun.com/javase/6/docs/api/java/lang/Object.html?is-external=true#equals(java.lang.Object)" title="class or interface in java.lang">equals</A>, <A HREF="http://java.sun.com/javase/6/docs/api/java/lang/Object.html?is-external=true#finalize()" title="class or interface in java.lang">finalize</A>, <A HREF="http://java.sun.com/javase/6/docs/api/java/lang/Object.html?is-external=true#getClass()" title="class or interface in java.lang">getClass</A>, <A HREF="http://java.sun.com/javase/6/docs/api/java/lang/Object.html?is-external=true#hashCode()" title="class or interface in java.lang">hashCode</A>, <A HREF="http://java.sun.com/javase/6/docs/api/java/lang/Object.html?is-external=true#notify()" title="class or interface in java.lang">notify</A>, <A HREF="http://java.sun.com/javase/6/docs/api/java/lang/Object.html?is-external=true#notifyAll()" title="class or interface in java.lang">notifyAll</A>, <A HREF="http://java.sun.com/javase/6/docs/api/java/lang/Object.html?is-external=true#toString()" title="class or interface in java.lang">toString</A>, <A HREF="http://java.sun.com/javase/6/docs/api/java/lang/Object.html?is-external=true#wait()" title="class or interface in java.lang">wait</A>, <A HREF="http://java.sun.com/javase/6/docs/api/java/lang/Object.html?is-external=true#wait(long)" title="class or interface in java.lang">wait</A>, <A HREF="http://java.sun.com/javase/6/docs/api/java/lang/Object.html?is-external=true#wait(long, int)" title="class or interface in java.lang">wait</A></CODE></TD> |
---|
274 | </TR> |
---|
275 | </TABLE> |
---|
276 | |
---|
277 | <P> |
---|
278 | |
---|
279 | <!-- ============ FIELD DETAIL =========== --> |
---|
280 | |
---|
281 | <A NAME="field_detail"><!-- --></A> |
---|
282 | <TABLE BORDER="1" WIDTH="100%" CELLPADDING="3" CELLSPACING="0" SUMMARY=""> |
---|
283 | <TR BGCOLOR="#CCCCFF" CLASS="TableHeadingColor"> |
---|
284 | <TH ALIGN="left" COLSPAN="1"><FONT SIZE="+2"> |
---|
285 | <B>Field Detail</B></FONT></TH> |
---|
286 | </TR> |
---|
287 | </TABLE> |
---|
288 | |
---|
289 | <A NAME="DRIVER_CLASS_PROPERTY"><!-- --></A><H3> |
---|
290 | DRIVER_CLASS_PROPERTY</H3> |
---|
291 | <PRE> |
---|
292 | public static final <A HREF="http://java.sun.com/javase/6/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</A> <B>DRIVER_CLASS_PROPERTY</B></PRE> |
---|
293 | <DL> |
---|
294 | <DD>The JDBC Driver class name |
---|
295 | <P> |
---|
296 | <DL> |
---|
297 | <DT><B>See Also:</B><DD><A HREF="../../../../../../constant-values.html#org.apache.hadoop.mapred.lib.db.DBConfiguration.DRIVER_CLASS_PROPERTY">Constant Field Values</A></DL> |
---|
298 | </DL> |
---|
299 | <HR> |
---|
300 | |
---|
301 | <A NAME="URL_PROPERTY"><!-- --></A><H3> |
---|
302 | URL_PROPERTY</H3> |
---|
303 | <PRE> |
---|
304 | public static final <A HREF="http://java.sun.com/javase/6/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</A> <B>URL_PROPERTY</B></PRE> |
---|
305 | <DL> |
---|
306 | <DD>JDBC Database access URL |
---|
307 | <P> |
---|
308 | <DL> |
---|
309 | <DT><B>See Also:</B><DD><A HREF="../../../../../../constant-values.html#org.apache.hadoop.mapred.lib.db.DBConfiguration.URL_PROPERTY">Constant Field Values</A></DL> |
---|
310 | </DL> |
---|
311 | <HR> |
---|
312 | |
---|
313 | <A NAME="USERNAME_PROPERTY"><!-- --></A><H3> |
---|
314 | USERNAME_PROPERTY</H3> |
---|
315 | <PRE> |
---|
316 | public static final <A HREF="http://java.sun.com/javase/6/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</A> <B>USERNAME_PROPERTY</B></PRE> |
---|
317 | <DL> |
---|
318 | <DD>User name to access the database |
---|
319 | <P> |
---|
320 | <DL> |
---|
321 | <DT><B>See Also:</B><DD><A HREF="../../../../../../constant-values.html#org.apache.hadoop.mapred.lib.db.DBConfiguration.USERNAME_PROPERTY">Constant Field Values</A></DL> |
---|
322 | </DL> |
---|
323 | <HR> |
---|
324 | |
---|
325 | <A NAME="PASSWORD_PROPERTY"><!-- --></A><H3> |
---|
326 | PASSWORD_PROPERTY</H3> |
---|
327 | <PRE> |
---|
328 | public static final <A HREF="http://java.sun.com/javase/6/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</A> <B>PASSWORD_PROPERTY</B></PRE> |
---|
329 | <DL> |
---|
330 | <DD>Password to access the database |
---|
331 | <P> |
---|
332 | <DL> |
---|
333 | <DT><B>See Also:</B><DD><A HREF="../../../../../../constant-values.html#org.apache.hadoop.mapred.lib.db.DBConfiguration.PASSWORD_PROPERTY">Constant Field Values</A></DL> |
---|
334 | </DL> |
---|
335 | <HR> |
---|
336 | |
---|
337 | <A NAME="INPUT_TABLE_NAME_PROPERTY"><!-- --></A><H3> |
---|
338 | INPUT_TABLE_NAME_PROPERTY</H3> |
---|
339 | <PRE> |
---|
340 | public static final <A HREF="http://java.sun.com/javase/6/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</A> <B>INPUT_TABLE_NAME_PROPERTY</B></PRE> |
---|
341 | <DL> |
---|
342 | <DD>Input table name |
---|
343 | <P> |
---|
344 | <DL> |
---|
345 | <DT><B>See Also:</B><DD><A HREF="../../../../../../constant-values.html#org.apache.hadoop.mapred.lib.db.DBConfiguration.INPUT_TABLE_NAME_PROPERTY">Constant Field Values</A></DL> |
---|
346 | </DL> |
---|
347 | <HR> |
---|
348 | |
---|
349 | <A NAME="INPUT_FIELD_NAMES_PROPERTY"><!-- --></A><H3> |
---|
350 | INPUT_FIELD_NAMES_PROPERTY</H3> |
---|
351 | <PRE> |
---|
352 | public static final <A HREF="http://java.sun.com/javase/6/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</A> <B>INPUT_FIELD_NAMES_PROPERTY</B></PRE> |
---|
353 | <DL> |
---|
354 | <DD>Field names in the Input table |
---|
355 | <P> |
---|
356 | <DL> |
---|
357 | <DT><B>See Also:</B><DD><A HREF="../../../../../../constant-values.html#org.apache.hadoop.mapred.lib.db.DBConfiguration.INPUT_FIELD_NAMES_PROPERTY">Constant Field Values</A></DL> |
---|
358 | </DL> |
---|
359 | <HR> |
---|
360 | |
---|
361 | <A NAME="INPUT_CONDITIONS_PROPERTY"><!-- --></A><H3> |
---|
362 | INPUT_CONDITIONS_PROPERTY</H3> |
---|
363 | <PRE> |
---|
364 | public static final <A HREF="http://java.sun.com/javase/6/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</A> <B>INPUT_CONDITIONS_PROPERTY</B></PRE> |
---|
365 | <DL> |
---|
366 | <DD>WHERE clause in the input SELECT statement |
---|
367 | <P> |
---|
368 | <DL> |
---|
369 | <DT><B>See Also:</B><DD><A HREF="../../../../../../constant-values.html#org.apache.hadoop.mapred.lib.db.DBConfiguration.INPUT_CONDITIONS_PROPERTY">Constant Field Values</A></DL> |
---|
370 | </DL> |
---|
371 | <HR> |
---|
372 | |
---|
373 | <A NAME="INPUT_ORDER_BY_PROPERTY"><!-- --></A><H3> |
---|
374 | INPUT_ORDER_BY_PROPERTY</H3> |
---|
375 | <PRE> |
---|
376 | public static final <A HREF="http://java.sun.com/javase/6/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</A> <B>INPUT_ORDER_BY_PROPERTY</B></PRE> |
---|
377 | <DL> |
---|
378 | <DD>ORDER BY clause in the input SELECT statement |
---|
379 | <P> |
---|
380 | <DL> |
---|
381 | <DT><B>See Also:</B><DD><A HREF="../../../../../../constant-values.html#org.apache.hadoop.mapred.lib.db.DBConfiguration.INPUT_ORDER_BY_PROPERTY">Constant Field Values</A></DL> |
---|
382 | </DL> |
---|
383 | <HR> |
---|
384 | |
---|
385 | <A NAME="INPUT_QUERY"><!-- --></A><H3> |
---|
386 | INPUT_QUERY</H3> |
---|
387 | <PRE> |
---|
388 | public static final <A HREF="http://java.sun.com/javase/6/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</A> <B>INPUT_QUERY</B></PRE> |
---|
389 | <DL> |
---|
390 | <DD>Whole input query, exluding LIMIT...OFFSET |
---|
391 | <P> |
---|
392 | <DL> |
---|
393 | <DT><B>See Also:</B><DD><A HREF="../../../../../../constant-values.html#org.apache.hadoop.mapred.lib.db.DBConfiguration.INPUT_QUERY">Constant Field Values</A></DL> |
---|
394 | </DL> |
---|
395 | <HR> |
---|
396 | |
---|
397 | <A NAME="INPUT_COUNT_QUERY"><!-- --></A><H3> |
---|
398 | INPUT_COUNT_QUERY</H3> |
---|
399 | <PRE> |
---|
400 | public static final <A HREF="http://java.sun.com/javase/6/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</A> <B>INPUT_COUNT_QUERY</B></PRE> |
---|
401 | <DL> |
---|
402 | <DD>Input query to get the count of records |
---|
403 | <P> |
---|
404 | <DL> |
---|
405 | <DT><B>See Also:</B><DD><A HREF="../../../../../../constant-values.html#org.apache.hadoop.mapred.lib.db.DBConfiguration.INPUT_COUNT_QUERY">Constant Field Values</A></DL> |
---|
406 | </DL> |
---|
407 | <HR> |
---|
408 | |
---|
409 | <A NAME="INPUT_CLASS_PROPERTY"><!-- --></A><H3> |
---|
410 | INPUT_CLASS_PROPERTY</H3> |
---|
411 | <PRE> |
---|
412 | public static final <A HREF="http://java.sun.com/javase/6/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</A> <B>INPUT_CLASS_PROPERTY</B></PRE> |
---|
413 | <DL> |
---|
414 | <DD>Class name implementing DBWritable which will hold input tuples |
---|
415 | <P> |
---|
416 | <DL> |
---|
417 | <DT><B>See Also:</B><DD><A HREF="../../../../../../constant-values.html#org.apache.hadoop.mapred.lib.db.DBConfiguration.INPUT_CLASS_PROPERTY">Constant Field Values</A></DL> |
---|
418 | </DL> |
---|
419 | <HR> |
---|
420 | |
---|
421 | <A NAME="OUTPUT_TABLE_NAME_PROPERTY"><!-- --></A><H3> |
---|
422 | OUTPUT_TABLE_NAME_PROPERTY</H3> |
---|
423 | <PRE> |
---|
424 | public static final <A HREF="http://java.sun.com/javase/6/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</A> <B>OUTPUT_TABLE_NAME_PROPERTY</B></PRE> |
---|
425 | <DL> |
---|
426 | <DD>Output table name |
---|
427 | <P> |
---|
428 | <DL> |
---|
429 | <DT><B>See Also:</B><DD><A HREF="../../../../../../constant-values.html#org.apache.hadoop.mapred.lib.db.DBConfiguration.OUTPUT_TABLE_NAME_PROPERTY">Constant Field Values</A></DL> |
---|
430 | </DL> |
---|
431 | <HR> |
---|
432 | |
---|
433 | <A NAME="OUTPUT_FIELD_NAMES_PROPERTY"><!-- --></A><H3> |
---|
434 | OUTPUT_FIELD_NAMES_PROPERTY</H3> |
---|
435 | <PRE> |
---|
436 | public static final <A HREF="http://java.sun.com/javase/6/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</A> <B>OUTPUT_FIELD_NAMES_PROPERTY</B></PRE> |
---|
437 | <DL> |
---|
438 | <DD>Field names in the Output table |
---|
439 | <P> |
---|
440 | <DL> |
---|
441 | <DT><B>See Also:</B><DD><A HREF="../../../../../../constant-values.html#org.apache.hadoop.mapred.lib.db.DBConfiguration.OUTPUT_FIELD_NAMES_PROPERTY">Constant Field Values</A></DL> |
---|
442 | </DL> |
---|
443 | |
---|
444 | <!-- ============ METHOD DETAIL ========== --> |
---|
445 | |
---|
446 | <A NAME="method_detail"><!-- --></A> |
---|
447 | <TABLE BORDER="1" WIDTH="100%" CELLPADDING="3" CELLSPACING="0" SUMMARY=""> |
---|
448 | <TR BGCOLOR="#CCCCFF" CLASS="TableHeadingColor"> |
---|
449 | <TH ALIGN="left" COLSPAN="1"><FONT SIZE="+2"> |
---|
450 | <B>Method Detail</B></FONT></TH> |
---|
451 | </TR> |
---|
452 | </TABLE> |
---|
453 | |
---|
454 | <A NAME="configureDB(org.apache.hadoop.mapred.JobConf, java.lang.String, java.lang.String, java.lang.String, java.lang.String)"><!-- --></A><H3> |
---|
455 | configureDB</H3> |
---|
456 | <PRE> |
---|
457 | public static void <B>configureDB</B>(<A HREF="../../../../../../org/apache/hadoop/mapred/JobConf.html" title="class in org.apache.hadoop.mapred">JobConf</A> job, |
---|
458 | <A HREF="http://java.sun.com/javase/6/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</A> driverClass, |
---|
459 | <A HREF="http://java.sun.com/javase/6/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</A> dbUrl, |
---|
460 | <A HREF="http://java.sun.com/javase/6/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</A> userName, |
---|
461 | <A HREF="http://java.sun.com/javase/6/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</A> passwd)</PRE> |
---|
462 | <DL> |
---|
463 | <DD>Sets the DB access related fields in the JobConf. |
---|
464 | <P> |
---|
465 | <DD><DL> |
---|
466 | <DT><B>Parameters:</B><DD><CODE>job</CODE> - the job<DD><CODE>driverClass</CODE> - JDBC Driver class name<DD><CODE>dbUrl</CODE> - JDBC DB access URL.<DD><CODE>userName</CODE> - DB access username<DD><CODE>passwd</CODE> - DB access passwd</DL> |
---|
467 | </DD> |
---|
468 | </DL> |
---|
469 | <HR> |
---|
470 | |
---|
471 | <A NAME="configureDB(org.apache.hadoop.mapred.JobConf, java.lang.String, java.lang.String)"><!-- --></A><H3> |
---|
472 | configureDB</H3> |
---|
473 | <PRE> |
---|
474 | public static void <B>configureDB</B>(<A HREF="../../../../../../org/apache/hadoop/mapred/JobConf.html" title="class in org.apache.hadoop.mapred">JobConf</A> job, |
---|
475 | <A HREF="http://java.sun.com/javase/6/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</A> driverClass, |
---|
476 | <A HREF="http://java.sun.com/javase/6/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</A> dbUrl)</PRE> |
---|
477 | <DL> |
---|
478 | <DD>Sets the DB access related fields in the JobConf. |
---|
479 | <P> |
---|
480 | <DD><DL> |
---|
481 | <DT><B>Parameters:</B><DD><CODE>job</CODE> - the job<DD><CODE>driverClass</CODE> - JDBC Driver class name<DD><CODE>dbUrl</CODE> - JDBC DB access URL.</DL> |
---|
482 | </DD> |
---|
483 | </DL> |
---|
484 | <!-- ========= END OF CLASS DATA ========= --> |
---|
485 | <HR> |
---|
486 | |
---|
487 | |
---|
488 | <!-- ======= START OF BOTTOM NAVBAR ====== --> |
---|
489 | <A NAME="navbar_bottom"><!-- --></A> |
---|
490 | <A HREF="#skip-navbar_bottom" title="Skip navigation links"></A> |
---|
491 | <TABLE BORDER="0" WIDTH="100%" CELLPADDING="1" CELLSPACING="0" SUMMARY=""> |
---|
492 | <TR> |
---|
493 | <TD COLSPAN=2 BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> |
---|
494 | <A NAME="navbar_bottom_firstrow"><!-- --></A> |
---|
495 | <TABLE BORDER="0" CELLPADDING="0" CELLSPACING="3" SUMMARY=""> |
---|
496 | <TR ALIGN="center" VALIGN="top"> |
---|
497 | <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="../../../../../../overview-summary.html"><FONT CLASS="NavBarFont1"><B>Overview</B></FONT></A> </TD> |
---|
498 | <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="package-summary.html"><FONT CLASS="NavBarFont1"><B>Package</B></FONT></A> </TD> |
---|
499 | <TD BGCOLOR="#FFFFFF" CLASS="NavBarCell1Rev"> <FONT CLASS="NavBarFont1Rev"><B>Class</B></FONT> </TD> |
---|
500 | <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="class-use/DBConfiguration.html"><FONT CLASS="NavBarFont1"><B>Use</B></FONT></A> </TD> |
---|
501 | <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="package-tree.html"><FONT CLASS="NavBarFont1"><B>Tree</B></FONT></A> </TD> |
---|
502 | <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="../../../../../../deprecated-list.html"><FONT CLASS="NavBarFont1"><B>Deprecated</B></FONT></A> </TD> |
---|
503 | <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="../../../../../../index-all.html"><FONT CLASS="NavBarFont1"><B>Index</B></FONT></A> </TD> |
---|
504 | <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="../../../../../../help-doc.html"><FONT CLASS="NavBarFont1"><B>Help</B></FONT></A> </TD> |
---|
505 | </TR> |
---|
506 | </TABLE> |
---|
507 | </TD> |
---|
508 | <TD ALIGN="right" VALIGN="top" ROWSPAN=3><EM> |
---|
509 | </EM> |
---|
510 | </TD> |
---|
511 | </TR> |
---|
512 | |
---|
513 | <TR> |
---|
514 | <TD BGCOLOR="white" CLASS="NavBarCell2"><FONT SIZE="-2"> |
---|
515 | PREV CLASS |
---|
516 | <A HREF="../../../../../../org/apache/hadoop/mapred/lib/db/DBInputFormat.html" title="class in org.apache.hadoop.mapred.lib.db"><B>NEXT CLASS</B></A></FONT></TD> |
---|
517 | <TD BGCOLOR="white" CLASS="NavBarCell2"><FONT SIZE="-2"> |
---|
518 | <A HREF="../../../../../../index.html?org/apache/hadoop/mapred/lib/db/DBConfiguration.html" target="_top"><B>FRAMES</B></A> |
---|
519 | <A HREF="DBConfiguration.html" target="_top"><B>NO FRAMES</B></A> |
---|
520 | <SCRIPT type="text/javascript"> |
---|
521 | <!-- |
---|
522 | if(window==top) { |
---|
523 | document.writeln('<A HREF="../../../../../../allclasses-noframe.html"><B>All Classes</B></A>'); |
---|
524 | } |
---|
525 | //--> |
---|
526 | </SCRIPT> |
---|
527 | <NOSCRIPT> |
---|
528 | <A HREF="../../../../../../allclasses-noframe.html"><B>All Classes</B></A> |
---|
529 | </NOSCRIPT> |
---|
530 | |
---|
531 | |
---|
532 | </FONT></TD> |
---|
533 | </TR> |
---|
534 | <TR> |
---|
535 | <TD VALIGN="top" CLASS="NavBarCell3"><FONT SIZE="-2"> |
---|
536 | SUMMARY: NESTED | <A HREF="#field_summary">FIELD</A> | CONSTR | <A HREF="#method_summary">METHOD</A></FONT></TD> |
---|
537 | <TD VALIGN="top" CLASS="NavBarCell3"><FONT SIZE="-2"> |
---|
538 | DETAIL: <A HREF="#field_detail">FIELD</A> | CONSTR | <A HREF="#method_detail">METHOD</A></FONT></TD> |
---|
539 | </TR> |
---|
540 | </TABLE> |
---|
541 | <A NAME="skip-navbar_bottom"></A> |
---|
542 | <!-- ======== END OF BOTTOM NAVBAR ======= --> |
---|
543 | |
---|
544 | <HR> |
---|
545 | Copyright © 2009 The Apache Software Foundation |
---|
546 | </BODY> |
---|
547 | </HTML> |
---|